Hibernate pre invalidating space
User Data Controller.update User(User Data Controller.java:168) at sun.reflect.
Native Method Accessor Impl.invoke0(Native Method) at sun.reflect.
SUPPORTS, read Only=true) public IUser find(final Long id)2008-08-29 ,488 DEBUG [http-8443-1] about to open Result Set (open Result Sets: 0, globally: 0) [org.
For instance, if I try to update a record violating an unique constrain, Mysql will throw and exception that get’s propagated to my application… But if I try any other operation after this, the application get’s blocked and after a while a get a “Lock wait timeout exceeded” exception.
It seems that somehow, the transaction that produces the Mysql exception blocks the database somehow.
I’m having an estrange problem I don’t know how to solve.
To make a long story short: The database hangs after the underlying JDBC controller (in my case mysql-connector-java-5.1.5) throws an exception.