Hi, I could not reproduce this problem against DB2. Which database are you using? also,can you post your persistence.xml to see if there is any special setting?
Fay --- On Mon, 10/27/08, sbedoll <[EMAIL PROTECTED]> wrote: > From: sbedoll <[EMAIL PROTECTED]> > Subject: Native Query: Update fails with InvalidStateException > To: [email protected] > Date: Monday, October 27, 2008, 6:37 AM > I am using local transactions and get this error when > executing a NativeQuery > (query.executeUpdate) > > <openjpa-1.0.1-r420667:592145 nonfatal user error> > org.apache.openjpa.persistence.InvalidStateException: > Cannot perform an > update or delete operation on select query: "Update > FPA2.NW_OR_004_14702765 > Set Cost=? Where PT_GRID_ID=?". > at > org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:324) > at > fpa.fw.ds.jpadataadapter.JPADataSourceAdapter.executeNativeUpdate(JPADataSourceAdapter.java:815) > > I am using IBM JPA. Is there something I am missing ? > > > -- > View this message in context: > http://n2.nabble.com/Native-Query%3A-Update-fails-with-InvalidStateException-tp1382362p1382362.html > Sent from the OpenJPA Users mailing list archive at > Nabble.com.
