SQLServerException: The operation requires a single user connection.
Hi,
Currently I am porting my code to SQL Server 2005 from 2000. I am facing the below problems in one of the screens. Can someone point out what could be the cause. We are trying to fetch column metadata.
Also the same piece of code works fine for the 1st time. However, when another form is opened, we face this error.
We maintain our connections in pool and retrieve and return the same back to pool once done.
I am not able to find more info on "single user connection"
com.microsoft.sqlserver.jdbc.SQLServerException: The operation requires a single user connection.
com.microsoft.sqlserver.jdbc.SQLServerException: The operation requires a single user connection.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.aquireExclusiveUse(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.sendCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteQuery(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
