Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Billa
Starting Member
2 Posts |
 Posted - 2007-10-11 : 02:53:00
|
| Hi,When i tried to retreive Datas from Sql Server continously(connection pooling), I got an Exception like "java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt". After restarting the Tomcat server, it starts to work fine.I don know what is happening behind the screen. Let me know the nature of this Exception and the Solution to this kind of Exception.. Plz as soon as possible.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-11 : 03:11:47
|
You can't re-use handle for statement while data is still processed.Either check for status of COMMAND object, or disable the button until resultset is returned.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Connection is busy with results for another hstmt