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