You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@activemq.apache.org by "Jan Wasserbauer (JIRA)" <ji...@apache.org> on 2008/06/19 14:27:00 UTC
[jira] Created: (AMQ-1809) Failure with JDBCPersistenceAdapter
Failure with JDBCPersistenceAdapter
-----------------------------------
Key: AMQ-1809
URL: https://issues.apache.org/activemq/browse/AMQ-1809
Project: ActiveMQ
Issue Type: Bug
Components: Message Store
Affects Versions: 5.1.0
Environment: ActiveMQ 5.1.0, JRE 1.6.0_05, Oracle 10.2.04
Reporter: Jan Wasserbauer
Attachments: commons-dbcp-1.2.2.jar, exception.txt
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)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (AMQ-1809) Failure with JDBCPersistenceAdapter
Posted by "Rob Davies (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/activemq/browse/AMQ-1809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rob Davies reassigned AMQ-1809:
-------------------------------
Assignee: Rob Davies
> Failure with JDBCPersistenceAdapter
> -----------------------------------
>
> Key: AMQ-1809
> URL: https://issues.apache.org/activemq/browse/AMQ-1809
> Project: ActiveMQ
> Issue Type: Bug
> Components: Message Store
> Affects Versions: 5.1.0
> Environment: ActiveMQ 5.1.0, JRE 1.6.0_05, Oracle 10.2.04
> Reporter: Jan Wasserbauer
> Assignee: Rob Davies
> Attachments: commons-dbcp-1.2.2.jar, exception.txt
>
>
> 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)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (AMQ-1809) Failure with JDBCPersistenceAdapter
Posted by "Rob Davies (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/activemq/browse/AMQ-1809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rob Davies resolved AMQ-1809.
-----------------------------
Fix Version/s: 5.2.0
Resolution: Fixed
Fixed by svn revision 669740.
> Failure with JDBCPersistenceAdapter
> -----------------------------------
>
> Key: AMQ-1809
> URL: https://issues.apache.org/activemq/browse/AMQ-1809
> Project: ActiveMQ
> Issue Type: Bug
> Components: Message Store
> Affects Versions: 5.1.0
> Environment: ActiveMQ 5.1.0, JRE 1.6.0_05, Oracle 10.2.04
> Reporter: Jan Wasserbauer
> Assignee: Rob Davies
> Fix For: 5.2.0
>
> Attachments: commons-dbcp-1.2.2.jar, exception.txt
>
>
> 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)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.