Use of Connection Pool

Question

Hi

Is it possible to use the connection pool from ivy in a Java class?

I currently reading the database configuration with : Ivy.wfCase().getApplication().findExternalDatabaseConfiguration("myDB")

and open the configuration with: ch.ivyteam.db.jdbc.DatabaseUtil.openConnection(dbConf) ch.ivyteam.db.jdbc.DatabaseUtil.DatabaseUtil.closeConnection(conn);

With this approach it doesn't use the pooled connections like in an ivy database step.

Accepted Answer

Hi

You can use the following NON Public API:

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
}

Note that this is an INTERNAL API. Therefore, it can change without further notice from version to version.

Use of Connection Pool

Follow this question

Related questions