Fay Wang wrote:
>
> 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.
>
>
>
>
>
--
View this message in context:
http://n2.nabble.com/Native-Query%3A-Update-fails-with-InvalidStateException-tp1382362p1383529.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
