[AMQ-1809] Failure with JDBCPersistenceAdapter

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.1.0
• Fix Version/s: 5.2.0
• Component/s: Message Store

Environment

ActiveMQ 5.1.0, JRE 1.6.0_05, Oracle 10.2.04

• Patch Info: Patch Available
• Assignee: Robert Davies
• Reporter: Jan Wasserbauer
• Created: 19/Jun/08 12:25
• Updated: 19/Jun/08 23:07
• Resolved: 19/Jun/08 23:07

Description

When using jdbcPersistenceAdapter with Oracle using DBCP BasicDataSource and poolPreparedStatements set to true (default ActiveMQ configuration), the DBCP pool does not work corretly and opens lots of new connections instead of reusing old ones. It does so until connection count is so high, that database server starts refusing new connections and an exception is thrown.

Problem can be avoided by setting poolPreparedStatements to false and fixed by updating commons-dbcp-1.2.jar to version commons-dbcp-1.2.2.jar

The exception is java.sql.SQLException: Výjimka vstupu/výstupu: Got minus one from a read call
(Full stack trace is in attached text file)