[Pljava-dev] pljava reninitializing jdbc connection pool for every invocation

Hi

Following is the scenario:

A plpgsql function calls a java method using pljava. The initialization
of the jdbc pool seems to be happening with every call to the
getConnection method.

Is there a way to implement singletons within pljava

This is the java code that initializes the pool

private static Jdbc3PoolingDataSource pool;

private static Logger logger = Logger.getLogger(PostgresAdapter.class);

private static PropertyResourceBundle resourceBundle;

public static void setupPool() throws Exception
{

logger.info("***setting up postgres
pool");

PropertyResourceBundle
resourceBundle = null;

resourceBundle = new
PropertyResourceBundle(new FileInputStream("postgres-ds.properties"));

pool = new Jdbc3PoolingDataSource();

logger.info("***finished setting up
postgres pool");

pool.setServerName(resourceBundle.getString("serverName"));

pool.setPortNumber(Integer.parseInt(resourceBundle.getString("portNumber
")));

pool.setDatabaseName(resourceBundle.getString("databaseName"));

pool.setUser(resourceBundle.getString("user"));

pool.setPassword(resourceBundle.getString("password"));

pool.setMaxConnections(25);

}

public static Connection getConnection() throws
Exception {

if(pool == null) {

setupPool();

}

Connection con =
pool.getConnection();

con.setAutoCommit(false);

return con;

}

Many thx in advance for answers

Sriram

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060320/3c1ff720/attachment.html>