ActiveMQ
  1. ActiveMQ
  2. AMQ-3289

ActiveMQ has problems storing >4K messages in Oracle

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 5.4.0, 5.5.0
    • Fix Version/s: 5.6.0
    • Component/s: Message Store
    • Labels:

      Description

      The oracle persistence adapter extends the blob jdbc adapter but it has gotten out of sync with the method overrides. @Override to the rescue for the future.
      The blob adapter uses native blob streaming to insert data (which can accommodate > 4k) but it has been out of step for some time.
      The implementations need to be brought into line w.r.t to the api, schema and locking.

      1. OracleJDBCAdapter.java
        3 kB
        William McDonald
      2. BlobJDBCAdapter.java
        5 kB
        William McDonald

        Activity

        Gary Tully created issue -
        Hide
        Gary Tully added a comment -

        updated the blob adapter in revision: http://svn.apache.org/viewvc?rev=1095376&view=rev

        Need someone with a handy Oracle install to validate the fix. Verify send received persistent messages > 4k

        Kicked off a snapshot that will be done in an hour or so.

        Show
        Gary Tully added a comment - updated the blob adapter in revision: http://svn.apache.org/viewvc?rev=1095376&view=rev Need someone with a handy Oracle install to validate the fix. Verify send received persistent messages > 4k Kicked off a snapshot that will be done in an hour or so.
        Gary Tully made changes -
        Field Original Value New Value
        Resolution Fixed [ 1 ]
        Status Open [ 1 ] Resolved [ 5 ]
        Hide
        Gary Tully added a comment -

        It looks like the ojdbc6 drivers avoid this problem as they use the default adapter.

        Show
        Gary Tully added a comment - It looks like the ojdbc6 drivers avoid this problem as they use the default adapter.
        Hide
        William McDonald added a comment -

        Updates to make blob work with Oracle 10g.

        Show
        William McDonald added a comment - Updates to make blob work with Oracle 10g.
        William McDonald made changes -
        Attachment BlobJDBCAdapter.java [ 12493341 ]
        Attachment OracleJDBCAdapter.java [ 12493342 ]
        Gary Tully made changes -
        Fix Version/s 5.6.0 [ 12317974 ]
        Fix Version/s 5.x [ 12316331 ]
        Hide
        Gary Tully added a comment -

        reopening to take in Williams patch

        Show
        Gary Tully added a comment - reopening to take in Williams patch
        Gary Tully made changes -
        Resolution Fixed [ 1 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        Hide
        Gary Tully added a comment -

        patch applied with thanks in http://svn.apache.org/viewvc?rev=1173605&view=rev

        @William, if you get a chance, can you validate tonight's 5.6-SNAPSHOT against Oracle.

        Show
        Gary Tully added a comment - patch applied with thanks in http://svn.apache.org/viewvc?rev=1173605&view=rev @William, if you get a chance, can you validate tonight's 5.6-SNAPSHOT against Oracle.
        Gary Tully made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        20m 19s 1 Gary Tully 20/Apr/11 12:56
        Resolved Resolved Reopened Reopened
        153d 4h 27m 1 Gary Tully 20/Sep/11 17:23
        Reopened Reopened Resolved Resolved
        20h 23m 1 Gary Tully 21/Sep/11 13:47

          People

          • Assignee:
            Gary Tully
            Reporter:
            Gary Tully
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development