Connection get reset while running procedure

[Maksim S.]

I am running Java based application that uses Microsoft SQLServer JDBC 1.1
driver to execute a stored procedure. It is run on a 64-bit Linux host.

It runs for long time and eventually connection gets reset. The error I see
int he log is this:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception
occurred during the DBComms.transmit operation. Exception:Broken pipe.
Context:(2) [Thread[WProcResult Invoker,1,main], IO:3ce62, Dbc:88f4b].
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown
Source)
at com.microsoft.sqlserver.jdbc.DBComms.transmit(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.sendCommand(Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.connectionCommand(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendRollback(Unknown
Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(Unknown Source)

Any ideas?

--
Maksim Shligold

[joe.we...@gmail.com]

Yes. It's nothing to do with the driver. Something very bad happens
at the DBMS that causes the DBMS to kill the user session and
unceremoniously drop the socket the driver is using to implement
your JDBC connection. You'll have to check the DBMS error log
and/or debug the progress of your procedure there. From the JDBC
point of view, it just got hung up on...

[Evan T. Basalik (MSFT)]

Although it will likely not fix this issue (Joe's response is dead on), the
2.0 driver is released and you should really consider upgrading.

Evan