pljava reinitializing pool after every invocation

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: pljava reinitializing pool after every invocation
Date: 2006-03-21 01:12:22
Message-ID: 6992E470F12A444BB787B5C937B9D4DF03C48974@ca-mail1.cis.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-03-21 01:30:23 Re: pljava reinitializing pool after every invocation
Previous Message Andrew Madu 2006-03-18 13:00:33 HowTo change keyStore location and KeyStore Password