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
Sounds like something to do with primary keys. Make sure whatever you set as your PK in ejb-jar.xml is actually set as the primary key column in your database.