Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

coldfusion can't find java/sql/savepoint

214714Oct 29 2002 — edited Dec 22 2002
Hi,

I'm using WinXP with Coldfusion MX Pro and Oracle 9i Personal. I am trying to get CF to connect up to Oracle using the thin JDBC driver. When I try to set up the db as a datasource it keeps telling me in can't find the java/sql/Savepoint class:

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 have the CF administrator Java and JVM classpath set as this:

C:\jwsdp-1_0_01\lib,c:\j2sdk1.4.0_01\lib,c:\j2sdk1.4.0_01\bin,c:\oracle\ora92\jdbc\lib\ojdbc14_g.jar,c:\oracle\ora92\jdbc\lib\nls_charset12.zip,c:\oracle\ora92\jdbc\lib\classes12.zip,


What am I missing? And I don't understand when I'm in Windows Explorer in the jdbc/lib directory, the classes11.zip and classes11_g.zip show a subdirectory (/oracle) but the classes12.zip doesn't. I tried to unzip it with WinZip, but it still didn't look the same. I'm assuming these are some sort of "special" zip files.

Any help would be greatly appreciated. ****Greatly!!**** I've posted to coldfusion boards and newsgroups and have gotten no answers yet. I'm developing a large lump on my head from the incessant banging.........

Thanks in advance,
Pat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2003
Added on Oct 29 2002
2 comments
514 views