ObjectDB Database Search

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

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

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

( Class targetEntity ) Create a CriteriaDelete query object to perform a bulk delete operation. Parameters: targetEntity - target type for delete operation Returns: the query object. Since: Jakarta

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

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

Jakarta Persistence (JPA) Method in jakarta.persistence.criteria.CriteriaBuilder CriteriaDelete createCriteriaDelete (    Class targetEntity ) Create a CriteriaDelete query object to perform a bulk delete operation. Parameters: targetEntity - target type for delete operation Returns: the query object. Since: Jakarta Persistence (JPA) 2.1

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

Hello All, I am getting the constraint violation exception whil deleting the entries I ... need to delete   records in both tables (TransportationEvent and Conclusion) here i am trying to delete conclusion table records like bellow: removeConclusions(conclusion.getId()); public void

to Parent, so that when the parent is deleted all children are removed as well. Unfortunately, in ... the following case not all children are deleted : ... Parent parent = new Parent(); parentRepository ... is persisted parentRepository. delete (parent); // Here trying to delete the parent

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

; common.model.UserSession$_ delete _closure1     mr.model.MRAuction$_ delete _closure2     mr.model.MRAuction$_ delete _closure3     mr.model.MRAuction$_ delete _closure4     mr.model.MRAuction$_ delete _closure5     mr.model.MRAuction

. They were present before and also saved in the DB, but are deleted for some time now. When I open the DB ...  ? jakab Gergely Jakab You can delete old classes using the Explorer of version 2.8.3_05 (right click - Delete , or from the Edit menu). Please check if this solves the issue. support Support I

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

DELETE statement. PessimisticLockException - if pessimistic locking fails and the transaction

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

.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

. 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

RackPlanogram p WHERE p.rackOID = "826268" AND p. deleted = FALSE Query plan 1/2 description ============================ [Step 1] Scan index eu.extech.quant.data.planogram_lifecycle.RackPlanogram[ deleted ] locating RackPlanogram (p) instances that satisfy: (p. deleted =false). [Step 2] Scan index eu.extech.quant

__odbtracker/m (type STA, value=Persistent- Deleted -Flushed) which shows that the entity is deleted ... what is the problem? best regards BTC btc_es BTC EmbeddedSystems If an entity was deleted from ... at least two different snapshots of objects - one with the deleted object and the other without the deleted object

have inserted. I'm currently evaluating your product. So i insert and delete a lot of data. I also tried ... reference integrity and it is the application responsibility to avoid deletion from the database ... will be produced. support Support The orphan Position records are there because i deleted some Units with a DELETE

. The code looks like:    Query query = em.createQuery(" DELETE FROM DataHolder d WHERE d ... is persisting more data, the other group is deleting the first set of data via delete statements. Eventually ... the application the data sizes are larger so I guess the delete is slower and gives the appearance

the database but their classes have been deleted or missing? This is abnormal state for a database ... itself, is it correct that the objects are in the database but their classes have been deleted or missing ... of deleting classes using the Explorer, so it may be related. We cannot reproduce the exceptions