When building the connector with mvn package -P test an additional repository job "SAP BOBJ 4.2 - Connector Test" will be included in the package. This job fails on Sybase ASE, because two passes:
01 Create Test Persons
11 Delete Test Persons
use Common Table Expressions, which are not supported by Sybase. The error message that occurs in the job log is:
Exception executing with t(counter) as ( select 1 FROM DUAL union all select 2 FROM DUAL union all select 3 FROM DUAL ) select * from t order by counter
java.lang.Throwable: Incorrect syntax near the keyword 'with'.
What's more, the pseudo table DUAL used to select from is specific to Oracle and won't work on Sybase either.
When building the connector with
mvn package -P testan additional repository job "SAP BOBJ 4.2 - Connector Test" will be included in the package. This job fails on Sybase ASE, because two passes:use Common Table Expressions, which are not supported by Sybase. The error message that occurs in the job log is:
What's more, the pseudo table DUAL used to select from is specific to Oracle and won't work on Sybase either.