Обсуждение: Connection pooling
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
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 > >
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
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
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 >> >> >