It's not a secret anymore!
The moose likes JDBC and the fly likes ResultSet and closing connection Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Reply 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://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: ResultSet and closing connection
 
Similar Threads
new in jsp
servlet chaining
doGet() & doPost()
Reading XML String from JSP, using as input to parse with XSL file
storing and retriveing image through Ms-sql