GeeCON Prague 2014*
The moose likes JDBC 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
Bookmark "ResultSet and closing connection" Watch "ResultSet and closing connection" New topic
Author

ResultSet and closing connection

Chris Klu
Greenhorn

Joined: Jan 03, 2001
Posts: 18
I started a thread in the Servlets forum that should be here. http://www.javaranch.com/ubb/Forum7/HTML/001563.html
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?
 
GeeCON Prague 2014
 
subject: ResultSet and closing connection