Rollback transaction in hibernate

When some exception occurs (for example, unique constraint in DB), then catch block executes. After one error, I cant create another rows… I get exception about old error. For example, I create user „test”, then I trying add user with same name „test” and I’m getting hibernate error in log file. Then I’m trying to add new unique user, with new username „test2”, but still get old error about „test” user. Where is the problem?

So, real example:

I'm added testuser1@ttt.org, after that, I tryed add this user once more (and gets exception(below))... Now I'm trying to add user "testuser3@ttt.org" but I'm getting this error about testuser1@ttt.org again:

Are you sure you're interpreting the logs correctly? I don't see two identical error messages with different timestamp in your log.

If you're getting this result consistently, perhaps you could create a SSCCE?

By the way, catching Exception and returning null instead doesn't look good to me. I'd prefer to have an exception unwind through the application to the level where it can be handled (probably to the point where you're able to tell the user an error has happened). But I don't think this is the cause of your problems.

Andris Sigs

Greenhorn

Posts: 19

posted 3 years ago

1

So, problem was in Session… After each error I must create new Session…