DDL scripts for BPEL does not work correctly on EAP

DDL scripts for BPEL does not work correctly on EAP. I used scripts located in $EAP_HOME/sql/riftsaw-dao-jpa-hibernate. I found out that when database is not manually initialised then Riftsaw will initialise it itself with scripts located in engine-3.2.2.Final-redhat-1.jar (Fuse 6.2.1 ER2).

MySQL

• Our provided script: FAILED => SQL procedure "execute_if_not_exists" is not defined.
• Riftsaw script: OK

PostreSQL

• Our provided script: FAILED => SQL procedure "execute_if_not_exists" is not defined.
• Riftsaw script: OK

DB2

• Our provided script: FAILED => DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.122 (http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000777.html?cp=SSEPGG_9.7.0%2F2-10-3-2-18)
• Riftsaw script: FAILED => DB2 SQL Error: SQLCODE=-604, SQLSTATE=42611 (http://www.sqlerror.de/db2_sql_error_-604_sqlstate_42611.html)

Oracle

• Our provided script: FAILED => ORA-00942: table or view does not exist
• Riftsaw script: FAILED => ORA-00907: missing right parenthesis
• I tried this: https://github.com/riftsaw/riftsaw/blob/3.2.2.Final/engine/src/main/resources/sqls/oracle.sql
  • PARTLY WORKS => Some tests are failing.

SQLServer2008

• Our provided script: OK
  • Integration tests are failing. Some of errors in log.
    • SQL Error: 1033, SQLState: S0001

    • Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

    • Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'dual'.

• Riftsaw script: OK
  • Integration tests are failing. Some of errors in log.

    • 09:33:56,441 ERROR [org.riftsaw.engine.internal.BPELEngineImpl] (http-localhost/127.0.0.1:8080-1) Timeout or execution error when waiting for response to MEX {MyRoleMex#hqejbhcnphraldogql3l7s [Client hqejbhcnphraldogql3l7r] calling {urn:org.jboss.soa.integration:bpel-error-handler-test:1.0}TestProcessPortType.process(...)} java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@240ad273 timed out(120000 ms) when waiting for a response!: java.util.concurrent.TimeoutException: Message exchange org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@240ad273 timed out(120000 ms) when waiting for a response!

    • Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 54) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

H2 external server

• Our provided script: FAILED => SQL procedure "execute_if_not_exists" is not defined.
  • Integration tests are failing.

    • 10:16:56,886 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ODEServer-1) Table "BPAF_EVENT" not found; SQL statement:

      insert into BPAF_EVENT (EID, ACTIVITY_DEFINITION_ID, ACTIVITY_INSTANCE_ID, ACTIVITY_NAME, CURRENT_STATE, PREVIOUS_STATE, PROCESS_DEFINITION_ID, PROCESS_INSTANCE_ID, PROCESS_NAME, SERVER_ID, TIMESTAMP) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [42102-188]

• Riftsaw script: OK

I think that provided scripts should be the same as scripts contained in engine-3.2.2.Final-redhat-1.jar.