openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marc Prud'hommeaux <>
Subject Re: openjpa NativeQuery and NamedNativeQuery only allow select sql statements
Date Mon, 04 Dec 2006 19:02:04 GMT

Sounds like a bug ... I think you should be allowed to execute an  
update native query. Can you file a JIRA report at https:// with the complete stack trace  
(including any nested stacks) and the code snippet that executes the  

On Dec 4, 2006, at 10:11 AM, George Hongell wrote:

> It seems that openjpa NativeQuery and NamedNativeQuery only allow  
> "select"
> sql statements.  When I try to
> insert, delete, update, create table, alter table, drop table, or  
> call a
> stored procedure, I get
> <4|false|0.9.6-incubating-SNAPSHOT>
> org.apache.openjpa.persistence.InvalidStateException: Cannot  
> perform an
> update or delete operation on select query: "call out2(?, ?)".
> Is this intentional?
> I expected the NativeQuery to allow me to execute any valid sql  
> statement.

View raw message