File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MicroSoft 2000 SQL Server - recv failed problem