ObjectDB Database Search

and use persist() to write them to the database.  But does running a JPQL update or delete alter ... ; greymatter Lee Grey UPDATE and DELETE queries bypass the EntityManager entity object management ... for more details: DELETE queries UPDATE queries After using these queries you may use refresh , or

Hi support team, I have a problem when using DELETE query to delete Entity instances. We use ... a profile I run a DELETE query on the old profile , hoping that this would lead to the field "profile ... if the profile instance is such a "intermediate/ deleted " instance. Is there a way to safely detect

Hi, I created the test.odb file, read the contents and now trying the delete the odb file using ... .close(); }   After executing the above code, when i am trying to delete the file using ... ;for (File temp : files ) {         boolean deleted = file. delete

, 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

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

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

when a database is opened and deletes it when the database is closed. The recovery file name ... tests. The content of these temporary databases is deleted when you use the drop URL connection

for deletion , and so on. Query results are not limited to entities. You can use almost any valid JPQL ... to update and delete , which require managed entities. Managed entities can, however, be returned from

is marked for removal (when remove() is called). @PostRemove : Invoked after an entity is deleted from

, CURRENT_TIME, CURRENT_TIMESTAMP, DELETE , DESC, DISTINCT, ELSE, EMPTY, END, ENTRY, ESCAPE, EXISTS, FALSE

., for update or delete . If the query is not an update or delete query, query execution will result in ... 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

, 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

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

: 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

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

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

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

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

. - 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

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

;     private boolean deleted ;     private Date modificationTS ... ------------------- [1] Page #19753 entry 0 has unexpected field count (7 instead of 5) 0. oid = '567651' 1. deleted ... #33279 entry 1 has unexpected field count (7 instead of 5) 0. oid = '559770' 1. deleted = false 2

.AbstractCallSite.callGetProperty(AbstractCallSite.java:296) at app.database.ObjectDbDatabase. delete _all_entities(ObjectDbDatabase.groovy:69) at app.framework.Database$ delete _all_entities$0 ... (AbstractCallSite.java:296) at app.database.ObjectDbDatabase. delete _all_entities(ObjectDbDatabase.groovy:69) at app

; } } private static EntityManager createEntityManager(String dbFileName, boolean delete ) {   EntityManagerFactory emf = null;   if ( delete ) {    new File(dbFileName). delete ();    new File(dbFileName + "$"). delete ();   }   emf = Persistence

createEntityManager(String dbFileName, boolean delete ) {   EntityManagerFactory emf = null;   if ( delete ) {    new File(dbFileName). delete ();    new File(dbFileName + "$"). delete ();  

when the JdoBlob2 gets deleted . I use JavaVirtualVm to look at my application heap to see the references to the byte ... to rid the cache of older JdoBlob2s, leaving the newer ones in the cache, such as delete 1/2 ... that legitimately implicitly is telling ObjectDB to keep strong references?)  Recall that if I delete

when trying to execute in explorer (max heap size 1GByte) delete from LogEntry l it comes up with a Java heap error after 20 minutes of executing. How to empty such a table ?     hgzwicker ... . You can try deleting these objects in batches, using several transactions, each transaction will delete

. ObjectDB does not purge old recording files. However, you can delete old odr files manually or from ... #3500781. If you want to delete all the odr files except the last one, 9123744.odr, you should first ... ,and which can be deletes . When you run the replayer it takes one parameter, the database file.  

them. Check that new embedded objects are created and then delete all the unwanted entity objects ... delete now the unwanted entity objects? Since I upgraded the schema where these objects are declared as ... running the delete query from a small console application. If it doesn't work you may have to set

recording? I suppose that we can harmlessly delete all recordings when ODB Server is offline ... transactions are written to the basepoint and deleted later to save disk space?   thamal Tomas Hamal ... , so I would rather delete all transactions and create new base file. But I would like to know if I

.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

.getResultList(JpaQuery.java:719) at schemaupdate. delete .UpdateDB.main(UpdateDB.java:32) Exception in thread ... ) at schemaupdate. delete .UpdateDB.main(UpdateDB.java:32) btc_es BTC EmbeddedSystems Thank

Hello, we can't understand why the performance of queries is not the best and the execution requires so much memory. In the implementation of our UnitTests we have used " DELETE FROM Object" to delete the database. That did not work because we often get an "out of memory" exception

Hi, I have deleted an instance of ClassA . However, if I try to access ClassB , which has a field of type ClassA , ClassB.classA , then, rather than getting a null pointer for classB.classA , I ... are removed/ deleted from the databases - it is the application responsibility to clear any references

; em.createQuery(" delete from Street s").executeUpdate();         em.createQuery(" delete from Location l").executeUpdate();        

Hello, we have questions about the file size of ObjectDB database on disk. Can you tell us something about how the deleting of entities affects the size of *.odb files on disk? -Will the released ... ; We have created a small test, in which we create and delete entities. It looks like that the released memory

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

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

with FetchType.LAZY. If I now delete a root entity using EntityManager.remove all leaf nodes will not be deleted . This only applies to the leaf nodes. If I add an additional the behaviour changes so that these new leafes will not be deleted . I created a small test case which can be downloaded at 

.ObjectCacheDB.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

.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

Hi, When deleting an entity "Mitglied" - everything works fine. Trying to delete another one (in a separate transaction) always causes a NullPointer Exception in __odbGetNumMember line 1 of the enhanced Mitglied class. I am unable to replicate it in a simple testcase but it always happens in

and the os allowed us to delete the files in question without any problem. In this case we weren't ... ? support Support It was repeatable at the time but we ended up deleting the odb$ to get the app started

? What combination of DELETE / INSERT / UPDATE operations are in that huge transaction? Can we assume ... ; What combination of DELETE / INSERT / UPDATE operations are in that huge transaction? Possible