Hi Ognjen,
If you don't use an alias the bulk delete works ok, I tested it with the
SupportsSubselect=true and I didn't have any problem. I used this code:
Query q = em.createQuery("delete from Test");
q.executeUpdate();
Regards,
- Ignacio
On Mon, Apr 7, 2008 at 12:56 PM, Ognjen Blagojevic <[EMAIL PROTECTED]>
wrote:
Ok, thanks.
OPENJPA-459 is problematic only if parameter SupportsSubselect is set
(which is my case).
BTW, we are in the same time zone - CEST. :)
Regards,
Ognjen
Ignacio Andreu wrote:
I can't run a test right now, I've used JPQL bulk delete on MySQL
using
OpenJPA (version 0.7). I wrote about it in my blog[1]. This evening,
in
my
time zone (Spain), I will try to investigate about this problem.
Regards,
- Ignacio
[1]
http://plunchete.wordpress.com/2007/05/30/jpql-and-how-to-delete-objects-in-jpa/
On Mon, Apr 7, 2008 at 12:21 PM, Ognjen Blagojevic <
[EMAIL PROTECTED]>
wrote:
Yes, astersik was erroneous, but that wasn't the problem. Query:
Query q = em.createNativeQuery("DELETE FROM nastavnik");
result = q.executeUpdate();
still throws the same exception ("Callable statements not
supported.").
And OPENJPA-459 stops me from using JPQL bulk delete on MySQL.
Regards,
Ognjen
Ignacio Andreu wrote:
Hi,
DELETE * FROM test is wrong, the SQL sould be: DELETE FROM test
I don't know if this is your error but if you want to delete an
object,
you
can use a JPQL sentence, something like:
m.createQuery("delete from test t");
Regards,
- Ignacio
2008/4/7 Ognjen Blagojevic <[EMAIL PROTECTED]>:
Hi OpenJPA developers,
When I try to execute bulk delete using native queries on MySQL,
this
piece of code:
em.getTransaction().begin();
try {
Query q = em.createNativeQuery("DELETE * FROM test");
result = q.executeUpdate();
em.getTransaction().commit();
} catch (Exception e) {
em.getTransaction().rollback();
}
seems to throw an exception "Callable statements not supported."
(stack
trace below). Does anyone know why?
Regards,
Ognjen
----------------------
16 eUniversityPu INFO [main] openjpa.Runtime - Starting
OpenJPA
1.0.2
282 eUniversityPu INFO [main] openjpa.jdbc.JDBC - Using
dictionary
class "org.apache.openjpa.jdbc.sql.MySQLDictionary" (MySQL
4.1.16
,MySQL-AB
JDBC Driver mysql-connector-java-5.0.4 ( $Date: 2006-10-19
17:47:48
+0200
(Thu, 19 Oct 2006) $, $Revision: 5908 $ )).
<openjpa-1.0.2-r420667:627158 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Callable
statements not
supported.
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3946)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:245)
at
org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1039)
at
org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:803)
at
org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:878)
at
org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:874)
at
org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
at
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:322)
at
yu.ac.bg.rcub.soleil.session.Glavni.customNativeDeleteTest(Glavni.java:657)
at
yu.ac.bg.rcub.soleil.session.QueryTest.main(QueryTest.java:29)
Caused by: java.sql.SQLException: Callable statements not
supported.
at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at
com.mysql.jdbc.Connection.prepareCall(Connection.java:4522)
at
com.mysql.jdbc.Connection.prepareCall(Connection.java:4470)
at
org.apache.commons.dbcp.DelegatingConnection.prepareCall(DelegatingConnection.java:275)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareCall(PoolingDataSource.java:292)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareCall(DelegatingConnection.java:185)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareCall(DelegatingConnection.java:183)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareCall(DelegatingConnection.java:172)
at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareCall(SQLBuffer.java:534)
at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareCall(SQLBuffer.java:514)
at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareCall(SQLBuffer.java:503)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:226)
... 8 more
<openjpa-1.0.2-r420667:627158 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: Callable
statements not
supported.
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:3946)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:97)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:83)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:59)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:245)
at
org.apache.openjpa.kernel.QueryImpl.update(QueryImpl.java:1039)
at
org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:803)
at
org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:878)
at
org.apache.openjpa.kernel.QueryImpl.updateAll(QueryImpl.java:874)
at
org.apache.openjpa.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:565)
at
org.apache.openjpa.persistence.QueryImpl.executeUpdate(QueryImpl.java:322)
at
yu.ac.bg.rcub.soleil.session.Glavni.customNativeDelete(Glavni.java:641)
at
yu.ac.bg.rcub.soleil.session.QueryTest.main(QueryTest.java:33)
Caused by: java.sql.SQLException: Callable statements not
supported.
at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at
com.mysql.jdbc.Connection.prepareCall(Connection.java:4522)
at
com.mysql.jdbc.Connection.prepareCall(Connection.java:4470)
at
org.apache.commons.dbcp.DelegatingConnection.prepareCall(DelegatingConnection.java:275)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareCall(PoolingDataSource.java:292)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareCall(DelegatingConnection.java:185)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareCall(DelegatingConnection.java:183)
at
org.apache.openjpa.lib.jdbc.DelegatingConnection.prepareCall(DelegatingConnection.java:172)
at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareCall(SQLBuffer.java:534)
at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareCall(SQLBuffer.java:514)
at
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareCall(SQLBuffer.java:503)
at
org.apache.openjpa.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeUpdate(SQLStoreQuery.java:226)
... 8 more
