ObjectDB Database Search

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

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

.   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

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

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

; 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

JPA Method in javax.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 in each row

for a Java Persistence query language UPDATE or DELETE statement QueryTimeoutException - if the query

Persistence query language UPDATE or DELETE statement QueryTimeoutException - if the query execution exceeds

JPA Method in javax.persistence.Query List getResultList () Execute a SELECT query and return the query results as an untyped List. Return: a list of the results Throws: IllegalStateException - if called for a Java Persistence query language UPDATE or DELETE statement QueryTimeoutException

query language UPDATE or DELETE statement QueryTimeoutException - if the query execution exceeds

JPA Method in javax.persistence.TypedQuery List getResultList () Execute a SELECT query and return the query results as a typed List. Return: a list of the results Throws: IllegalStateException - if called for a Java Persistence query language UPDATE or DELETE statement QueryTimeoutException

for a Java Persistence query language UPDATE or DELETE statement QueryTimeoutException - if the query

is responsible for updating the ordering upon flushing to the database to reflect any insertion, deletion , or

a constraint whose update and delete actions it determines most appropriate for the join column(s

Persistence query language UPDATE or DELETE statement QueryTimeoutException - if the query execution exceeds

.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

. 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

__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

_CLEAN Since: JDO 1.0 PERSISTENT_ DELETED Since: JDO 1.0 PERSISTENT_DIRTY Since: JDO 1.0 PERSISTENT_NEW Since: JDO 1.0 PERSISTENT_NEW_ DELETED Since: JDO 1.0 PERSISTENT_NONTRANSACTIONAL_DIRTY Since: JDO

JDO Annotation Attribute in javax.jdo.annotations.Join ForeignKeyAction deleteAction default ForeignKeyAction.UNSPECIFIED Delete action to be applied to any ForeignKey on this join. Since: JDO 2.1

JDO Annotation Attribute in javax.jdo.annotations.Key ForeignKeyAction deleteAction default ForeignKeyAction.UNSPECIFIED Delete action to apply to the foreign key for the key. Since: JDO 2.1

JDO Method in javax.jdo.PersistenceManager void flush () Flushes all dirty, new, and deleted instances to the data store. It has no effect if a transaction is not active. If a datastore transaction is active, this method synchronizes the cache with the datastore and reports any exceptions

of being the target of a makeTransactional method call; newly made persistent or deleted persistent instances

JDO Method in javax.jdo.spi.StateManager boolean isDirty (   PersistenceCapable pc ) Tests whether this object is dirty. Instances that have been modified, deleted , or newly made persistent in the current transaction return true . Transient nontransactional instances return false

JDO Annotation Attribute in javax.jdo.annotations.Value ForeignKeyAction deleteAction default ForeignKeyAction.UNSPECIFIED Delete action to apply to any foreign key for the value. Since: JDO 2.1

JDO Static Method in javax.jdo.JDOHelper boolean isDirty (   Object pc ) Tests whether the parameter instance is dirty. Instances that have been modified, deleted , or newly made persistent in the current transaction return true . Transient instances and instances of classes

JDO Method in javax.jdo.PersistenceManager void deletePersistentAll (   Collection pcs ) Delete a Collection of instances from the data store. Parameters: pcs - a Collection of persistent instances See Also: deletePersistent (Object pc) Since: JDO 1.0

JDO Method in javax.jdo.PersistenceManager void deletePersistentAll (   Object... pcs ) Delete an array of instances from the data store. Parameters: pcs - a Collection of persistent instances See Also: deletePersistent (Object pc) Since: JDO 1.0

ForeignKeyAction.UNSPECIFIED Delete action to be applied to any ForeignKey on this join. Since: JDO 2.1

JDO Enum ForeignKeyAction java.lang.Object ∟  java.lang.Enum ∟  javax.jdo.annotations.ForeignKeyAction Enumeration of the foreign-key delete /update action values. Since: JDO 2.1 Enum Constants CASCADE Since: JDO 2.1 DEFAULT Since: JDO 2.1 NONE Since: JDO 2.1 NULL Since: JDO 2.1 RESTRICT

JDO Annotation Attribute in javax.jdo.annotations.ForeignKey ForeignKeyAction deleteAction default ForeignKeyAction.RESTRICT The delete action of this foreign key. Since: JDO 2.1

JDO Method in javax.jdo.spi.StateInterrogation Boolean isDirty (   Object pc ) Tests whether the parameter instance is dirty. Instances that have been modified, deleted , newly made persistent in the current transaction, or modified while detached return Boolean.TRUE . Instances

Since: JDO 2.0 DELETE Since: JDO 2.0 DETACH Since: JDO 2.0 DIRTY Since: JDO 2.0 LOAD Since: JDO 2.0 STORE

ForeignKeyAction.RESTRICT The delete action of this foreign key. Since: JDO 2.1 String[] members default

JDO Annotation Attribute in javax.jdo.annotations.Element ForeignKeyAction deleteAction default ForeignKeyAction.UNSPECIFIED Delete action to apply to any foreign key for the element. Since: JDO 2.1

JDO Method in javax.jdo.spi.PersistenceCapable boolean jdoIsDirty () Tests whether this object is dirty. Instances that have been modified, deleted , or newly made persistent in the current transaction return true. Transient instances return false. Return: true if this instance has been modified in