If you're looking for a transaction aware connection pool, along with associated JTA transaction manager, I really like Bitronix (open source). C3P0 is not transaction aware.
Brett Sent from my iPhone On Nov 21, 2009, at 3:46, [email protected] (Dag H. Wanvik) wrote: > >> I am using embedded derby 10.3. >> >> Is there need for C3P0 connection pool software because i am >> creating lot of >> short lived connections to database? > > I vaguely remember an issue with C3PO, not sure if the interrupt issue > described here could be a problem for you, or if it even was due to > C3PO usage, but thought I'd mention it.. > > http://old.nabble.com/ERROR-08000:-Connection-closed-by-unknown-interrupt-td16060173.html > > Dag
