Re: SQLException

[Chris Pratt]

Sounds like you may have a threading problem.  You can't use the same connection in multiple threads simultaneously.

    (*Chris*)

 

----- Original Message -----

From: qian jianhua

To: [EMAIL PROTECTED]

Sent: Thursday, April 29, 1999 10:17 PM

Subject: SQLException

I am writing a servlet using a Statement to access the DB, here is my code:

Statement stmt=con.createStatement();
String query="select customer_num from customer where           customer_ID='"+name.trim()+"'";             

ResultSet rs=stmt.executeQuery(query);

 

name is the String I transformed to the servlet from the form in my .html file. When I submit, the program can't get through the part above, and throw the following exception:

 

SQLException:S1000 [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt 0

 

I wonder who can tell me what is the meaning of this exception, what is the reason, and how to avoid it.

 

Thank you.

Qian. 1999.4.30