Hi I'm trying to setup an oracle

[doco]

Hi

I'm trying to setup an oracle thin client driver on cold fusion MX. i'm on oracle 8 and the oracle thin jdbc jdk driver is installed

i've followed the instructions on macromedia web site

my oracle client is on F: AND I've pointed the class path to
F:\Oracle\jdbc\lib\classes12.zip, in JAVA JVM

I've added a 'other' datasource with the suggested bits and pieces but when i submit i get the folowing message:

Connection verification failed for data source: test
[]java.sql.SQLException: No suitable driver available for test, please check the driver setting in jrun-resources.xml, error: oracle.jdbc.OracleDriver
The root cause was that: java.sql.SQLException: No suitable driver available for test, please check the driver setting in jrun-resources.xml, error: oracle.jdbc.OracleDriver

any ideas???????

thanks

chris

 

[fabbby]

I had the same problem as you BUT with Solaris 8 and Oracle 9.2.0.
I found that the class path to the classes12.zip file did not appear in the Settings Summary Report.
I found that the path was stored in a file jvm.config.
This file exists at 2 locations:
<ColdFusion MX homedir>/bin
and
<ColdFusion MX homedir>/runtime/bin.
The first being a link to the second on a server where the OCI driver was working.
From the /bin directory, I typed:
ln -s /opt/coldfusionmx/runtime/bin/jvm.config .
This created this link in the directory:
jvm.config -> /opt/coldfusionmx/runtime/bin/jvm.config
Anyway make sure the path to your class is in both jvm.config,
in the section JVM ClassPath.
And that it appears in the Settings Summary in the section Java Class Path.

 

[ecobb]

I recently set up CFMX with an Oracle 8i database, and after about a day and half of fighting with it, this what I had to do.

1) Make sure you have the JVM Class Path set up correctly in the &quot;Java and JVM&quot; portion of the CF Admin.

2) As you said, in the CF Admin select &quot;Other&quot; as your datasource. For the JDBC URL type the following: jdbcracle:thin0.0.0.0:1521rcl
(where 0.0.0.0 is the IP address of your Oracle Server. I think you can put a server's name here as well, but I just used the IP)
For &quot;Driver Class&quot;, type: oracle.jdbc.OracleDriver
For &quot;Driver Name&quot;, type: oracle
Then add your username and password in the appropriate fields.



Hope This Helps!

Ecobb
- I hate computers!

 

[ck969]

I'm using Oracle OCI driver for MX6.1 on solaris, however, I could not setup a datasource and this is the error i got:

Connection verification failed for data source: adminforms
[]java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection

and I've check the jvm.config file, it points to the correct <oracle_path>/jdbc/lib/classes.zip path.

I could not see why, any clue ?

 

[ecobb]

Can you ping the Oracle server from the CF Server? It sounds more like ColdFusion can't find the Oracle server.

Hope This Helps!

Ecobb

&quot;Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.&quot; - Homer Simpson