We are using BIRT and performing an Oracle distributed query to SELECT the database from 2 separate SIDs. Unfortunately it appears to take a lock on a rollback segment entry in the remote database since oracle treats it as requiring a Two-Phase commit even though it is SELECT statement (see <a class='bbc_url' href='
http://www.jlcomp.demon.co.uk/faq/dblink_commit.html'>http://www.jlcomp.demon.co.uk/faq/dblink_commit.html</a> for more details). As a result we need to either COMMIT or ROLLBACK to release the lock. How are where we would do this is not obvious. We are using a JNDI datasource with connection pooling under jboss.<br />
<br />
Are there any BIRT developers out there who have faced this problem and if so, what was their solution ?<br />
<br />
TIA
