For CFMX Enterprise and Professional
- Save the classes12.zip file to {CFMX_HOME}WEB-INFlib
- Edit the JVM Java page in CFAdmin,
- Add {CFMX_HOME}WEB-INFlibclasses12.zip to the class path
- Restart the CFMX App server
- Add datasource using the "other" driver
- JDBC URL: jdbc:oracle:thin:@[dbservername]:1521:[SID]
- Driver Class: oracle.jdbc.driver.OracleDriver
- Configure username, password, submit
For CFMX J2EE (WebSphere in this case)
- save the classes12.zip file to {WAS_HOME}AppServerlib
- open the WAS admin console
- add {WAS_HOME}AppServerlibclasses12.zip to the class path in WAS Console, submit, then save changes.
- restart the WAS server
- Add datasource in CFAdmin using the "other" driver
- JDBC URL: jdbc:oracle:thin:@[dbservername]:1521:[SID]
- Driver Class: oracle.jdbc.driver.OracleDriver
- Configure username, password, submit