Details
-
Bug
-
Resolution: Done
-
Major
-
2.3.1.Final
-
None
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