|
REPLY
Error message 'Connection is busy with results for another hstmt'
mkercsmar |
Posted: 07/28/2006 10:25
|
I am using DataBrowser to view data on a MS SQL server. My PC is runing XP SP1. I can connect to the database no problem, but when I try to view the data in the tables, I get the following error (from the log):
Any ideas?
10:22:30.125 [QueryThread] D3: About to execute SELECT * FROM tblEventLog
10:22:30.125 [QueryThread] E1: SQLCode: 0 SQLState: S1000
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at com.jet.apps.databrowser.database.QueryThread.run(QueryThread.java:190)
10:22:30.125 [QueryThread] D3: Closing RSTableModel...
10:22:30.125 [QueryThread] D3: Updating table with 0 rows
10:22:30.125 [QueryThread] D3: Headers shows 0 columns.
10:22:30.125 [QueryThread] D3: Updating table structure
10:22:30.125 [QueryThread] D3: Sorter: tableChanged
10:22:30.125 [QueryThread] D3: Closing RSTableModel...
10:22:30.125 [QueryThread] D3: Updating table with 0 rows
10:22:30.125 [QueryThread] D3: Headers shows 0 columns.
10:22:30.125 [QueryThread] D3: Updating table data
10:22:30.125 [QueryThread] D3: Sorter: tableChanged
10:22:31.578 [QueryThread] D3: Shutting down the QueryThread
10:22:31.578 [QueryTimer] D3: Stopping query time updater
|
|
Re: Error message 'Connection is busy with results for another hstmt'
bemowski |
Posted: 07/29/2006 07:34
|
The error seems to be related to the ODBC driver... I can't really comment - I've never seen that before. Can you attach the full log - it could be an unclosed shatement, but I doubt it as databrowser has been around for years and I've never heard of this one.
I would suggest trying to use the standard MySQL type 4 drivers. You need to download this from the mysql site. Get the correct version (close to your mysql server version). Here is the 3.1 version for use with 3 and 4 I believe:
http://dev.mysql.com/downloads/connector/j/3.1.html
Once you have the driver, instll it in the classpath. I use the databrowser GUI to do this, in edit - preferences - driver manager.
This will allow you to connect with the native driver on the connect menu.
Let me know if you have further problems... and post the full databrowser log (as an attachemnt) if you'd like me to look into the ODBC exception further. |
REPLY
|
|
|
