The moose likes JDBC and Relational Databases and the fly likes ResultSet and closing connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ResultSet and closing connection" Watch "ResultSet and closing connection" New topic

ResultSet and closing connection

Chris Klu

Joined: Jan 03, 2001
Posts: 18
I started a thread in the Servlets forum that should be here.
On my machine, I am running some code that queries a db and assigns the result to a ResultSet. After closing the db connection, the ResultSet is then used for some output. It works fine on my system. However, on another person's machine it returns an error unless the connection is closed after using ResultSet.
Since we are using different databases the drivers and db parameters are different. Could someone explain the problem?
I agree. Here's the link:
subject: ResultSet and closing connection
It's not a secret anymore!