• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WSAD 4.03,SQL Server 2000 -- "FOR UPDATE cannot be specified on a READ ONLY cursor"

 
CL Fisher
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
HanMing Low
Ranch Hand
Posts: 196
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I think this has been answered a few days back.
The problem is either WebSphere does not support EJB 2.0 or the SQL Server JDBC Driver by MS is not supported by WS.
Hope this helps.
Cheers.

Han Ming
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic