Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-2503

JBossMQ JDBC2 Blob workaround for Oracle 4k limit

XMLWordPrintable

      Allow override of the blob processing and create a subclass of JBossMQ's JDBC2 persistence manager
      such that it can workaround the 4k limit of the thin driver.

      Effectively we translate:
      INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, TXID, TXOP, MESSAGEBLOB) VALUES (?,?,?,?,?)

      into
      INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, TXID, TXOP, MESSAGEBLOB) VALUES (?,?,?,?, EMPTY_BLOB())
      SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE MESSAGEID = ? FOR UPDATE
      UPDATE JMS_MESSAGES SET MESSAGEBLOB = ? WHERE MESSAGEID = ?

      If we knew how to generically retrieve the primary key column and key values from the insert
      we could do this as a plugin to the JDBC resource adapter.
      But parsing SQL is not really an option.

              ryan.campbell_jira ryan.campbell (Inactive)
              adrian.brock Adrian Brock (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: