GeeCON Prague 2014*
The moose likes JDBC and the fly likes MicroSoft 2000 SQL Server - recv failed problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "MicroSoft 2000 SQL Server - recv failed problem" Watch "MicroSoft 2000 SQL Server - recv failed problem" New topic
Author

MicroSoft 2000 SQL Server - recv failed problem

Rob Chung
Ranch Hand

Joined: Oct 15, 2002
Posts: 46
Our aplpication has been using
driver=net.avenir.jdbc2.Driver
url=jdbc:AvenirDriver://ourWeb:1433/ourDB
We are using MicroSoft 2000 SQL Server and we are trying to switch to the Microsoft JDBC driver.
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver,
url=jdbc:microsoft:sqlserver://ourWeb:1433;DATABASENAME=ourDB
I downloaded the driver and put the jar files in the classpath. No code changes.
I have the following error. Please help if you have any idea. Thanks in advance!
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Software caused connection abort: recv failed
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
laxmikant shimpi
Greenhorn

Joined: Sep 18, 2001
Posts: 21
this is socket exception is caused by n/w traffic or socket problems.
simplest solution is to restart u r server and check once again.
this problem may occur randomly.


Sun Certified Java Programmer
Rob Chung
Ranch Hand

Joined: Oct 15, 2002
Posts: 46
Thanks for your reply.
I found that with the ms JDBC driver, it required 3000+ connections to the database! (I checked the log and looked into the performance statistic on connections.) Whereas the Avenir driver used about 40 connections as expected. I switched the drivers a few times to confirm this is the case.
Any idea why?
Can anyone recommend some jdbc drivers which work well with ms 2000 sql server?
Thanks in advance!
 
GeeCON Prague 2014
 
subject: MicroSoft 2000 SQL Server - recv failed problem