I've received this message when I ran a loop through a ResultSet and tried
to use the same Statement object to run an update.
It sounds as if you are trying to run a query or an update from the same
statement object that you are currently using like when you're in a loop or
something. Make sure that you are creating separate Statement objects for
each query or update or else use a driver that caches the result set and
lets you run other commands on the same statement.
I've found a few picky MS SQL drivers, one of which I had to actually create
a new Connection object for one of my updates. Who knows why? Anyway, you
may want to try this if the above fails.
Matt
On Sun, 29 Jul 2001, naidu wrote:
> hi all,
>
> please help us to find a solution for the following error coming out when
> we are trying to execute a sql statement,
>
> S1000: [Microsoft][ODBC SQL Server Driver] Connection is busy with results
> for another hstmt
>
>
> scenario:
> In a servlet we are using multiple sql statement with single connection,
> we have tried both the ways of Preparedtatement and direct statement(simple)
> still the error persists.
> We are using the MSSQL server as database, the driver used is Sun JDBC-ODBC
> bridge driver.
>
> thanks in advance for the help.
>
> Regards
> Naidu Babu.
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
