I am using jboss 3.2.6 with MySQL 4.1 with mysql connector 3.0.16. I am using a DAO object to access persistant data for a BMP beans which works fine but than at some stage the DataSource getConnection method hangs without ever returns. All the connections ever opened are alsways closed however EJB instance has its own instance of the DAO object which holds a reference to a DataSource object.
Could anybody suggest why this may be.