Versions Compared

Old Version 1

changes.mady.by.user Ryann A. Levo

Saved on

compared with

New Version 2

changes.mady.by.user Ryann A. Levo

Saved on

Key

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

If you need to connect to an Oracle database from Coldfusion

...

10 the following are some recommendations on how to configure your connection.

1. What you need to know before setting up a DSN (Data Source Name) in your Coldfusion 10 environment:

  • The Database OID entry. You can get this from your current DSN if you're already using Coldfusion, or contact the DBA group (dba-support@cornell.

...

  1. Use Oracle JDBC with OID
  2. Use Macromedia without OID
  3. Using Macromedia with JDBC connection string - to allow failover if your databases are in a RAC configuration

1. Using Oracle JDBC with OID

...

  • edu)
  • Database credentials (username and password)
  • Version of Oracle database (this helps with troubleshooting or providing support)
  • If NOT using OID, then the server that your database lives on

2. CIT Hosting recommends customers use the OID connection string and the Oracle JDBC drivers with Coldfusion 10

  • 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. Please contact dba-support@cornell.edu for more information on when you Oracle database will be upgraded.

3. Using Oracle JDBC with OID

  1. To install an Oracle JDBC driver (i.e. Oracle 12g), 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 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

It is not possible to specify more than one OID ldap server.

...