Internal Website Search

1-34 of 34 results

Running JPA Queries

: Query. executeUpdate - for running only DELETE and UPDATE queries. Ordinary Query Execution ... (with executeUpdate ) DELETE and UPDATE queries are executed using the executeUpdate method. For example ... Country"). executeUpdate (); The following query resets the area field in all the Country

Query.executeUpdate() - JPA Method

JPA Method in javax.persistence.Query int executeUpdate () Execute an update or delete statement. Return: the number of entities updated or deleted Throws: IllegalStateException - if called for a Java Persistence query language SELECT statement or for a criteria query TransactionRequiredException

StoredProcedureQuery.executeUpdate() - JPA Method

JPA Method in javax.persistence.StoredProcedureQuery int executeUpdate () Return the update count of -1 if there is no pending result or if the first result is not an update count. The provider will call execute on the query if needed. Return: the update count or -1 if there is no pending result

DELETE Queries in JPA/JPQL

the  executeUpdate method:   int deletedCount = em. createQuery ("DELETE FROM Country"). executeUpdate (); A  TransactionRequiredException is thrown if no transaction is active. On success - the executeUpdate method returns the number of objects that have been deleted by the query

UPDATE SET Queries in JPA/JPQL

; executeUpdate method:   Query query = em. createQuery (       "UPDATE Country SET population = 0, area = 0");   int updateCount = em. executeUpdate ... - the executeUpdate method returns the number of objects that have been modified by the query. Selective Update

Date field Index is corrupted due to time change

. executeUpdate (JpaQuery.java:776) at com.objectdb.o.QRP.L(QRP.java:251) at com.objectdb.o.QRP.T(QRP ... ;   at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java:776)       ... ;  q. executeUpdate ();             em

Not able to update records

query when no transaction is active (error 611) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery ... ()). executeUpdate ();   And called method is as follows private String createUpdateQuery ... surrounding your executeUpdate with em.getTransaction().begin() to start the transaction and em

javax.persistence.StoredProcedureQuery

processing getResultList or getSingleResult . When executeUpdate is called on a StoredProcedureQuery ... getUpdateCount . The results of executeUpdate will be those of getUpdateCount . The execute method supports ... .1 int executeUpdate () Return the update count of -1 if there is no pending result or if the first

Question about modification

;       int numeroObjetosModificados = consulta. executeUpdate ();       ... = consulta. executeUpdate ();                     ... . executeUpdate ();                         em

Is there a function of "drop table" or "delete from table"?

FROM MyEntity e"). executeUpdate (); This is implemented since version 2.2.4 but the manual has not been updated yet. support Support Thanks. I never think it is " executeUpdate ()", query.getresultlist ... MyEntity e"). executeUpdate ();” works, but it can not reset id to zero! "drop table" or "delete from

Problem with distinct select, order by and equivalent alias/attribute path

; em.createQuery("delete from Street s"). executeUpdate ();         em.createQuery("delete from Location l"). executeUpdate ();        

Cannot save or update entity on Spring App

("..."). executeUpdate () 0; } } While the fetching methods work, there are two huge problems: the persist ... .setParameter(s, map.get(s)); boolean que = q. executeUpdate () 0; em.getTransaction().commit(); em.clear(); em

javax.persistence.Query

JPA Interface Query Interface used to control query execution. See Also: TypedQuery StoredProcedureQuery Parameter Since: JPA 1.0 Chapter 4 - JPA Queries (JPQL / Criteria) explains how to use Query . Public Methods int executeUpdate () Execute an update or delete statement. Return: the number

javax.persistence.TypedQuery

JPA Interface TypedQuery Type Parameters: - query result type Super Interfaces: Query Interface used to control the execution of typed queries. See Also: Query Parameter Since: JPA 2.0 Chapter 4 - JPA Queries (JPQL / Criteria) explains how to use TypedQuery . Public Methods int executeUpdate

Unexpected query token 'delete' (SELECT is expected) (error 752)

simple codes(see attachment), failed.   gzdillon Lai Yang DELETE queries should not be run with getSingleResult ( which is for SELECT queries). Use executeUpdate instead. See this manual page . support Support

Strange behaviour with ORDER BY and IN

up...         em.createQuery("delete from Location l"). executeUpdate

Updating Entities

(); modifyTo. executeUpdate (); Main.paygradeDB.getTransaction().commit(); System.out.println

java.lang.UnsupportedOperationException

", License.class); query.setParameter(1, id); int changes = query. executeUpdate

Unable to execute update query

(QRR.java:247) at com.objectdb.o.QRR.f(QRR.java:153) at com.objectdb.jpa.JpaQuery. executeUpdate

Using ObjectDB with JDBC (in similar way with JPA 2)

Using JDBC, I can use a String to create the schema of a table: String sql = "CREATE TABLE REGISTRATION " + "(id INTEGER not NULL, " + " first VARCHAR(255), " + " last VARCHAR(255), " + " age INTEGER, " + " PRIMARY KEY ( id ))"; stmt = conn.createStatement(); stmt. executeUpdate (sql); I want

Method Invocation On All Entities

"). executeUpdate (); trans.commit(); Did I miss something? Yotam Yotam Boaz That is correct. Lifecycle

Query results are not up to date for entities, not primitives

",     personID)   . executeUpdate (); em2   .flush(); em2   .clear(); tr

Update more than 10000 entities by an update query fails

.createQuery(query); q. executeUpdate (); } emTwo.getTransaction().commit(); emTwo.close(); EntityManager

Modifier operations

");     query. executeUpdate (); Update queries are supported by ObjectDB since version 2

Bulk update of embedded entities in linked list

;                 . executeUpdate ();   The dot before

ArrayIndexOutOfBoundsException on flush

.OBC.onObjectDBError(OBC.java:1485) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java:737 ... :151) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java:722) ... 40 more The code ... FROM ExecutionGraph g"); query. executeUpdate (); query = em.createQuery("DELETE FROM

Blocked by find

.OBC.onObjectDBError(OBC.java:1485) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java:737 ... .QRR.g(QRR.java:232) at com.objectdb.o.QRR.b(QRR.java:151) at com.objectdb.jpa.JpaQuery. executeUpdate ... .containerId = :containerId"); query.setParameter("containerId", containerId); query. executeUpdate (); em

GC overhead limit exceeded

. executeUpdate (JpaQuery.java:722) 2) [ObjectDB 2.3.2_04] Unexpected exception (Error 990) Generated by Java ... ) at com.objectdb.o.QRR.b(QRR.java:151) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java:722

Negative snapshot user count

:232) at com.objectdb.o.QRR.b(QRR.java:151) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java ... .objectdb.o.QRR.b(QRR.java:144) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java:684) at rbccm

Update query bug

.setParameter("code", personalCode); query2. executeUpdate ... .java:239) at com.objectdb.o.QRR.b(QRR.java:151) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery

stress test -> com.objectdb.o.InternalException: null

) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery.java:775) at com.fitbird.control.p2 ... .createQuery("UPDATE TestEntity SET x = 1"). executeUpdate ();         em1

[ObjectDB 2.4.1] Unexpected exception (Error 990)

.java:232) at com.objectdb.o.QRR.b(QRR.java:151) at com.objectdb.jpa.JpaQuery. executeUpdate (JpaQuery ... ();         em.createQuery("DELETE o"). executeUpdate ();   

UPDATE statemen crash when i put the WHERE clause.

) . executeUpdate () ; updateEm.getTransaction().commit() ; System. out .println(em.createQuery( "select n

Sometimes cascade persist does not work during commit

(FlushModeType.AUTO); em.getTransaction().begin(); em.createQuery("DELETE from Object"). executeUpdate