ObjectDB Database Search

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

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

that there are no already deleted objects in the graph to delete but it still didn't work. As you can see my testcase does ... because, in the same transaction, I gather an Extent, delete an object, then try to gather the same ... that was deleted . The fix was to do a PersistenceManager.flush() before trying to gather the Extent

. - If it's an update to an existing track, delete the entire previous entry and then add in the new ... more embedded objects whenever possible. Delaying the delete operations to time with less or no activity (and if you can use one transaction for deletion of many updates it can also improve performance

erase the DB and start all over. But that's a problem. I have discovered it when I had to delete and set the new database in production. It just didn't want to respect the restrictions. I had to delete ... . Otherwise I can't do it. What is it to be done? zmirc Mircea Chirac will not delete classes

to null except the primary key. The same behavior is when we  delete with a query use entityManager ... ;explicitly, in addition to deleting it. However, if the set is defined as mapped by , it will be updated automatically after committing the delete operation and then reloading of the object that contains

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

__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

Let's say I no longer need some entity in my project and after deleting all the objects ... I found a description that the DB Explorer should be capable to delete classes? But it seems not ... of deleting classes in the Explorer. An obsolete class can be selected in the Schema / Managed

at this point is performing a delete query for all entity objects that the database contains: EntityManager em = _emf.createEntityManager(); em.getTransaction().begin(); try { Query query = em.createQuery(" DELETE FROM ExecutionGraph g"); query.executeUpdate(); query = em.createQuery(" DELETE FROM

Hi. It would be very useful to be able to delete an entire entity class from ObjectDB ... .8.2 adds support of deleting classes in the Explorer. An obsolete class can be selected in the Schema / Managed Types list and then deleted  by using [Edit Delete ] from the menu bar or right click (context menu) and Delete . support Support