File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

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?
subject: ResultSet and closing connection
Similar Threads
servlet chaining
new in jsp
storing and retriveing image through Ms-sql
doGet() & doPost()
Reading XML String from JSP, using as input to parse with XSL file