ObjectDB Database Search

    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

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

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

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

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

.   My situation is where many clients from 1 company are accessing the same counter when bulk

with ObjectDB but also using PostgreSQL warehousing bulk data that is perceived to be seldomly used

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

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

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

.  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

__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

was also trying to find if there was any API like entityManager.find, but for bulk retrieval by primary keys

. Please note that the ability to load mapped by relationships in bulk , which these reports

and the test in the forum passes), but still loading bulk of inverse fields requires performance improvement. support Support

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