1 Reply Latest reply on Mar 28, 2003 4:58 AM by 3004

    Strange problem with MSSQL2K (SP3)

    3004
      Hi,

      I have downloaded for evaluation Kodo 2.4. After installing and configuring
      it I tried to run the PetShop example that is provided with the package.
      Unfortunately I got very strange error:
      java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
      JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided
      (abcdef0) is not valid.

      I have set SelectMethod to "cursor" as it shows below:
      javax.jdo.option.ConnectionURL=jdbc\:microsoft\:sqlserver\://127.0.0.1\:1433
      ;DatabaseName\=PetShop;SelectMethod\=cursor

      Here is a part of the generated log from the IDE:

      1437 [main] INFO jdbc.SQL - [ C:1756487; T:28311783; D:27334345 ] preparing
      statement <2550265>: SELECT DISTINCT ANIMALX.JDOCLASSX FROM ANIMALX
      1437 [main] INFO jdbc.SQL - [ C:1756487; T:28311783; D:27334345 ] executing
      statement <2550265>: [reused=1;params={}]
      1484 [main] WARN jdbc.JDBC - [ C:1756487; T:28311783; D:27334345 ] Error
      when closing Statement/ResultSet
      java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
      JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided
      (abcdef0) is not valid.
      at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
      at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
      at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
      Source)
      at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
      Source)
      at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
      Source)
      at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
      at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.closeCursor(Unknown
      Source)
      at
      com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.completeRowProcessing(Unkn
      own Source)
      at com.microsoft.jdbc.sqlserver.SQLServerImplResultSet.close(Unknown
      Source)
      at com.microsoft.jdbc.base.BaseResultSet.close(Unknown Source)
      at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
      Source)
      at com.microsoft.jdbc.base.BaseStatement.close(Unknown Source)
      at com.microsoft.jdbc.base.BasePreparedStatement.close(Unknown Source)
      at
      com.solarmetric.datasource.StatementWrapper.close(StatementWrapper.java:201)
      at
      com.solarmetric.datasource.PreparedStatementCache$CachePreparedStatement.des
      troy(PreparedStatementCache.java:278)
      at
      com.solarmetric.datasource.PreparedStatementCache$CachePreparedStatement.clo
      se(PreparedStatementCache.java:350)
      at
      com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.close(SQLExecutionMan
      agerImpl.java:986)
      at
      com.solarmetric.kodo.impl.jdbc.ormapping.SubclassProviderImpl.getSubclasses(
      SubclassProviderImpl.java:278)
      at
      com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.getPrimaryMappingField
      s(ClassMapping.java:1093)
      at
      com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.executeQuery(JDBCSto
      reManager.java:704)
      at
      com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getResultList(JDBCExtent.j
      ava:64)
      at
      com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getIterator(JDBCExtent.jav
      a:46)
      at
      com.solarmetric.kodo.runtime.ExtentImpl$TransactionAwareIterator.newIterator
      (ExtentImpl.java:242)
      at serp.util.MultiIterator.setIterator(MultiIterator.java:70)
      at serp.util.MultiIterator.hasNext(MultiIterator.java:25)
      at
      com.solarmetric.kodo.runtime.ExtentImpl$TransactionAwareIterator.hasNext(Ext
      entImpl.java:218)
      at PetShop.<init>(PetShop.java:50)
      at PetShop.main(PetShop.java:187)
      1500 [main] INFO jdbc.JDBC - [ C:1756487; T:28311783; D:27334345 ] begin
      rollback
      1500 [main] INFO jdbc.JDBC - [ C:1756487; T:28311783; D:27334345 ] end
      rollback 0ms



      Thanks for the help,

      Boris Hristov



        • 1. Re: Strange problem with MSSQL2K (SP3)
          3004
          That is a warning, and can be ignored. Many of our users experience
          this (as do our tests) without any errors or failures.

          If you run into problems that seem related or unrelated, let us know,
          and we'll look closer at the situation.

          Boris Hristov wrote:
          Hi,

          I have downloaded for evaluation Kodo 2.4. After installing and configuring
          it I tried to run the PetShop example that is provided with the package.
          Unfortunately I got very strange error:
          java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
          JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided
          (abcdef0) is not valid.

          I have set SelectMethod to "cursor" as it shows below:
          javax.jdo.option.ConnectionURL=jdbc\:microsoft\:sqlserver\://127.0.0.1\:1433
          ;DatabaseName\=PetShop;SelectMethod\=cursor

          Here is a part of the generated log from the IDE:

          1437 [main] INFO jdbc.SQL - [ C:1756487; T:28311783; D:27334345 ] preparing
          statement <2550265>: SELECT DISTINCT ANIMALX.JDOCLASSX FROM ANIMALX
          1437 [main] INFO jdbc.SQL - [ C:1756487; T:28311783; D:27334345 ] executing
          statement <2550265>: [reused=1;params={}]
          1484 [main] WARN jdbc.JDBC - [ C:1756487; T:28311783; D:27334345 ] Error
          when closing Statement/ResultSet
          java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
          JDBC][SQLServer]sp_cursorclose: The cursor identifier value provided
          (abcdef0) is not valid.
          at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
          at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
          at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
          Source)
          at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown
          Source)
          at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown
          Source)
          at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
          at com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.closeCursor(Unknown
          Source)
          at
          com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.completeRowProcessing(Unkn
          own Source)
          at com.microsoft.jdbc.sqlserver.SQLServerImplResultSet.close(Unknown
          Source)
          at com.microsoft.jdbc.base.BaseResultSet.close(Unknown Source)
          at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown
          Source)
          at com.microsoft.jdbc.base.BaseStatement.close(Unknown Source)
          at com.microsoft.jdbc.base.BasePreparedStatement.close(Unknown Source)
          at
          com.solarmetric.datasource.StatementWrapper.close(StatementWrapper.java:201)
          at
          com.solarmetric.datasource.PreparedStatementCache$CachePreparedStatement.des
          troy(PreparedStatementCache.java:278)
          at
          com.solarmetric.datasource.PreparedStatementCache$CachePreparedStatement.clo
          se(PreparedStatementCache.java:350)
          at
          com.solarmetric.kodo.impl.jdbc.SQLExecutionManagerImpl.close(SQLExecutionMan
          agerImpl.java:986)
          at
          com.solarmetric.kodo.impl.jdbc.ormapping.SubclassProviderImpl.getSubclasses(
          SubclassProviderImpl.java:278)
          at
          com.solarmetric.kodo.impl.jdbc.ormapping.ClassMapping.getPrimaryMappingField
          s(ClassMapping.java:1093)
          at
          com.solarmetric.kodo.impl.jdbc.runtime.JDBCStoreManager.executeQuery(JDBCSto
          reManager.java:704)
          at
          com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getResultList(JDBCExtent.j
          ava:64)
          at
          com.solarmetric.kodo.impl.jdbc.runtime.JDBCExtent.getIterator(JDBCExtent.jav
          a:46)
          at
          com.solarmetric.kodo.runtime.ExtentImpl$TransactionAwareIterator.newIterator
          (ExtentImpl.java:242)
          at serp.util.MultiIterator.setIterator(MultiIterator.java:70)
          at serp.util.MultiIterator.hasNext(MultiIterator.java:25)
          at
          com.solarmetric.kodo.runtime.ExtentImpl$TransactionAwareIterator.hasNext(Ext
          entImpl.java:218)
          at PetShop.<init>(PetShop.java:50)
          at PetShop.main(PetShop.java:187)
          1500 [main] INFO jdbc.JDBC - [ C:1756487; T:28311783; D:27334345 ] begin
          rollback
          1500 [main] INFO jdbc.JDBC - [ C:1756487; T:28311783; D:27334345 ] end
          rollback 0ms



          Thanks for the help,

          Boris Hristov


          --
          Stephen Kim
          skim@solarmetric.com
          SolarMetric, Inc.
          http://www.solarmetric.com