Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> can't find oracle.jdbc, java.sql packages
Cross posted on the Macromedia Support Forum board and
alt.comp.lang.coldfusion and alt.databases.oracle.misc, so far no luck
there)
Hello,
I have been pounding my head on my desk for days now, trying to get CFMX (Pro) to talk to Oracle. I found lots of help online and finally got rid of this error:
The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info
****but*** now get this one:
Connection verification failed for data source: oradata1 []java.lang.NoClassDefFoundError: java/sql/Savepoint The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint
I found an OracleSavepoint class in a bunch of places and put some of them
in the Java/JM classpath in Administrator, but still no go. These are some
of my settings in the datasource entry forms:
*Classpath (hey, this stuff isn't my forte, I just put in lots of paths that
have been suggested out on the Web - this is actually my Windows XP system
classpath that finally got Java and CFMX to run-I'm sure there's much
extraneous junk here)
C:\jwsdp-1_0_01\lib,c:\j2sdk1.4.0_01\lib,c:\cfusionmx\runtime\lib,c:\cfusion mx\runtime\jre\bin,c:\cfusionmx\lib\cfx.jar,c:\j2sdk1.4.0_01\bin,c:\oracle\o ra92\jdbc\lib\ojdbc14.jar,c:\oracle\ora92\jdbc\lib\nls_charset12.zip,c:\orac le\ora92\jdbc\lib\classes12.zip,
*and the jdbc url (I've also tried by listener.ora host name of PAT_1800):
jdbc:oracle:thin:@localhost:1521:oradata1
*and the Driver Class:
oracle.jdbc.driver.OracleDriver
Thanks in advance,
Pat
Received on Tue Oct 29 2002 - 21:22:41 CST