This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Access 97 problem with JDK 1.3 and up Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Access 97 problem with JDK 1.3 and up" Watch "Access 97 problem with JDK 1.3 and up" New topic

Access 97 problem with JDK 1.3 and up

Jason Moore

Joined: Sep 11, 2001
Posts: 10
I am implementing a client-server database application using Oracle8i in the production environment and occassionally using Access97 on my own machine for testing. If I stick to JDK1.2.2 I'm fine, but if I try to use any of the newer JDK's, then I always get this error when I try to connect to the Access database:
ResultSet is closed
This only occurs with Access97. I can use any version of the JDK with Oracle.
The reason I ask the question is that I've run into another problem with JDK1.2.2 and Access that is supposedly resolved if you use a newer version of the JDK.
I'd appreciate it if anyone can shed some light on this problem.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

there are so many different problems with access that you will have to post the offending code to give you an answer.
-could be that you can only have one statement open for each connection...if you try to open another statement it closes the original statement(which in turn closes the resultset that you may be using)...
If you are used to working on Oracle and are moving to access for testing I suggest you search the forum in advance to alert you to the many problems programmers encounter over and over...just so you don't pull your hair out saying "I swear this code worked with Oracle!!?? why is it flubbing out now??"
I agree. Here's the link:
subject: Access 97 problem with JDK 1.3 and up
Similar Threads
JDBC Driver for acces97 (but not jdbc-odbc bridge)
2 Years since downloading exam and jdk
jdbc-odbc bridge problem
Mail merge & pagemaker
ByteArray to String Conversion?