Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connection pooling

Connection pooling

From
Håkan Jacobsson
Date:
Hi,

I'm trying to convert a large EJB 3.0 - project into a
standalone JDBC project (J2SE).
I want (of course) to optimize performance best I can,
especially in regard to database connections.
JDBC Connection pooling seems to be an interesting feature.
Can someone point me to a good article, tutorial on connection
pooling?

We are using Postgresql version 8 and JDBC 3 driver.

/Regards, Håkan Jacobsson - System developer at Relevant
Traffic, Stockholm

Re: Connection pooling

From
Dave Cramer
Date:
Håkan Jacobsson wrote:
> Hi,
>
> I'm trying to convert a large EJB 3.0 - project into a
> standalone JDBC project (J2SE).
> I want (of course) to optimize performance best I can,
> especially in regard to database connections.
> JDBC Connection pooling seems to be an interesting feature.
> Can someone point me to a good article, tutorial on connection
> pooling?
>
Have a look at apache's dbcp, or c3po connection pools

Dave
> We are using Postgresql version 8 and JDBC 3 driver.
>
> /Regards, Håkan Jacobsson - System developer at Relevant
> Traffic, Stockholm
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>

Re: Connection pooling

From
Guy Rouillier
Date:
Håkan Jacobsson wrote:
> Hi,
>
> I'm trying to convert a large EJB 3.0 - project into a
> standalone JDBC project (J2SE).
> I want (of course) to optimize performance best I can,
> especially in regard to database connections.
> JDBC Connection pooling seems to be an interesting feature.
> Can someone point me to a good article, tutorial on connection
> pooling?

In what environment will you be running your standalone JDBC project?
If you are just running it from the command line using "java ...", then
connection pooling isn't going to be of much assistance.  Regardless, I
did a Google search of "postgresql connection pool" and got lots of
hits.  pgpool is the first one, and is a connection pool specifically
for PostgreSQL.

--
Guy Rouillier

Re: Connection pooling

From
Dave Cramer
Date:
Guy Rouillier wrote:
> Håkan Jacobsson wrote:
>> Hi,
>>
>> I'm trying to convert a large EJB 3.0 - project into a standalone
>> JDBC project (J2SE).
>> I want (of course) to optimize performance best I can, especially in
>> regard to database connections.
>> JDBC Connection pooling seems to be an interesting feature. Can
>> someone point me to a good article, tutorial on connection pooling?
>
> In what environment will you be running your standalone JDBC project?
> If you are just running it from the command line using "java ...",
> then connection pooling isn't going to be of much assistance.
> Regardless, I did a Google search of "postgresql connection pool" and
> got lots of hits.  pgpool is the first one, and is a connection pool
> specifically for PostgreSQL.
>
Which to my knowledge will not work with jdbc.

Dave

Re: Connection pooling

From
Håkan Jacobsson
Date:
Dave,

Thanx - Ill do that.

/Håkan


>----Ursprungligt meddelande----
>Från: pg@fastcrypt.com
>Datum: 04-10-2007 13:30
>Till: "Håkan Jacobsson"<hakan.jacobsson99@bredband.net>
>Kopia: <pgsql-jdbc@postgresql.org>
>Ärende: Re: [JDBC] Connection pooling
>
>Håkan Jacobsson wrote:
>> Hi,
>>
>> I'm trying to convert a large EJB 3.0 - project into a
>> standalone JDBC project (J2SE).
>> I want (of course) to optimize performance best I can,
>> especially in regard to database connections.
>> JDBC Connection pooling seems to be an interesting
feature.
>> Can someone point me to a good article, tutorial on
connection
>> pooling?
>>
>Have a look at apache's dbcp, or c3po connection pools
>
>Dave
>> We are using Postgresql version 8 and JDBC 3 driver.
>>
>> /Regards, Håkan Jacobsson - System developer at Relevant
>> Traffic, Stockholm
>>
>> ---------------------------(end of broadcast)
---------------------------
>> TIP 6: explain analyze is your friend
>>
>>
>