Hey, does any one can give me some references or advices on how to control on changes in the DB, audit them and have the ability to rollback.
My application is in Java

Thank you

So long as you maintain a connection to the DB and are using transactions then you can do the following :

1. Begin transaction
2. Make changes to your data
3. Select from tables that have changed data
4. If correct commit, else rollback.

I mean that the client can do changes, temporary save.
and after a week can do cancel or apply changes

THis article will give you some ideas on Point in Time database architecture.

After a week
What happens if two people make a change to the same data then try to commit that information after a week? Which one gets priority? The person who submits first will have their information overwritten by the person who submits second.

Let say user a and user b open a transaction to the DB.
They dont see each other changes. (in the default behavior).
at the end they both ask for commit.

The same behavior in this case will be in my case.

the client open a " transaction " write in some temporal workspace (he dosnt overide the data , i dont know how to do this).
The other users can see his changes.
At the end he will ask for apply changes.

If the data has already changed the user will get a message on conflict and he will need to do a merge.