• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Bear Bibeault
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Ganesh Patekar
  • Frits Walraven
  • Tim Moores
  • Ron McLeod
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
  • Tim Holloway

Access 97 problem with JDK 1.3 and up  RSS feed

Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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??"
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!