Home » Search

About update

21-30 of 200Refresh
Forum
16

Unable to execute update query

Hello! I'm trying to do an update query via the explorer to set a new field value for around 400k objects. UPDATE Position p SET p.originalData = null This exception raises when I try ... file that is used in an update query, but the cause is unclear, and according to your report
Forum
16

UPDATE query to set a new field after schema change

) property to false for all existing entities in the DB. I tried to execute an update statement with the Explorer tool. The statement ends and tells me that 1000 entities have been updated. I then save ... is still "null" for all instances. How do I initialize the field? You are right. Currently UPDATE queries
Forum
16

Updating existing persistence entries

: Attempt to reuse an existing primary key value which makes sense to me but I'm missing a em.update() method. I found examples for updating objects in the knowledge base, but they make use of a pe ... that also includes instructions on how to update and object using JPA. Dear support, thank you for your reply
Issue
16

UPDATE query cannot set a new field after schema change

) property to false for all existing entities in the DB. I tried to execute an update statement with the Explorer tool. The statement ends and tells me that 1000 entities have been updated. I then save ... is still "null" for all instances. How do I initialize the field? You are right. Currently UPDATE queries
Forum
16

Bulk Delete and Update - best practice?

. The attachment also contains an update test which has similar memory problems. I'm running both tests with the default objectdb.conf. In general is an UPDATE/DELETE statement the most efficient way to update/remove a large number of objects? I've had success with the "drop" keyword in
Forum
16

Unexpected behaviour upon update. Bug?

.*; @Entity public class Update implements Serializable { @Id int i; int v; public ... (); em.getTransaction().begin(); Update simple = new Update(); simple.i = 0 ... Update s" , Update.class)             .getResultList().listIterator
Forum
16

Not able to update records

Hi,   I am tring to update the simple object by using Update query by i am getting following exception [ObjectDB 2.4.4_15] javax.persistence.TransactionRequiredException Attempt to run update query ... ){   StringBuffer sqlQuery = new StringBuffer("UPDATE UserCredential p ");   sqlQuery.append(" SET
Forum
15

Entity Update - Is the documentation up to date?

of the documentation.  Turns out I've been doing two things that http://www.objectdb.com/java/jpa/persistence/update ... seem to be merged automatically. The more conventional way is to update entities within an active transaction, or update entities outside the transaction and then merge them within an active
Forum
15

OutOfMemoryError on search after update on DB created with DB Doctor

about 540 thousand records. At this stage there is no problem when searching and updating. 3. We run ... . Try a searching and all appears to be fine. 6. Do an update, any update to any record and all appears to be fine. 7. Do a search after the update, any search and CPU use shoots up to > 100% use
Forum
15

persists and update together ?

UPDATE c=VALUES(a)+VALUES(b);   This query , inserts data or updates if its already available ... available then update if its available, if not add new object to db.   This will make more cycle ... update the object. Without calling find , can we do this ?   Maybe merge instead of persist is what you are looking for. kadirbasol