File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MicroSoft 2000 SQL Server - recv failed problem

 
Rob Chung
Ranch Hand
Posts: 46
  • 0
  • 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
  • 0
  • 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
  • 0
  • 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!
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic