Is Hibernate the right solution for me...

Schokoladenhase · **Joined:** Tue Sep 07, 2004 3:58 am **Posts:** 23

Hi everyone...

Im sorry to bother you, but i am totally new to hibernate and i want to know if its the right solution for me.

The point is that my applications mysql database never actually deletes data, cause it has to implement a history function, e.g. show all data like it was 4-8-2002 or so....

So each table in my model has two coloumns with timestamps - on for creation time and one for the "delete" time....

At first look i wonder if hibernate hasnt to many uncontrollable features... i read about saveorUpdate() and other methods where i dont know if i can configure them that precisely so it handles persistence the way i need it...

Plz anyone help me.... i dont get the clue out of the doc....

Thx...

J

anthony · **Posted:** Tue Sep 07, 2004 4:12 am

you can use hibernate,
you'll have a business method called appDelete which will call myObject.setDeleteTime()... and only "update" in db, easy not?

Schokoladenhase · **Joined:** Tue Sep 07, 2004 3:58 am **Posts:** 23

thx alot...

So i will give it a try... i just dont have the time to read the 150 page docu just to realize "No, not appropriate...."

so a big THX...

J

anthony · **Posted:** Tue Sep 07, 2004 4:30 am

Quote:

In anthony we trust....

better trust in Hibernate ;)

yannraoul · **Posted:** Fri Aug 19, 2005 5:35 am

Is there a fancy/possible way to add a criteria to every select request (and joins !) ?

It is quite easy to change the delete statement by an update statement, but I can't imagine post-filtering results of a query, to check if the "deleted flag" is not set, especially for the associated objects of the graph.

paulcampbell · **Joined:** Mon Aug 08, 2005 5:10 am **Posts:** 5

I think you need to seriously consider organising your data differently. Historic data should be hived off to dedicated tables.

Paul.