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

Wrong SQL in oracle-jdbc2-service.xml example

XMLWordPrintable

    • Workaround Exists
    • Hide

      Replace the :1 with ?

      Show
      Replace the :1 with ?

      The docs/examples/oracle-jdbc2-service.xml
      contains a bad sql statement.

      DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES MESS WHERE TXOP=:1 AND EXISTS (SELECT TXID FROM JMS_TRANSACTIONS TX WHERE TX.TXID = MESS.TXID)

      The :1 should be replaced with ?

              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: