Are u using the same JDBC-ODBC bridge in case of oracle and Access also? Anyway this problem comes becuase JDBC-ODBC bridge drivers are not serialisable.
Gurmeet -----Original Message----- From: Sudhir Kumar [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 9:07 AM To: 'Tomcat Users List' Subject: Problem with SQL Hi, I have a problem with the SQL Database. I have connected to SQL server through JDBC-ODBC bridge. In the code since i need to fetch the data inside a number of loops one inside the other , i have used 5 different resultset objects , 5 statement onjects and a single connection object. In each loop i am fetching data from different tables. The code is working fine with Oracle 8 and MS Access Database. But SQl is throwing this exception, Can any one help me out...?? The Exception is : java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt Thanks in advance.. Sudhir -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>