About delete

21-30 of 200Refresh
Forum
23

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
23

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
23

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
23

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

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
Issue
23

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
22

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
22

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
Issue
22

cannot delete objects after crash (see issue 2283)

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  meanwhile the database became completely unusable, we had to stop and run the Doctor. Find
Issue
22

delete of a collection in explorer changes type

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 ? Is it only an issue with the type of the field as shown by the Explorer or