[b]CMP and SQL Server2000[/b]

dharmendrasankhla Feb 19, 2003 8:35 AM

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

1. Re: [b]CMP and SQL Server2000[/b]

auswalk Feb 20, 2003 4:29 PM (in response to dharmendrasankhla)

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.
Actions