CONNECTION BUSY
How do I resolve [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt problem. This is coming only if I am executing a no. of SQLs in quick succession. Please Help. Regards Gurmeet -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: CONNECTION BUSY
Yes, you are right . I am using JDBC-ODBC bridge. Regards Gurmeet -Original Message- From: Reynir Hübner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:17 PM To: Tomcat Users List Subject: RE: CONNECTION BUSY The errormessage implies that you are using odbc bridge to access MsSQL. If so, you might want to switch over to a native JDBC driver (for example the merant / Microsoft driver). Please post more informations on which JDBC driver you are using. - reynir -Original Message- From: Gurmeet [mailto:[EMAIL PROTECTED]] Sent: 12. mars 2002 10:45 To: Tomcat Users List Subject: CONNECTION BUSY How do I resolve [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt problem. This is coming only if I am executing a no. of SQLs in quick succession. Please Help. Regards Gurmeet -- 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]
RE: CONNECTION BUSY
[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt problem. This is coming only if I am executing a no. of SQLs in quick succession. The odbc bridge is not serialisable. That is to say, all requests are queued and answered one by one. If this is a problem, then use a proper driver. J. -- You're only jealous cos the little penguins are talking to me. h®j+z)ߢ¹¶*'¢s«vv§qä®®÷²¦º¹Ëljwlz»âqë/È¢êðy»µæÛiÿü0ÂÝ©ÜzË«½ì¢é
RE: CONNECTION BUSY
Please tell me which one and where can I get it? Regards Gurmeet -Original Message- From: Justin Rowles [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:26 PM To: Tomcat Users List Subject: RE: CONNECTION BUSY [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt problem. This is coming only if I am executing a no. of SQLs in quick succession. The odbc bridge is not serialisable. That is to say, all requests are queued and answered one by one. If this is a problem, then use a proper driver. J. -- You're only jealous cos the little penguins are talking to me. ~?j ? o v -? O .?+^jm? 0 z r -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: CONNECTION BUSY
the JDBC-ODBC bridge is not suitable for production, it's only for testing. I must recomend that you look at other ways of comunicating with your database. http://www.microsoft.com/sql/downloads/2000/jdbc.asp This would be the free driver you would use for microsoft SQL, but it is only a beta version. if you have some money in your pockets you could look at datadirect technologies (www.datadirect-technologies.com), or atinav.com. The microsoft driver is a previous version of the datadirect technologies driver. hope it helps -reynir -Original Message- From: Gurmeet [mailto:[EMAIL PROTECTED]] Sent: 12. mars 2002 10:55 To: Tomcat Users List Subject: RE: CONNECTION BUSY Yes, you are right . I am using JDBC-ODBC bridge. Regards Gurmeet -Original Message- From: Reynir Hübner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:17 PM To: Tomcat Users List Subject: RE: CONNECTION BUSY The errormessage implies that you are using odbc bridge to access MsSQL. If so, you might want to switch over to a native JDBC driver (for example the merant / Microsoft driver). Please post more informations on which JDBC driver you are using. - reynir -Original Message- From: Gurmeet [mailto:[EMAIL PROTECTED]] Sent: 12. mars 2002 10:45 To: Tomcat Users List Subject: CONNECTION BUSY How do I resolve [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt problem. This is coming only if I am executing a no. of SQLs in quick succession. Please Help. Regards Gurmeet -- 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]
RE: CONNECTION BUSY
thanks a ton Reynir -Original Message- From: Reynir Hübner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:29 PM To: Tomcat Users List Subject: RE: CONNECTION BUSY the JDBC-ODBC bridge is not suitable for production, it's only for testing. I must recomend that you look at other ways of comunicating with your database. http://www.microsoft.com/sql/downloads/2000/jdbc.asp This would be the free driver you would use for microsoft SQL, but it is only a beta version. if you have some money in your pockets you could look at datadirect technologies (www.datadirect-technologies.com), or atinav.com. The microsoft driver is a previous version of the datadirect technologies driver. hope it helps -reynir -Original Message- From: Gurmeet [mailto:[EMAIL PROTECTED]] Sent: 12. mars 2002 10:55 To: Tomcat Users List Subject: RE: CONNECTION BUSY Yes, you are right . I am using JDBC-ODBC bridge. Regards Gurmeet -Original Message- From: Reynir Hbner [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 12, 2002 4:17 PM To: Tomcat Users List Subject: RE: CONNECTION BUSY The errormessage implies that you are using odbc bridge to access MsSQL. If so, you might want to switch over to a native JDBC driver (for example the merant / Microsoft driver). Please post more informations on which JDBC driver you are using. - reynir -Original Message- From: Gurmeet [mailto:[EMAIL PROTECTED]] Sent: 12. mars 2002 10:45 To: Tomcat Users List Subject: CONNECTION BUSY How do I resolve [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt problem. This is coming only if I am executing a no. of SQLs in quick succession. Please Help. Regards Gurmeet -- 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] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Help ! Connection busy
I am getting [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another h stmt How do I get rid of this? Regards Gurmeet -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Help ! Connection busy
You have to explicitly close your JDBC statements and connections when you are done with them. Make sure you are using these for Statement and Connection, respectively: stmt.close(); //and conn.close(); --- Gurmeet [EMAIL PROTECTED] wrote: I am getting [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another h stmt How do I get rid of this? Regards Gurmeet -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]