DB Concepts - Database connections are not closed properly when a query includes a database link to a remote database.
Article ID: KB0084331
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | 5.2.2 , 5.3.0 |
Description
"Database connections unavailable" messages seen when the number of configured connections is reached (JDBC resource). This issue occurs only when using a OJDBC driver from the Oracle 12 Database Works as expected when using a JDBC driver from Oracle 11g.
Sample queries that could cause this issue(@XE is the linked database.
Database.queryUsingSQL(): Select * from beuser.DBCpt_testSupport where prop1 not in (select prop2 from DBCpt_LinkTable@XE)
Database.Templates.templateQuery(): Select * from beuser.DBCpt_testSupport a ,(select prop2 from DBCpt_LinkTable@XE)
Sample queries that could cause this issue(@XE is the linked database.
Database.queryUsingSQL(): Select * from beuser.DBCpt_testSupport where prop1 not in (select prop2 from DBCpt_LinkTable@XE)
Database.Templates.templateQuery(): Select * from beuser.DBCpt_testSupport a ,(select prop2 from DBCpt_LinkTable@XE)
Issue/Introduction
"Database connections unavailable" message seen when the number of configured connections is reached (JDBC resource). This issue is seen only when using OJDBC drivers from the Oracle 12 Database. Works as expected when using the JDBC driver from Oracle 11g.
Environment
All Supported Platforms
Resolution
In TIBCO BusinessEvents 5.2.2 HotFix-6 we added a new pool specific to the Oracle driver 12 and onwards. To use the new Oracle 12 driver, set the property "be.dbconcepts.oracle.pool.v12" to true. The default behavior is to use the Older oracle pool. Note that for JDBC v12 , you need to copy two JARs, ojdbc7.jar and ucp.jar in your third party libs location. This location is usually BE_HOME/lib/ext/tpcl .
Additional Information
CR BE-24509
Feedback
Yes
No
Powered by
