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

SQLSyntaxErrorException if names of tables are customized

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Critical Critical
    • None
    • 7.1.0.DR8, 7.1.0.DR9
    • ActiveMQ
    • None
    • Hide
      git clone git://git.app.eng.bos.redhat.com/jbossqe/eap-tests-hornetq.git
      cd eap-tests-hornetq/scripts/
      git checkout 7ca0b080e3db9bf387b9057279ba8a92fdfd2c25
      groovy -DEAP_VERSION=7.1.0.DR9 PrepareServers7.groovy
      export WORKSPACE=$PWD
      export JBOSS_HOME_1=$WORKSPACE/server1/jboss-eap
      export JBOSS_HOME_2=$WORKSPACE/server2/jboss-eap
      export JBOSS_HOME_3=$WORKSPACE/server3/jboss-eap
      export JBOSS_HOME_4=$WORKSPACE/server4/jboss-eap
      
      cd ../jboss-hornetq-testsuite/
      
      mvn clean test -Dtest=JDBCTestCase#customJDBCTableNames -DfailIfNoTests=false -Deap=7x -Deap7.org.jboss.qa.hornetq.apps.clients.version=7.1.0.DR9 | tee log
      
      Show
      git clone git: //git.app.eng.bos.redhat.com/jbossqe/eap-tests-hornetq.git cd eap-tests-hornetq/scripts/ git checkout 7ca0b080e3db9bf387b9057279ba8a92fdfd2c25 groovy -DEAP_VERSION=7.1.0.DR9 PrepareServers7.groovy export WORKSPACE=$PWD export JBOSS_HOME_1=$WORKSPACE/server1/jboss-eap export JBOSS_HOME_2=$WORKSPACE/server2/jboss-eap export JBOSS_HOME_3=$WORKSPACE/server3/jboss-eap export JBOSS_HOME_4=$WORKSPACE/server4/jboss-eap cd ../jboss-hornetq-testsuite/ mvn clean test -Dtest=JDBCTestCase#customJDBCTableNames -DfailIfNoTests= false -Deap=7x -Deap7.org.jboss.qa.hornetq.apps.clients.version=7.1.0.DR9 | tee log

      If names of database tables are customized [1], EAP throws an exception [2] during the initialization phase what causes that Artemis subsystem isn't started.

      [1]

      <journal file-size="10485760" min-files="10" compact-min-files="0" datasource="messaging" messages-table="node1-messages-table" bindings-table="node1-bindings-table" large-messages-table="node1-large-messages-table">
          <sql-provider-factory-class name="com.oracle.OracleSQLProviderFactory" module="test.sql-provider-factory"/>
      </journal>
      

      [2]

      13:13:09,782 ERROR [org.apache.activemq.artemis.core.server] (ServerService Thread Pool -- 70) AMQ224000: Failure in initialisation: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
      
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)
              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)
              at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
              at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactoryDriver.listFiles(JDBCSequentialFileFactoryDriver.java:80) [artemis-jdbc-store-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactory.listFiles(JDBCSequentialFileFactory.java:118) [artemis-jdbc-store-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.core.persistence.impl.journal.JournalStorageManager.cleanupIncompleteFiles(JournalStorageManager.java:187) [artemis-server-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.core.persistence.impl.journal.JournalStorageManager.beforeStart(JournalStorageManager.java:166) [artemis-server-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.core.persistence.impl.journal.AbstractJournalStorageManager.start(AbstractJournalStorageManager.java:1427) [artemis-server-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.initialisePart1(ActiveMQServerImpl.java:1956) [artemis-server-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation.run(LiveOnlyActivation.java:62) [artemis-server-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.start(ActiveMQServerImpl.java:465) [artemis-server-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.apache.activemq.artemis.jms.server.impl.JMSServerManagerImpl.start(JMSServerManagerImpl.java:409) [artemis-jms-server-1.5.0.redhat-1.jar:1.5.0.redhat-1]
              at org.wildfly.extension.messaging.activemq.jms.JMSService.doStart(JMSService.java:199) [wildfly-messaging-activemq-7.1.0.Alpha1-redhat-SNAPSHOT.jar:7.1.0.Alpha1-redhat-SNAPSHOT]
              at org.wildfly.extension.messaging.activemq.jms.JMSService.access$000(JMSService.java:63) [wildfly-messaging-activemq-7.1.0.Alpha1-redhat-SNAPSHOT.jar:7.1.0.Alpha1-redhat-SNAPSHOT]
              at org.wildfly.extension.messaging.activemq.jms.JMSService$1.run(JMSService.java:97) [wildfly-messaging-activemq-7.1.0.Alpha1-redhat-SNAPSHOT.jar:7.1.0.Alpha1-redhat-SNAPSHOT]
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [rt.jar:1.8.0_111]
              at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_111]
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_111]
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_111]
              at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
              at org.jboss.threads.JBossThread.run(JBossThread.java:320) [jboss-threads-2.2.1.Final-redhat-1.jar:2.2.1.Final-redhat-1]
      

              fnigro Francesco Nigro
              eduda_jira Erich Duda (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: