Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-179

Unsupported clause in DDL for JDBC batch repository for Sybase ASE

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 7.0.0.DR8
    • 7.0.0.DR2
    • Batch
    • None

      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
      

            cfang@redhat.com Cheng Fang
            jmartisk@redhat.com Jan Martiska
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: