Re: Blocked threads in Tomcat web app

2009-07-13 Thread Raphael Neve
Rainer Jung-3 wrote: > > > You might want to look at Bloch's book "Effective Java", which has a > section called "Avoid finalizers". The page > > http://java.sun.com/developer/technicalArticles/javase/finalization/ > > also has some introductory material. > > The dbcp pool for instance has

Re: Blocked threads in Tomcat web app

2009-07-13 Thread Raphael Neve
Rainer Jung-3 wrote: > > > [...] > > Yup, and the code run by the finalizer makes a network call (likely to > the database), which seems to be a very bad pattern. Finalizers are not > a great idea by themselves, but one needs to keep them as simple as > possible. Doing network communication in

Re: Blocked threads in Tomcat web app

2009-07-13 Thread Raphael Neve
Rainer Jung-3 wrote: > > TP-Processor16 owns lock at 0x73a71c40 and thus blocks TP12, TP5 and TP1. > > TP16 and TP2 both wait for lock 0x73a71dd0. The thread holding this lock > is not in your dump. > > Since the lock is of type > org.firebirdsql.gds.impl.wire.isc_db_handle_impl, it seems eith

Blocked threads in Tomcat web app

2009-07-13 Thread Raphael Neve
nformation, the code at "fr.microtec.db.Query.prepare(Query.java:119)" is the following : sqlStatement = connection.sqlConnection.prepareStatement(realSQLText); Which is a call to the JDBC "prepareStatement" method. What can be going wrong ? Each user has his own conne