Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2610
  • Last Modified:

Setting Coldfusion ClassPath for Oracle 11g client for oracle datasource

I'm migrating from a w2003 server with oracle 9 client/ CF7 to a new box w2008R2 server with Oracle 11g / CF9.
I'm setting up my data sources and in the original box I had to tell CF where to find the JDBC info.  The CF classpath had:
e:\oracle\ora92\jdbc\lib\classes12.zip,"C:\CFusionMX7\lib\macromedia_drivers.jar"
Where do I find these equivalents for my new server box?
The oracle directory has both 32 and 64 bit loaded.  The sever is running 64bit OS.
The directory C:\oracle\product\64bit_11.2.0client\jdbc\lib has these jar files:
ojdbc5.jar
ojdbc5dms.jar
ojdbc5dms_g.jar
ojdbc5_g.jar
ojdbc6.jar
ojdbc6dms.jar
ojdbc6dms_g.jar
ojdbc6_g.jar
simplefan.jar

My CF datasource uses:
Other
jdbc url:  jdbc:oracle:oci:@mydb
driver class:  oracle.jdbc.OracleDriver
0
E43509
Asked:
E43509
1 Solution
 
E43509Author Commented:
I opted for this classpath
C:\oracle\product\64bit_11.2.0client\jdbc\lib\ojdbc6.jar
I'm not a java guru but this is how I came to select that jar file
Verfiy the Java Version under CF Admin/ Server Settings/ Settings Summary, in this case it was 1.6.0_14
Look under the oracle client install C:\oracle\product\64bit_11.2.0client\jdbc\readme.txt.  There will be a note as to which jar file to use based on the JDK.  The ojdbc6 was good for 1.6 java.
Under server settings/Java and JVM, in the ColdFusion Class Path add:
C:\oracle\product\64bit_11.2.0client\jdbc\lib\ojdbc6.jar

I also found the location of the old macromedia drivers C:\ColdFusion9\lib\macromedia_drivers.jar but opted not to include them in the path.  My Data source is now working.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now