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

Example postgres config for JBossMQ needs an alias on the union

XMLWordPrintable

    • Workaround Exists
    • Hide

      In docs/examples/jms/postgres-jdbc2-service.xml

      Replace
      SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT M
      AX(TXID) AS TXID FROM JMS_MESSAGES)

      With
      SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT M
      AX(TXID) AS TXID FROM JMS_MESSAGES) AS TXID

      Show
      In docs/examples/jms/postgres-jdbc2-service.xml Replace SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT M AX(TXID) AS TXID FROM JMS_MESSAGES) With SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM JMS_TRANSACTIONS UNION SELECT M AX(TXID) AS TXID FROM JMS_MESSAGES) AS TXID

      Example postgres configuration needs an alias on the union
      when determining the maximum transaction id

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

                Created:
                Updated:
                Resolved: