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

[Sriram Dandapani]

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://pgfoundry.org/pipermail/pljava-dev/attachments/20060320/3c1ff720/attachment.html