Greetings, all In my current J2EE project, I have a number of CMP Entity EJBs that are working well against a local DB2 database. However, I need to work against a remote MS SQL Server 2000 db. I can connect to said db, and can do normal JDBC updates against it using the datasource I have set up for the EJBs. I can create an EJB -- the row shows up in the remote database. However... when I do a setNote (note being the only non-key field in the EJB), I get the following exception:
RemoteException occurred in server thread; nested exception is: com.ibm.websphere.cpi.CPIException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]FOR UPDATE cannot be specified on a READ ONLY cursor.; nested exception is: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]FOR UPDATE cannot be specified on a READ ONLY cursor.
Has anyone encountered this, or have ideas about what may cause it? Many thanks in advance, CL
My guess is that HanMing's second guess is right -- looking at the WAS 4.02 product set shows that the Microsoft driver wasn't supported in WAS AEs 4.02 but now IS in WAS 4.04. SO.... you MIGHT be ok if you install the WAS 4.04 fixpack on top of the WAS AEs installation in WSAD. Such things have worked before... Kyle