Note that lock ordering as part of the application is important (e.g. locking in same order) and that a table being accessed without an index could lead to a Table-level lock, affecting the lock granularity quite significantly and the risk of deadlocks as part of the applications. It seemed like some index might have been missing for some of the columns being searched as part of some queries.
Hegalor, if you still have the deadlock trace (in derby.log), I'd be more than happy to look at it if you want.
[Message sent by forum member 'forsini' (forsini)]