Gabriele Kahlout <[email protected]> writes: > java.sql.SQLException: The exception 'java.sql.SQLException: A lock > could not be obtained within the time requested. The lockTable dump > is:
Hi Gabriele, Just a guess, but could it be that the stored procedure you call from the trigger obtains a new connection to your Derby database instead of running within the current connection? That could result in lock issues like the ones you're seeing. Is this the code that's failing? http://code.google.com/p/memorizeasy/source/browse/trunk/MemorizEasy/src/com/mysimpatico/memorizeasy/engine/Database.java?r=113#162 If so, you may want to try to replace the following lines in refExpTablesComp(): Connection con = null; try{con = getConnection();}catch (Exception e){;} with Connection con = DriverManager.getConnection("jdbc:default:connection"); and see if that makes it work. -- Knut Anders
