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)
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
Joined: Oct 15, 2002
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!