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

        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.
        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.
        Hide
        Gary Tully added a comment -

        reopening to take in Williams patch

        Show
        Gary Tully added a comment - reopening to take in Williams patch
        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.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development