-
1. Remove a revision entry
adamw Mar 17, 2011 12:14 PM (in response to boban_jboss)Sure, just lookup the desired revision entity (it's a normal Hibernate entity), and if you have the on-delete-cascade properly set, if you remove it, all auditd data will be removed as well because of foreign key constraints.
Adam
-
2. Remove a revision entry
boban_jboss Mar 18, 2011 4:20 AM (in response to adamw)Hi Adam,
thank you for the fast reply, but i have to delete more than one revision entity i need something like delete from ... the problem is i have to delete all revisions of all entries with expired hold-back time ... sometimes it can be more than 10000 entries. To load every revision entity and than delete it is, i think, very slow solution. Is there another way to delete revisions maybe with hql?
-
3. Remove a revision entry
adamw Mar 18, 2011 4:30 AM (in response to boban_jboss)Use a HQL bulk delete: delete from RevisionEntity e where e.revisionDate <= :date or sth similar.
Just make sure you have the on delete cascades
Adam
-
4. Remove a revision entry
boban_jboss Mar 18, 2011 6:56 AM (in response to adamw)Hi Adam,
the hold-back time is not the RevisionEntity revision date it is stored in the audited tabele e.g. Resource_AUD, now i have to join my RevisionEntity with the audited Resource_AUD table. If i use
from RevisionEntity re join Resource_AUD ra
i get an excpetion org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! (I think because the mapping i not described) and join on is not supported by hql. How can i join this 2 tables?
Tank you in advance
Boban
-
5. Remove a revision entry
adamw Mar 20, 2011 3:26 PM (in response to boban_jboss)The _AUD entities use the full class name with package in Hibernate. So try adding the package name.
Adam
-
6. Remove a revision entry
boban_jboss Mar 21, 2011 6:43 AM (in response to adamw)Hi Adam,
thank you very much for your help. In the meantime i try it also with full class name and now i get a NullPointerException:
Caused by: java.lang.NullPointerException
at org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:396)
My hql join
from RevisionEntity join com.scanplus.cadn.discoverer.model.FileResourceImpl_AUD fra where fra.expireDate = :expiredDate
whats wrong now? Apart from that envers is working very good.
Boban
-
7. Remove a revision entry
adamw Mar 24, 2011 3:01 AM (in response to boban_jboss)No idea, that would need some debugging.
Adam
-
8. Remove a revision entry
boban_jboss Mar 25, 2011 9:52 AM (in response to adamw)Hi,
at this point, i think, join is not working becaus hibernate don't create mapping between this two tables although they are referenced. To join this tables, the RevisionEntitiy and a _AUD table you have to do a simple hql select such as
select ra, re from org.test.foo.bar.model.ResourceImpl_AUD ra, RevisionEntity re where ra.originalId.REV.id=re.id
Adam thank you for help.
-
9. Remove a revision entry
adamw Mar 25, 2011 9:58 AM (in response to boban_jboss)Hmm it should, but maybe joining entities with two different entity modes doesn't work.
But I suppose it's working for you now
Adam