Versions Compared

Old Version 2

changes.mady.by.user Ryann A. Levo

Saved on

compared with

New Version Current

changes.mady.by.user Ryann A. Levo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • This differs from Coldfusion 9 due to the fact that Adobe does not officially support Oracle 12g database connections with their delivered Oracle drivers.
    • Our initial testing does show the delivered Oracle drivers can work with Oracle 12g databases, however we have not fully exercised the drivers nor can we provide support if issues are found when connecting to a 12g database with the Adobe delivered drivers.
  • Customers will need to download the Oracle driver for oracle.com (file name ojdbc7.jar for Java 1.7 support). We would recommend the ojdbc7.jar file for Oracle 12g databases since all hosted Oracle databases will be upgraded from 11.x to 12 in the coming months (Cornell Stack comes with the ojdbc7.jar file already installed). Please contact dba-support@cornell.edu for more information on when you Oracle database will be upgraded.

3. Using Oracle JDBC with OID

  1. The Cornell Stack provides the ojdbc7.jar in the Coldfusion path for customers to use.
    1. If you want to install a newer Oracle JDBC driver than what we provide
    To install an Oracle JDBC driver (i.e. Oracle 12g)
    1. , 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
  2. When creating your DSNfor DSN for the Oracle JDBC driver you will need to specify the "Other" Data Source when configuring Coldfusion via CFADMIN
    1. In CFADMIN, go to Data & Services then click on Data Sources

Image Removed

...

    2. Under Add New Data Source, enter a Name and select "Other" for the driver.  Then click Add.

    3. JDBC URL:  All entries will be of the form  jdbc:oracle:thin:@ldap://oid.cit.cornell.edu:389/<OID_entry_from_DBA_group>,cn=oraclecontext   (put the OID entry from the DBA group after the slash, and before the comma )

    4. Driver Class: Must be:  oracle.jdbc.OracleDriver
    5. Driver Name:  Can be anything most people just copy the Driver Class entry
    6. Username and Password:  Provided to you from the DBA Group
  • You do not need to specify more than one OID

...

  • server, ldap://oid.cit.cornell.edu:389 is a loadbalanced service and will handle the failover for those databases configured in a RAC environment.

4

You'll also need need to disable "Sandbox Security" (it is unknown why this is a problem, this does not always "fix" the problem).

Image Removed

2. Using Macromedia with OID

If you choose to use the built-in Oracle driver you will need to use the Oid Lookup tool to retrieve the servername of the backend database.   Please note that if the backend database moves you will need to update your connection information!

Image Removed

Image Removed

Image Removed

3. Using Macromedia with JDBC connection string - to allow failover if your databases are in a RAC configuration

If you have your databases in a RAC setup with CIT DBA's and OID is not working for you, here is an example of a jdbc connection string to use. You'll need to use the above OID lookup tool to find the hostnames and service name.

jdbc:macromedia:oracle://host1-vip.serverfarm.cornell.edu:1521;SERVICENAME=mydb11g.cit.cornell.edu;sendStringParametersAsUnicode=false;MaxPooledStatements=1000;AlternateServers=(host1-vip.serverfarm.cornell.edu,host2-vip.serverfarm.cornell.edu)

To enter the above, in CFAdmin, Create a new DSN and you'll need to choose "Other" in the DSN Driver. In the new window, enter your DSN name, the jdbc URL/connection string (however it looks from above), Driver Class should be "macromedia.jdbc.MacromediaDriver", Driver Name can be whatever you choose, and then the appropriate username and password to access.

Installing updated Oracle JDBC Drivers

If you need to install an updated Oracle JDBC driver (i.e. Oracle 12g), you'll need to upload a "jar" file that contains the updated driver to your hosting environment.

NOTE: This is not the recommended driver to use if your Oracle databases are version 12g. CIT Database Group prefers all customers to use the Oracle ojdbc7.jar file mentioned above.

Image Added

Image Added

Image AddedThis can be done by downloading the driver from Oracle's website (odbc6.jar for Java 1.6 or odbc7.jar for Java 1.7) and uploading the file into your "jars" directory (next to your htdocs directory). Once the file is uploaded you'll need to restart your Coldfusion instance using the Hosting Dashboard.