Can you reproduce this behaviour when you use a 'real' database such as MySQL, PostgreSQL or Oracle? Hypersonic is not a production ready database. It is only shipped with JBoss to have something working out-of-the-box.
Moderated: FAQ (both JCA and JBossMQ)
Hi the error you will face coz of following configuration
<blocking-timeout-millis >30000 </blocking-timeout-millis >
Increase the value of timeout to 80000
As Adrian pointed out, please have a look at the FAQ at the beginning of this forum.
Changing the blocking timeout is not the solution to database connection management. Keep your database connection ops short and always return the connection to the pool.
Also ensure that you have a "finally" block where you close the connections.