3.5.3 Setting the Connection Pool

There are two methods for setting the connection pool. The first method is to set the property jdbc.connection.pool in sree.properties.

jdbc.connection.pool=SimpleConnectionPool

The second method is to programmatically call JDBC.setConnectionPool().

ConnectionPool pool = new SimpleConnectionPool();

inetsoft.uql.jdbc.JDBCHandler.setConnectionPool(pool);

Note that it is important to call the close() function of a JDBCTableNode after using it, because if the system is busy it may cause a deadlock in the connection pool.

<< 3.5.2 releaseConnection() © 1996-2013 InetSoft Technology Corporation (v11.5) 3.6 Scheduler API >>