https://answers.axonivy.com/questions/314/using-db-connection-from-pisIs it possible to access the DB connection from a PI using <br/> <br/> ivy.getProcessEngineHook().getDbConnection(dbName);<br/> <br/> as well as for returning (instead of closing):<br/> <br/> ivy.getProcessEngineHook().returnDbConnection(dbName, connection); ?<br/> <br/> 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?<br/> enWed, 13 Jan 2010 06:06:03 -0500https://answers.axonivy.com/questions/314/using-db-connection-from-pis/315<p>This is the right way:</p> <pre><code>import  java.sql.Connection; // connect to the database Connection dbconnection = ivy.getProcessEngineHook().getDbConnection(dbName); try { // execute sql queries } finally { // close the connection dbconnection.close(); } </code></pre> <p>Of course, it is possible that at the same time other queries are executed, but this should not be a problem.</p>SupportIvyTeamWed, 13 Jan 2010 06:06:03 -0500https://answers.axonivy.com/questions/314/using-db-connection-from-pis/315