wood burning stoves 2.0*
The moose likes JDBC and the fly likes ms-access & tomcat Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ms-access & tomcat" Watch "ms-access & tomcat" New topic
Author

ms-access & tomcat

willineuer
Greenhorn

Joined: Aug 08, 2002
Posts: 2
hi all!
I face the following problem: for testing purposes I ported an existing (and working) webapp (linux/mysql & solaris/oracle) to windows98/ms-access (yuck...) I use the jdbc-odbc-bridge.
loading of the driver etc. is all working fine, the same goes for forward-only result sets (statement created with conn.createStatement();
PROBLEM: as soon as I use conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY)
to create a scrollable ResultSet, tomcat crashes without any further notice as soon as I issue an executeQuery(...) call with this statement. no exception, no nothing.
anyone who faced a problem like this? does the bridge perhaps not support anything beyond
"forward only" ResultSets? is it a Win98-problem or a tomcat problem?
any hints are appreciated!
thanx & greetings to all
willineuer
Greenhorn

Joined: Aug 08, 2002
Posts: 2
FYI, figured it out myself. with a small standalone test program I got an exception,
(which is curiously enough not displayed by
tomcat...)
this exception is risen outside the VM in some .dll (with the usual windoze hassle: "reason: unknown, source: unknown" ...) all I could find out was that it only arises int he 4.0 VM (sun SDK) with the test program.
so I re-deployed tomcat with the SDK 1.3.1 and it works all right.... funny. will perhaps file that as a bug on java.sun.com.
cheers
 
Don't get me started about those stupid light bulbs.
 
subject: ms-access & tomcat
 
Similar Threads
Set Cursor Type JDBC:ODBC bridge
Problem with locks while using iBATIS with MS Access through JDBC-ODBC bridge
how to connect to MS-Access using weblogic 6.1
JVM crash
Exception when reading image( using getBLOB ) from database