ObjectDB Database Search

1-34 of 34 results

Running JPA Queries

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

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

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

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

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

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

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

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

Question about modification

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

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

java.lang.UnsupportedOperationException

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

Modifier operations

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

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

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

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

Strange behaviour with ORDER BY and IN

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

Unable to execute update query

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

Updating Entities

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

Update more than 10000 entities by an update query fails

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

Method Invocation On All Entities

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

Bulk update of embedded entities in linked list

;                 . executeUpdate ();   The dot before

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

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

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

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

[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 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

Sometimes cascade persist does not work during commit

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

UPDATE statemen crash when i put the WHERE clause.

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