Can I use more than one Resultset objects through as many Statement objects using a single Connection object...when i am doing this ,there is an error message" connection is already busy with another statement". Please help me to sort it out

10 Years
Discussion Span
Last Post by masijade

that would be one resultset per statement, not per connection.

multiple resultset are working only when all other except one are closed ...but my requirement is to keep all the resultsets open simultaneously . can this be possible..?


If they are coming from the same statement, no. The API clearly says that any time a statement executes a query, all previous resultsets will be closed. Multiple statements on the same connection will allow you to have multiple resultsets. One per statement. However, as has been pointed out, if you are using the JDBC-ODBC bridge you may only have one statement at a time.

What DB are connecting to, and what Driver are you using?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.