C3P0 Connection pooling needed?

[Radim Kolar <hs...@sendmail.cz>]

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?
-- 
View this message in context: http://old.nabble.com/C3P0-Connection-pooling-needed--tp26421467p26421467.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: C3P0 Connection pooling needed?

[Brett Wooldridge <br...@gmail.com>]

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, Dag.Wanvik@Sun.COM (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

Re: C3P0 Connection pooling needed?

["Dag H. Wanvik" <Da...@Sun.COM>]

> 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

RE: C3P0 Connection pooling needed?

[Paul French <pa...@kirona.com>]

If running in embedded mode then don't worry too much about it. If in server
mode then yes.


-----Original Message-----
From: Radim Kolar [mailto:hsn@sendmail.cz] 
Sent: 19 November 2009 20:26
To: derby-user@db.apache.org
Subject: C3P0 Connection pooling needed?


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?
-- 
View this message in context:
http://old.nabble.com/C3P0-Connection-pooling-needed--tp26421467p26421467.ht
ml
Sent from the Apache Derby Users mailing list archive at Nabble.com.


__________ NOD32 4615 (20091117) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com