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

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

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

    XMLWordPrintable

Details

    • 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

            jeff.yuchang_jira Jeff Yu (Inactive)
            rhn-support-jshepher Jason Shepherd
            Archiver:
            rhn-support-adandapa Aitik Dandapat

            Dates

              Created:
              Updated:
              Resolved:
              Archived:

              PagerDuty