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 |
|
steel
Posting Yak Master
107 Posts |
 Posted - 2009-06-02 : 10:38:44
|
| Hello All,I am having a production environment on SQL 2K5 and SP3 .There is one java appliction running on the server which runs fine for some time but after running fine for some time it gives error:com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context:(1) [Thread[main,5,main], IO:8e20a, Dbc:00d7a]. PktNum:0. TotalReceived:0. PktSize:4,096. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source) at CIMD.CIMD_Client_ms_final.pool_process(CIMD_Client_ms_final.java:365) at CIMD.CIMD_Client_ms_final.start(CIMD_Client_ms_final.java:118) at CIMD.CIMD_Client_ms_final.main(CIMD_Client_ms_final.java:193)Please help me i am not able to understand that what is the cause of this error. |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-06-02 : 10:48:35
|
| Many java applications do not have reconnection logic. It is slowly getting better, though. Do these errors happen right after the instance of SQL Server is restarted? |
 |
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2009-06-02 : 11:06:33
|
| No this error doesn't comes after the instance restart. |
|
|
|
|
|
|
com.microsoft.sqlserver.jdbc.SQLServerException