use connection pooling - Mailing list pgsql-jdbc

From janaka priyadarshana
Subject use connection pooling
Date
Msg-id de1942f0612212258o5861e88cg1627a1bd340d218@mail.gmail.com
Whole thread Raw
Responses Re: use connection pooling  ("janaka priyadarshana" <rpjanaka@gmail.com>)
List pgsql-jdbc
i am tring to use connection pooing with postgresql but i was unable to found complete example about that.

got some idea from the documentation, but i was unable to run the given example.

please help me to getting start..

thanks....





Jdbc3PoolingDataSource source = new Jdbc3PoolingDataSource();
source.setDataSourceName("A Data Source");
source.setServerName ("localhost");
source.setDatabaseName("test");
source.setUser("testuser");
source.setPassword("testpassword");
source.setMaxConnections(10);





Connection con = null;
try {
con = source.getConnection();
// use connection
} catch (SQLException e) {
// log error
} finally {
if (con != null) {
try { con.close(); } catch (SQLException e) {}
}
}

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Exception-handling
Next
From: "janaka priyadarshana"
Date:
Subject: Connection pooling in java