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
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 |