Uploaded image for project: 'RiftSaw'
  1. RiftSaw
  2. RIFTSAW-470

bpel-console gives SQLException: ORA-00933 with Oracle11G database

    XMLWordPrintable

    Details

    • Steps to Reproduce:
      Hide

      Setup SOA-P to use Oracle 11G as it's backing datasource.
      Open the bpel-console
      Observe the error in the case description in the server.log

      Show
      Setup SOA-P to use Oracle 11G as it's backing datasource. Open the bpel-console Observe the error in the case description in the server.log

      Description

      the following exception was recorded when we go to URL http://servername:8080/bpel-console/

      org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Failed to execute query
      With the root cause:

      Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

      See full exception below. After enabling SQL logging, the SQL query causing the problem was found to be:

      select distinct e.PROCESS_DEFINITION_ID from BPAF_EVENT as e

      Oracle does not support the "AS" keyword in the format used by the BPEL-Console. The code is executing a native hibernate query against ORACLE which is not supported, see [1].

      [1] http://docs.oracle.com/cd/B13789_01/server.101/b10759/ap_standard_sql001.htm
      Search on "Oracle Feature" F312

        Attachments

          Activity

            People

            Assignee:
            jeff.yuchang Jeff Yu (Inactive)
            Reporter:
            jshepher Jason Shepherd
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: