activemq-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ubaid <ubaid.has...@aajtech.com>
Subject Re: SQL Server Error - Cannot load JDBC driver class
Date Wed, 18 Oct 2017 13:21:16 GMT
Tim,
Can you help me a little bit more:
With the same configuration and with the change you told me earlier the
connection has been made, the tables are created but I still got an error as
follow:

Could not create JDBC tables; they could already exist. Failure was: ALTER
TABLE ACTIVEMQ_ACKS DROP PRIMARY KEY Message: Incorrect syntax near the
keyword 'PRIMARY'. SQLState: S0001 Vendor code: 156
jvm 1    |  WARN | Failure details: Incorrect syntax near the keyword
'PRIMARY'.
jvm 1    | com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax
near the keyword 'PRIMARY'.
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751)[sqljdbc42.jar:]
jvm 1    |      at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.executeStatement(DefaultJDBCAdapter.java:114)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables(DefaultJDBCAdapter.java:92)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:307)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.LockableServiceSupport.preStart(LockableServiceSupport.java:89)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54)[activemq-client-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter(BrokerService.java:687)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.startPersistenceAdapter(BrokerService.java:671)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:635)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:73)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)[:1.8.0_144]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:64)[xbean-spring-4.2.jar:4.2]
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:52)[xbean-spring-4.2.jar:4.2]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:67)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:87)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)[:1.8.0_144]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at
org.apache.activemq.console.Main.runTaskClass(Main.java:262)[activemq.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.Main.main(Main.java:115)[activemq.jar:5.15.1]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)[:1.8.0_144]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)[wrapper.jar:3.2.3]
jvm 1    |      at java.lang.Thread.run(Unknown Source)[:1.8.0_144]
jvm 1    |  WARN | Could not create JDBC tables; they could already exist.
Failure was: ALTER TABLE ACTIVEMQ_ACKS ADD PRIMARY KEY (CONTAINER,
CLIENT_ID, SUB_NAME, PRIORITY) Message: Table 'ACTIVEMQ_ACKS' already has a
primary key defined on it. SQLState: S0000 Vendor code: 1779
jvm 1    |  WARN | Failure details: Table 'ACTIVEMQ_ACKS' already has a
primary key defined on it.
jvm 1    | com.microsoft.sqlserver.jdbc.SQLServerException: Table
'ACTIVEMQ_ACKS' already has a primary key defined on it.
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:885)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:778)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)[sqljdbc42.jar:]
jvm 1    |      at
com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:751)[sqljdbc42.jar:]
jvm 1    |      at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.executeStatement(DefaultJDBCAdapter.java:114)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doCreateTables(DefaultJDBCAdapter.java:92)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:307)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.LockableServiceSupport.preStart(LockableServiceSupport.java:89)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.util.ServiceSupport.start(ServiceSupport.java:54)[activemq-client-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.doStartPersistenceAdapter(BrokerService.java:687)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.startPersistenceAdapter(BrokerService.java:671)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:635)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:73)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)[:1.8.0_144]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:64)[xbean-spring-4.2.jar:4.2]
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:52)[xbean-spring-4.2.jar:4.2]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:104)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:67)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:87)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104)[activemq-console-5.15.1.jar:5.15.1]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)[:1.8.0_144]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at
org.apache.activemq.console.Main.runTaskClass(Main.java:262)[activemq.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.console.Main.main(Main.java:115)[activemq.jar:5.15.1]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)[:1.8.0_144]
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown
Source)[:1.8.0_144]
jvm 1    |      at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)[wrapper.jar:3.2.3]
jvm 1    |      at java.lang.Thread.run(Unknown Source)[:1.8.0_144]



but it still creates the table, my main concern over here is that my
messages are queued in ActiveMQ but there is nothing in the rows of
database, all three of the tables are empty either my queue is not empty or
all of the messages are dequeued.

Thanks Tim



--
Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html

Mime
View raw message