Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MicroSoft 2000 SQL Server - recv failed problem

 
Rob Chung
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Rob Chung
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic