Using DB-Connection from PIs

Question

Is it possible to access the DB connection from a PI using

ivy.getProcessEngineHook().getDbConnection(dbName);

as well as for returning (instead of closing):

ivy.getProcessEngineHook().returnDbConnection(dbName, connection); ?

Is this way of accessing the underlying datasource (for SELECT queries inside a PI) the correct one or does this interfere with other queries from Ivy DB process elements running at the same time?

Accepted Answer

0

This is the right way:

import  java.sql.Connection;   
// connect to the database
Connection dbconnection = ivy.getProcessEngineHook().getDbConnection(dbName);
try
{
  // execute sql queries
} finally {
  // close the connection
  dbconnection.close();
}

Of course, it is possible that at the same time other queries are executed, but this should not be a problem.

link

answered 13.01.2010 at 06:06

SupportIvyTeam ♦♦
1.4k●102●118●122
accept rate: 77%

Using DB-Connection from PIs

Follow this question

Related questions