About delete

11-20 of 200Refresh
Forum
33

Bulk Delete and Update - best practice?

The attached test creates 1000 large objects and then attempts to delete them all in one go using a DELETE statement. I'm trying to run with -Xmx512m but the test runs out of memory during the delete ... both tests with the default objectdb.conf. In general is an UPDATE/DELETE statement the most efficient way
Issue
33

Deleting archive log folder causes exception

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
Forum
33

Is there a function of "drop table" or "delete from table"?

Besides the em.remove() one by one, is there a function of "drop table" or "delete from table"? TIA You can execute a DELETE query:     em.createQuery("DELETE FROM MyEntity e").executeUpdate ... . The code “createQuery("DELETE FROM MyEntity e").executeUpdate();” works, but it can not reset id to zero
Forum
32

OneToMany and cascade delete problem

(which is deleted together with product). You can see this in attached example. The question is - is it a bug ... .java:73) I think that the Offer class and cascading delete from Product to Offer are irrelevant ... when the Product is deleted. Otherwise a broken reference from Store to the deleted Product
Forum
32

How to delete a specific column data form a entity.

I have a entity class named Agent having fields Id,Name,Code,Skill ...etc. I wants to delete only the Skill from a row so I use Query like "Delete a.Skill from Agent a where a.Id = 112" but It gives error like "Unexpected query token 'agsk' (FROM is expected)". How to resolve it. Thank You DELETE
Forum
32

Cascading delete

Is there a configuration parameter to set this? You can set cascade delete using annotations (see also the Orphan Removal section). JDO defines similar annotations, and both JPA and JDO support ... . You cannot set global cascade delete since that will be too risky - you may delete the entire database. dmoshal
Issue
32

Issue with cascade delete & add/remove

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
Forum
32

Delete class from DB - through Explorer

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
Forum
32

Cascade delete with unidirectional mapping

    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 call to database
Forum
32

Need disk usage and delete some old files

    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 ?   Since an ObjectDB database ... , please open a new forum thread, since this thread is titled "Need disk usage and delete some old files" and should be focus only on that subject. kadirbasol