[Microsoft][SQLServer 2000 Driver for JDBC]Connection reset

• Stanley-127366

  SSC Enthusiast

  Points: 113

  More actions

  February 10, 2004 at 8:19 pm

  #84156

  I wrote a Java program that uses hibernate to access data from sql server 2000 developer edition. It can access (update, select, delete) some tables.

   

  But when I execute the java program on sql server 2000 standard edition, on some table, I'm getting the error

  java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset

  These message occurs when I use hibernate to access (select, update, etc) on tables that are child nodes of other child nodes. For instance, Table A is a parent node of Table B, Table B is a parent node of Table C, and Table C is a parent node of Table D. The program can access A, B, C successfully. But when it attempts to query D, the java.sql.SQLException is thrown.

  To access sql server 2000 using hibernate, I use the following jar files:

  1) msbase.jar

  2) msslserver.jar

  3) msutil.jar

  Below is the full stack trace:

  java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset

          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.TDSRPCRequest.submitRequest(Unknown Source)

          at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown Source)

          at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown Source)

          at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)

          at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

          at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

          at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:183)

          at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:183)

          at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:62)

          at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:537)

          at net.sf.hibernate.loader.Loader.doFind(Loader.java:140)

          at net.sf.hibernate.loader.Loader.loadEntity(Loader.java:571)

          at net.sf.hibernate.loader.EntityLoader.load(EntityLoader.java:42)

          at net.sf.hibernate.persister.EntityPersister.load(EntityPersister.java:392)

          at net.sf.hibernate.impl.SessionImpl.doLoad(SessionImpl.java:1901)

          at net.sf.hibernate.impl.SessionImpl.doLoadByClass(SessionImpl.java:1769)

          at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1728)

          at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:62)

          at net.sf.hibernate.impl.SessionImpl.initializeEntity(SessionImpl.java:1962)

          at net.sf.hibernate.loader.Loader.doFind(Loader.java:196)

          at net.sf.hibernate.loader.Loader.find(Loader.java:604)

          at net.sf.hibernate.hql.QueryTranslator.find(QueryTranslator.java:912)

          at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1356)

          at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1335)

          at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1331)

   

  I've already tried the following:

  1) Stop and start the MS Sql server service

  2) Rebooting the machine

   

  The other information is as follows:

  1) Operating System: Windows 2000 server

  2) Java JDK 1.4

  Thanks.