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

Syntax Error in derby-jdbc2-service.xml

XMLWordPrintable

      in the line
      DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE EXITS (SELECT JMS_TRANSACTIONS.TXID FROM JMS_TRANSACTIONS \
      WHERE JMS_TRANSACTIONS.TXID = JMS_MESSAGES.TXID) \
      AND JMS_MESSAGES.TXOP = ?

      there's a syntax error on EXITS istead EXISTS

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

                Created:
                Updated:
                Resolved: