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. BlobJDBCAdapter.java
        5 kB
        William McDonald
      2. OracleJDBCAdapter.java
        3 kB
        William McDonald

        Activity

        Gary Tully created issue -
        Gary Tully committed 1095376 (15 files)
        Reviews: none

        https://issues.apache.org/jira/browse/AMQ-3289 - ActiveMQ has problems storing >4K messages in Oracle - brought BlobAdapter up to speed and added @Override to other adapters to catch this sort of problem in the future

        activemq trunk
        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 ]

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development