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

Details

    • Workaround Exists
    • Hide

      Replace the :1 with ?

      Show
      Replace the :1 with ?

    Description

      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 ?

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: