<p>We have been running the BIRT sample viewer on Jboss using mostly Oracle for the datasource for many years. We just switched to a Postgres backend and are encountering significant issues. Accessing a single report in the sample viewer results in many connections to the Postgres database. </p>
<p> </p>
<p>The report in question has multiple datasets bound to tables in a parent-child relationship, Dataset1 drives rows in Table1, each row in Table1 contains a table bound to Dataset2 which takes a parameter from Dataset1, etc. It appears that Dataset1 opens Connection1, fetches a row, then Dataset2 opens Connection2 draws its table, when Dataset1 moves on to row 2, Dataset2 then opens Connection3. For the single report in question, I have seen it open as many as 68 connections at one time. </p>
<p> </p>
<p>Now for the fun parts. I have seen this behavior in both the sample viewer on Jboss and the report designer on a windows desktop. The same report in the same jboss environment utilizing the Oracle JDBC driver and backend does NOT exhibit the same behavior- it uses a single connection. Same thing for the MySQL driver. </p>
<p> </p>
<p>I am at a complete loss. For the moment, I have put in a PGPool that I connect BIRT to which kills off idle connections after a few seconds. This has limited the number of connections dramatically- the 68 connection report now uses just 6.</p>
<p> </p>
<p>Some environment information:</p>
<p>BIRT 4.3.1 sample viewer</p>
<p>JBoss AS 7</p>
<p>JDK 1.7.0_01</p>
<p>Centos 6.4 64-bit</p>
<p>postgresql-9.3-1100.jdbc4.jar</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
