Postgres Pro
Downloads
Home   >   mailing lists

Recommended resource type and settings for J2EE/Glassfish connection pool - Mailing list pgsql-jdbc

From John Lister
Subject Recommended resource type and settings for J2EE/Glassfish connection pool
Date
Msg-id 02A1185E68DA479596BD9F56FD0CB637@squarepi.com
Whole thread Raw
Responses Re: Recommended resource type and settings for J2EE/Glassfish connection pool  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-jdbc
Tree view
Hi, what is the recommended/supported/best resource type to use with a J2EE server eg Glassfish for the connection pool? I'm currently using javax.sql.ConnectionPoolDataSource with PGSimpleDataSource as the class, however I would have thought an XADataSource would be better?
 
I seem to remember a while ago trying it but having quite a few problems so gave up, but want to look at this again from a performance point of view.
 
 
Also, what settings/parameters would anyone recommend either to the connection pool or the driver itself such as statement caching?
 
Thanks
 
John
--
 
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: JDBC gripe list (the autocommit subthread)
Next
From: Lew
Date:
Subject: Re: Memory leak ?