This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
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


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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?
 
I agree. Here's the link: http://kickstarter.com/rocket-mass-heater
 
subject: ResultSet and closing connection