ObjectDB Database Search

Besides the em.remove() one by one, is there a function of "drop table" or " delete from table"? TIA gzdillon Lai Yang You can execute a DELETE query:     em.createQuery(" DELETE ... . I can not find "drop table" in this site BTW. gzdillon Lai Yang The code “createQuery(" DELETE FROM

, there is null pointer about not finding offer (which is deleted together with product ... and cascading delete from Product to Offer  are irrelevant to the exception. Let focus only in ... is deleted . Otherwise a broken reference from Store to the deleted Product is formed. support Support I

I have a entity class named Agent having fields Id,Name,Code,Skill ...etc. I wants to delete only the Skill from a row so I use Query like " Delete a.Skill from Agent a where a.Id = 112" but It gives ... Manoj Kumar Maharana DELETE queries are for deleting complete objects (rows). You may use an UPDATE

Is there a configuration parameter to set this? dmoshal David Moshal You can set cascade delete using annotations (see also the Orphan Removal section). JDO defines similar annotations, and both JPA ... configuration. You cannot set global cascade delete since that will be too risky - you may delete the entire database. support Support

Hi! I was looking for ways to delete a class (entity/embedded) from a database through Explorer ... is to delete the whole db and make a new one, but that's not a good scenario ... . However, it only affects the list of classes in the Explorer, so you may just ignore the deleted class

    Suppose entity A is referenced from entity B, like (A - * B) but not actually having that reference, instead only B has @ManyToOne relationship to A and A has none. Is there a way to cascade delete of B's when deleting A? Or this should be done programatically with separate

    Hello , is it possible to get disk usage of database ? If disk usage becomes too high , delete old date files from database. And recalculate disk usage back ?   kadirbasol Kadir ... usage and delete some old files" and should be focus only on that subject. support Support

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

;   private Set timeslots = new HashSet(); And i would like to delete the timeslots

occurred during JDO deletion query, and the temp threshold was set and was low (64mb).  There is an easy work-around, which is to divide up the deletion into smaller number of objects.  I understand that JPA bulk delete doesn't involve any object retrieval, whereas perhaps JDO deletion does

My JDO application does inserts with binds, and then subsequently does bulk deletes using this code: pm.currentTransaction().begin(); Extent extent = pm.getExtent(ABC.class, true); Query q = pm ... (bookmarks). Instead of the above code, I could iterate over the Extent and delete the entities

, but cascading delete does not, leaving orphan objects. sjzlondon Steve Zara Thank you for this report. Apparently cascading delete has never been implemented in ObjectDB (see also " Deleting Dependent Objects" on this old documentation page ). Build 2.7.5_04 implements cascading delete in JDO

JPQL (Java Persistence Query Language) supports updating and deleting database objects by queries. Currently ObjectDB supports only JPQL SELECT (retrieval) queries. Delete queries are supported for JDOQL (JDO Query Language). support Support spring-data-jpa uses delete queries to implement

and subqueries as well as to update and delete criteria operations. It is not intended to be used directly in query construction. Note that criteria queries and criteria update and delete operations ... and delete operations are typed according to the target of the update or delete . Since: Jakarta Persistence

Hello, we have observed strange behaviour when we delete odb archive log directory. We are running long term tests and during it we are deleting all logs that are not needed keeping the system running. When the "archive/" folder, where odb logs are archived, is deleted , the exceptions occur: [2014

of Address which cascades deletes (orphanRemoval=true) to its children which is what we want ... it has never been deleted from the collection (at least, until the transaction is comitted ... Entities within the collection of a Contact when we delete the Contact? Is that cascaded or do we need

Using version 2.7.4_01, we did a repair. After repair a former link to a missing reference was converted to null. This cannot be deleted using explorer   hgzwicker Hans-Georg Zwicker Thank you for this report. Build 2.7.4_02 fixes the issue. support Support

after the crash we cannot delete specific objects, see screenshots of explorer. Database will be soon available (size 5.561.119 KB) on hummingbird-systems.com, user/pw your db name, main menu option objectdb  hgzwicker Hans-Georg Zwicker meanwhile the database became completely unusable

accidently we used the option delete on a collection of type ArrayList . On doing so the type changed to List . we are using explorer version 2.7.1_02 How can we change that back again ? hgzwicker Hans-Georg Zwicker Is it only an issue with the type of the field as shown by the Explorer or

: FOREIGN KEY ( {, } ... ) REFERENCES [ ( {, } ... ) ] [ ON UPDATE ] [ ON DELETE ... will generate foreign key constraints whose update and delete actions it determines most appropriate ... element is not specified, the provider will generate a constraint whose update and delete actions

deleted the tmp file of another application. I hope this description is sufficient. EKK EKK Emmanuel Keskes ObjectDB deletes its temporary files in 2 ways: Every process deletes its own temporary files that become unreachable (tracked by using weak references). When a process starts it tries to delete

Hello, I cannot set an entity object in a parameter for a bulk update in the explorer query execution. The format Entity#001 works well for the parameter in the WHERE clause, but it doesn't work in ... parameter for an update? Any time that I need to do a bulk update, I need to compile a special

T2 then modifies or deletes that row, before T1 has committed. Both transactions eventually commit ... then modifies or deletes that row, before T1 has committed or rolled back. A lock with LockModeType

Deleting or changing a field of all the entities of some type is fairly easy, using the DELETE ... should do some operations before it gets deleted , and at some point we want to delete all those entities. It could be usefull if we could invoke some "doBeforeDie" method before the deletion

;  CriteriaDelete deleteQuery ) Create an instance of Query for executing a criteria delete query. Parameters: deleteQuery - a criteria delete query object Returns: the new query instance. Throws: IllegalArgumentException - if the delete query is found to be invalid. Since: Jakarta Persistence (JPA) 2.1

where (    Expression restriction ) Modify the DELETE query to restrict the target of the deletion according to the specified boolean expression. Replaces the previously added restriction(s), if any. Parameters: restriction - a simple or compound boolean expression Returns: the modified delete query. Since: Jakarta Persistence (JPA) 1.0

where (    Predicate... restrictions ) Modify the DELETE query to restrict the target of the deletion according to the conjunction of the specified restriction predicates. Replaces ... : the modified delete query. Since: Jakarta Persistence (JPA) 1.0

Hi, can you shed some light on why we cannot delete data from the attached DB file. A delete ... on an attempt to delete objects could happen with other operations as well. The common reason for database ... ; The delete query we run is: DELETE FROM RecordingMetaData The exception is the same: [ObjectDB 2.6.5

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityManager Query createNativeQuery (    String sqlString ) Create an instance of Query for executing a native SQL statement, e.g., for update or delete . If the query is not an update or delete query, query execution will result

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaDelete Root from (    Class entityClass ) Create and add a query root corresponding to the entity that is the target of the DELETE . A CriteriaDelete object has a single root, the entity that is being deleted

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaDelete Root from (    EntityType entity ) Create and add a query root corresponding to the entity that is the target of the DELETE . A CriteriaDelete object has a single root, the entity that is being deleted

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

delete the state of the instance. The version attribute must be of one of the following basic types

- if called for a Jakarta Persistence query language UPDATE or DELETE statement. PessimisticLockException

to the database to reflect any insertion, deletion , or reordering affecting the list. The OrderColumn

language UPDATE or DELETE statement. PessimisticLockException - if pessimistic locking fails

Jakarta Persistence (JPA) Method in jakarta.persistence.TypedQuery X getSingleResult() Execute a SELECT query that returns a single result. Returns: the result, of type X . Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or DELETE statement

language UPDATE or DELETE statement. LockTimeoutException - if pessimistic locking fails

for a Jakarta Persistence query language UPDATE or DELETE statement. PessimisticLockException

will generate a constraint whose update and delete actions it determines most appropriate for the join column

deletion of the entity, will never be synchronized to the database. Managed entities which reference

Jakarta Persistence (JPA) Method in jakarta.persistence.EntityManager void remove (    Object entity ) Mark a managed entity instance as removed, resulting in its deletion from the database when the persistence context is synchronized with the database. This operation cascades

DELETE statement. LockTimeoutException - if pessimistic locking fails and only the statement

query language UPDATE or DELETE statement. PessimisticLockException - if pessimistic locking fails

language UPDATE or DELETE statement. PessimisticLockException - if pessimistic locking fails

Jakarta Persistence (JPA) Method in jakarta.persistence.Query Object getSingleResult() Execute a SELECT query that returns a single untyped result. Returns: the result. Throws: IllegalStateException - if called for a Jakarta Persistence query language UPDATE or DELETE statement

.  Based on the implementation, you will need to delete the odb file between each execution ... . Persisting bulk of objects every transaction (instead of a transaction per entity object). support

.deleteInOpenTransaction(ObjectCacheDB.java:361) at com.ysoft.cache.objectdb.ObjectCacheDB. delete (ObjectCacheDB.java:356) at com.ysoft.cache.objectdb.ObjectCacheDB. delete (ObjectCacheDB.java:347) at eu.ysoft.safeq.ors.CacheDBWrapper. delete (CacheDBWrapper.java:73) at ysoft.sqcore.job.CacheJobManager

.o.PRG.af(PRG.java:553) at com.objectdb.o.QRM.Vb(QRM.java:286) I am doing a bulk load for customer ... . So bulk load of data into the database should be done in smaller transaction (with begin and commit

. All ResolverMapping entities are removed by a query ( DELETE FROM ...), afterwards ResolverMapping entities ... . If the ToleranceDefinition entity is removed from database by a query ( DELETE FROM ...) then it performs. The data ... .7.1_03. btc_es BTC EmbeddedSystems OK. Thanks for the update. Please note that mixing direct DELETE