Sybase ASE 15.7 doesn't support the "ON DELETE CASCADE" feature. The job repository DDL for ASE contains this clause in multiple statements. This causes a failure when deploying a Batch application if the job-repository is JDBC pointing to a Sybase ASE database. The full stacktrace:
09:38:08,771 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC000001: Failed to start service jboss.deployment.unit."people-test-fail-and-retry.war".POST_MODULE: org.jboss.msc.service.StartException in service jboss.deployment.unit."people-test-fail-and-retry.war".POST_MODULE: WFLYSRV0153: Failed to process phase POST_MODULE of deployment "people-test-fail-and-retry.war" at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:163) at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948) at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: javax.batch.operations.BatchRuntimeException: JBERET000624: Failed to create tables for batch job repository database product name Adaptive Server Enterprise with DDL sql/jberet-sybase.ddl at org.jberet.repository.JdbcRepository.createTables(JdbcRepository.java:231) at org.jberet.repository.JdbcRepository.<init>(JdbcRepository.java:180) at org.jberet.repository.JdbcRepository.create(JdbcRepository.java:109) at org.wildfly.extension.batch.job.repository.JobRepositoryFactory.getJobRepository(JobRepositoryFactory.java:63) at org.wildfly.extension.batch.deployment.BatchEnvironmentProcessor.deploy(BatchEnvironmentProcessor.java:81) at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:156) ... 5 more Caused by: java.sql.BatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: Incorrect syntax near the keyword 'ON'. at com.sybase.jdbc4.jdbc.ErrorMessage.raiseBatchUpdateException(ErrorMessage.java:1300) at com.sybase.jdbc4.jdbc.SybStatement.batchLoop(SybStatement.java:2134) at com.sybase.jdbc4.jdbc.SybStatement.sendBatch(SybStatement.java:1924) at com.sybase.jdbc4.jdbc.SybStatement.executeBatch(SybStatement.java:1882) at com.sybase.jdbc4.jdbc.SybStatement.executeBatch(SybStatement.java:1691) at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1077) at org.jberet.repository.JdbcRepository.createTables(JdbcRepository.java:229) ... 10 more
- is cloned by
-
JBERET-170 Unsupported clause in DDL for JDBC batch repository for Sybase ASE
- Resolved
- relates to
-
WFLY-4933 Upgrade jberet-core to 1.2.0.Alpha2
- Closed