coldfusion can't find java/sql/savepoint
214714Oct 29 2002 — edited Dec 22 2002Hi,
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