Обсуждение: pljava reinitializing pool after 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