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()+"'";
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
