1 Reply Latest reply on Feb 20, 2003 4:29 PM by Allen Walker

    [b]CMP and SQL Server2000[/b]

    dharam Newbie

      Hi all,

      i am using CMP in Jboss2.4.4_Tomcat4.0.1 with Sql Server 2000 database on windows2000.and Microsoft SQL Server2000 driver for JDBC.
      everything is working fine when i call a simple function like validateLogin(....), when i m going to call a function which has nested transactions it throws error like this..................

      [ERROR,myDb/PackagedBean] TRANSACTION ROLLBACK EXCEPTION:
      javax.transaction.TransactionRolledbackException: Load failed; nested exception
      is:
      java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLSe
      rver]FOR UPDATE cannot be specified on a READ ONLY cursor.; nested exception is:

      java.rmi.ServerException: Load failed; nested exception is:
      java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLSe
      rver]FOR UPDATE cannot be specified on a READ ONLY cursor.

      ===============
      i m using ConnectionURL for Sql Server2000 in jboss.jcml file...


      com.microsoft.jdbc.sqlserver.SQLServerDriver



      jdbc/myDB
      org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
      jdbc:microsoft:sqlserver://10.0.0.1:1433;SelectMethod=Cursor
      test
      test
      10



      why is it so. is there something that i m missing,

      pls help me .....

      Thanks in advance
      dharam