...
- The Cornell Stack provides the ojdbc7.jar in the Coldfusion path for customers to use.
- If you want to install a newer Oracle JDBC driver than what we provide, you'll need to upload a "jar" file that contains the updated driver to your hosting environment. This can be done by downloading the driver from Oracle's website (odbc7.jar for Java 1.7) and uploading the file into your "jars" directory (next to your htdocs directory) via your webdav client. Once the file is uploaded you'll need to restart your Coldfusion instance using the Hosting Dashboard
- When creating your DSN for the Oracle JDBC driver you will need to specify the "Other" Data Source when configuring Coldfusion via CFADMIN
- In CFADMIN, go to Data & Services then click on Data Sources
- Under Add New Data Source, enter a Name and select "Other" for the driver. Then click Add.
JDBC URL: All entries will be of the form jdbc:oracle:thin:@ldaps@ldap://oid.cit.cornell.edu:636389/<OID_entry_from_DBA_group>,cn=oraclecontext (put the OID entry from the DBA group after the slash, and before the comma )
- Driver Class: Must be: oracle.jdbc.OracleDriver
- Driver Name: Can be anything most people just copy the Driver Class entry
- Username and Password: Provided to you from the DBA Group
- You do not need to specify more than one OID server, ldapsldap://oid.cit.cornell.edu:636 389 is a loadbalanced service and will handle the failover for those databases configured in a RAC environment.
...