HI,


I have one error in jsp-jdbc .Here i use two query, one select query and one update query.The error is,
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt .

Anybody can you help to rectify that problem.Urgently i need.
Thank you

Hi!

SQL Server only supports a single active statement per connection. Make sure that one statement is closed before next one.

So, If you are trying to use multiple statements per connection then you need to use multiple connections for that purpose.

I am well known of ODBC related problem, but, JDBC is not well known. This problem comes with Forward-only cursors in ODBC.
Forward-only cursors don't support multiple concurrent active statements because SQL Server returns the default result set when a cursor is set to forward-only. This result set must be processed before another statement can be issued, which limits the client to one active SQL statement at a time.

Finally, I can say, you should close one statement before you start with other.

If this helped you, don't forget to reply.