ActiveMQ
  1. ActiveMQ
  2. AMQ-1809

Failure with JDBCPersistenceAdapter

    Details

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

      ActiveMQ 5.1.0, JRE 1.6.0_05, Oracle 10.2.04

    • Patch Info:
      Patch Available

      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)

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        10h 41m 1 Rob Davies 20/Jun/08 00:07
        Jeff Turner made changes -
        Project Import Fri Nov 26 22:32:02 EST 2010 [ 1290828722158 ]
        Rob Davies made changes -
        Resolution Fixed [ 1 ]
        Fix Version/s 5.2.0 [ 11841 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Hide
        Rob Davies added a comment -

        Fixed by svn revision 669740.

        Show
        Rob Davies added a comment - Fixed by svn revision 669740.
        Rob Davies made changes -
        Field Original Value New Value
        Assignee Rob Davies [ rajdavies ]
        Jan Wasserbauer created issue -

          People

          • Assignee:
            Rob Davies
            Reporter:
            Jan Wasserbauer
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development