This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
Similar Threads
Error connecting to MSSQL Server from Hibernate
connect to SQLServer Database in XP?
Connection through Applet using SQLServer 2000 Driver for JDBC
MS Sql server2000 connection problem
SQL Exception -Error establishing socket