RE: openjpa NativeQuery and NamedNativeQuery only allow select sql statements

2006-12-04 Thread Patrick Linskey
y, December 04, 2006 12:42 PM > To: open-jpa-dev@incubator.apache.org; Patrick Linskey > Cc: Ahmad Nouri; David Wisneski > Subject: RE: openjpa NativeQuery and NamedNativeQuery only > allow select sql statements > > The query API in JPA is implemented as a facade that > dele

RE: openjpa NativeQuery and NamedNativeQuery only allow select sql statements

2006-12-04 Thread Pinaki Poddar
EMAIL PROTECTED] cc David Wisneski/Santa Teresa/[EMAIL PROTECTED], Ahmad Nouri/Santa Teresa/[EMAIL PROTECTED] Subject RE: openjpa NativeQuery and NamedNativeQuery only allow select sql statements Hi, How are you executing the query? I'm guessing that you're using Query.getResultList()

Re: openjpa NativeQuery and NamedNativeQuery only allow select sql statements

2006-12-04 Thread Marc Prud'hommeaux
nit.runner.RemoteTestRunner.run (RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main (RemoteTestRunner.java:196) "Patrick Linskey" <[EMAIL PROTECTED]> 12/04/2006 10:21 AM To , George Hongell/Santa Teresa/ [EMAIL PROTECTED] cc David Wisneski/Santa Teresa/[EMAIL PROTECTED], Ahmad Nour

RE: openjpa NativeQuery and NamedNativeQuery only allow select sql statements

2006-12-04 Thread George Hongell
ECTED] cc David Wisneski/Santa Teresa/[EMAIL PROTECTED], Ahmad Nouri/Santa Teresa/[EMAIL PROTECTED] Subject RE: openjpa NativeQuery and NamedNativeQuery only allow select sql statements Hi, How are you executing the query? I'm guessing that you're using Query.getResultList() or Qu

RE: openjpa NativeQuery and NamedNativeQuery only allow select sql statements

2006-12-04 Thread Patrick Linskey
Hi, How are you executing the query? I'm guessing that you're using Query.getResultList() or Query.getSingleResult() instead of Query.executeUpdate(). -Patrick -- Patrick Linskey BEA Systems, Inc. ___ Notice: This email mess

Re: openjpa NativeQuery and NamedNativeQuery only allow select sql statements

2006-12-04 Thread Marc Prud'hommeaux
George- Sounds like a bug ... I think you should be allowed to execute an update native query. Can you file a JIRA report at https:// issues.apache.org/jira/browse/OPENJPA with the complete stack trace (including any nested stacks) and the code snippet that executes the query? On Dec 4