PGPoolingDataSource problem.

I am using the JDBC3 PGPoolingDataSource to create a pool of 5 connections
(for test) to my database.

public class DatabasePool {

private static PGPoolingDataSource dbp = null;

private static Connection conn = null;

public static PGPoolingDataSource getInstance(){

if (dbp == null){

dbp = new PGPoolingDataSource();

try{

PGPoolingDataSource source = new
PGPoolingDataSource();

source.setDataSourceName("DataSource");

source.setServerName("XX.XX.XX.XX");

source.setDatabaseName("dbname");

source.setUser("user");

source.setPassword("password");

source.setMaxConnections(5);

dbp = source;

}catch(Exception e){

e.printStackTrace();

}

}

return dbp;

}

public Connection getConnection(){

PGPoolingDataSource pgdb = (PGPoolingDataSource)getInstance();

conn = null;

try{

conn = pgdb.getConnection();

}catch(Exception e){

e.printStackTrace();

}

return conn;

}

public static void closeConnection(){

if (conn != null){

try{conn.close();conn = null;}catch(Exception e){}

}

}

}

I get a leaked connections when I grab more than one connection from the
pool at a time.

Public void insertData(){

DatabasePool db = new DatabasePool();

Try{

PreparedStatement ps =
db.getConnection().preparedStatement(sql);

Ps.setString(1, getValue(XX);

Ps.execute();

}catch(Exception e){

e.printStackTrace();

} finally{

try{rs.close();rs=null;}catch(Exception e){}

try{ps.close();ps=null;}catch(Exception e){}

try{DatabasePool.closeConnection();db=null;}catch(Exception e){}

}

}

Private String getValue(String XX){

DatabasePool db = new DatabasePool();

String retVal = "";

Try{

PreparedStatement ps =
db.getConnection().preparedStatement(sql);

ResultSet rs = ps.executeQuery();

While (rs.next()){

retVal = rs.getString(1);

}

}catch(Exception e){

e.printStackTrace();

}finally{

try{rs.close();rs=null;}catch(Exception e){}

try{ps.close();ps=null;}catch(Exception e){}

try{DatabasePool.closeConnection();db=null;}catch(Exception e){}

}

}

After running through insertData() once, can see 2 connections on the
database. But if I run through it again, then there are 3 connections when I
expect there to still be only two. It works fine until I hit the
maxConnections and then everything craps out. When I move the getValue(XX)
to before opening the first connection, everything works as I should.

Changed insertData()

Public void insertData(){

DatabasePool db = new DatabasePool();

Try{

String myValue = getValue(XX);

PreparedStatement ps =
db.getConnection().preparedStatement(sql);

Ps.setString(1, myValue);

Ps.execute();

}catch(Exception e){

e.printStackTrace();

} finally{

try{rs.close();rs=null;}catch(Exception e){}

try{ps.close();ps=null;}catch(Exception e){}

try{DatabasePool.closeConnection();db=null;}catch(Exception e){}

}

}