naidu,
The JDBC-ODBC bridge is really not sufficient for a production environment.
For one thing, the bridge driver is NOT a multi-threaded driver, secondly it
is a Type I driver (see Sun's site regarding the definitions of Type I thru
Type IV drivers). You have to write your own classes to implement a thread
pool, and then pull a "connection thread" from your thread pool in order to
execute a SQL statement. The reason you are getting the error is that your
single threaded model is currently "busy" obtaining a result set for your
previous request.
If you are developing for a production environment, I strongly suggest you
look into purchasing a Type III or IV driver for MS SQLServer.
Celeste
-----Original Message-----
From: naidu [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 2:37 AM
To: [EMAIL PROTECTED]
Subject:
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: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
