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.4) | 3.6 Scheduler API >> |