https://answers.axonivy.com/questions/1677/use-of-connection-pool<p>Hi</p> <p>Is it possible to use the connection pool from ivy in a Java class?</p> <p>I currently reading the database configuration with : <code> Ivy.wfCase().getApplication().findExternalDatabaseConfiguration("myDB") </code></p> <p>and open the configuration with: <code> ch.ivyteam.db.jdbc.DatabaseUtil.openConnection(dbConf) ch.ivyteam.db.jdbc.DatabaseUtil.DatabaseUtil.closeConnection(conn); </code></p> <p>With this approach it doesn't use the pooled connections like in an ivy database step.</p>enMon, 14 Mar 2016 13:55:14 -0400https://answers.axonivy.com/questions/1677/use-of-connection-pool/1682<p>Hi </p> <p>You can use the following <strong>NON Public</strong> API:</p> <pre><code>IExternalDatabaseApplicationContext applicationDbContext = (IExternalDatabaseApplicationContext)Ivy.wfCase().getApplication().getAdapter(IExternalDatabaseApplicationContext.class); IExternalDatabase database = applicationDbContext.getExternalDatabase(externalDatabaseConfiguration); Connection connection database.getConnection(); // get connection from pool try { .... } finally { connection.close(); // give back connection to pool } </code></pre> <p>Note that this is an <strong>INTERNAL</strong> API. Therefore, it can change without further notice from version to version.</p>Reto WeissMon, 14 Mar 2016 13:55:14 -0400https://answers.axonivy.com/questions/1677/use-of-connection-pool/1682