SQL Server Error - Cannot load JDBC driver class

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

SQL Server Error - Cannot load JDBC driver class

ubaid
Following are my configurations for SQL server:
<persistenceAdapter>
             <jdbcPersistenceAdapter dataDirectory="${activemq.data}/sql"
dataSource="#mssql-ds"/></persistenceAdapter>

<bean id="mssql-ds" class="org.apache.commons.dbcp2.BasicDataSource"
destroy-method="close">
                <property name="driverClassName">
        <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
    </property>
    <property name="url">
       
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=activedb</value>
    </property>
    <property name="username">
        <value>sa</value>
    </property>
    <property name="password">
        <value>pass@word1</value>
    </property>
    <property name="poolPreparedStatements">
        <value>true</value>
    </property>
</bean>


I have placed the sqljdbc4-3.0.jar file in lib/optional folder, nothing else
I did than pasting this code and jar file in the specific folder, but I got
the folowing error:


 Could not get JDBC connection: Cannot load JDBC driver class
'com.microsoft.jdbc.sqlserver.SQLServerDriver'
jvm 1    | java.sql.SQLException: Cannot load JDBC driver class
'com.microsoft.jdbc.sqlserver.SQLServerDriver'
jvm 1    |      at
org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2139)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2033)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)[commons-dbcp2-2.1.1.jar:2.1.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.TransactionContext.lockAndWrapped(TransactionContext.java:70)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:63)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.loadAdapter(JDBCPersistenceAdapter.java:454)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(JDBCPersistenceAdapter.java:437)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(JDBCPersistenceAdapter.java:386)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:299)[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    |  INFO | No IOExceptionHandler registered, ignoring IO exception
jvm 1    | java.io.IOException: Cannot load JDBC driver class
'com.microsoft.jdbc.sqlserver.SQLServerDriver'
jvm 1    |      at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:46)[activemq-client-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.TransactionContext.lockAndWrapped(TransactionContext.java:88)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:63)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.loadAdapter(JDBCPersistenceAdapter.java:454)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(JDBCPersistenceAdapter.java:437)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(JDBCPersistenceAdapter.java:386)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:299)[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    | ERROR | Failed to start Apache ActiveMQ (localhost, null)
jvm 1    | java.io.IOException: Cannot load JDBC driver class
'com.microsoft.jdbc.sqlserver.SQLServerDriver'
jvm 1    |      at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:46)[activemq-client-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.TransactionContext.lockAndWrapped(TransactionContext.java:88)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:63)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.loadAdapter(JDBCPersistenceAdapter.java:454)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(JDBCPersistenceAdapter.java:437)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(JDBCPersistenceAdapter.java:386)[activemq-jdbc-store-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.init(JDBCPersistenceAdapter.java:299)[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    |  INFO | Apache ActiveMQ 5.15.1 (localhost, null) is shutting down
jvm 1    |  INFO | Connector openwire stopped
jvm 1    |  INFO | Connector amqp stopped
jvm 1    |  INFO | Connector stomp stopped
jvm 1    |  INFO | Connector mqtt stopped
jvm 1    |  INFO | Connector ws stopped
jvm 1    |  INFO |
PListStore:[C:\Users\ubaid.hassan\Desktop\apache-activemq-5.15.1\bin\win64\..\..\data\localhost\tmp_storage]
stopped
jvm 1    |  INFO | Apache ActiveMQ 5.15.1 (localhost, null) uptime 0.190
seconds
jvm 1    |  INFO | Apache ActiveMQ 5.15.1 (localhost, null) is shutdown
jvm 1    |  INFO | Closing
org.apache.activemq.xbean.XBeanBrokerFactory$1@3ca3667: startup date [Wed
Oct 18 13:30:11 PKT 2017]; root of context hierarchy
jvm 1    |  WARN | Exception thrown from LifecycleProcessor on context close
jvm 1    | java.lang.IllegalStateException: LifecycleProcessor not
initialized - call 'refresh' before invoking lifecycle methods via the
context: org.apache.activemq.xbean.XBeanBrokerFactory$1@3ca3667: startup
date [Wed Oct 18 13:30:11 PKT 2017]; root of context hierarchy
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.getLifecycleProcessor(AbstractApplicationContext.java:427)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:999)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:958)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
jvm 1    |      at
org.apache.activemq.hooks.SpringContextHook.run(SpringContextHook.java:30)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.stop(BrokerService.java:903)[activemq-broker-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerService.stop(XBeanBrokerService.java:122)[activemq-spring-5.15.1.jar:5.15.1]
jvm 1    |      at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:642)[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 | Exception encountered during context initialization -
cancelling refresh attempt:
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'org.apache.activemq.xbean.XBeanBrokerService#0' defined in class
path resource [activemq.xml]: Invocation of init method failed; nested
exception is java.io.IOException: Cannot load JDBC driver class
'com.microsoft.jdbc.sqlserver.SQLServerDriver'
jvm 1    | ERROR: java.lang.RuntimeException: Failed to execute start task.
Reason: java.lang.IllegalStateException: BeanFactory not initialized or
already closed - call 'refresh' before accessing beans via the
ApplicationContext
jvm 1    | java.lang.RuntimeException: Failed to execute start task. Reason:
java.lang.IllegalStateException: BeanFactory not initialized or already
closed - call 'refresh' before accessing beans via the ApplicationContext
jvm 1    |      at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:91)
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154)
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
jvm 1    |      at
org.apache.activemq.console.Main.runTaskClass(Main.java:262)
jvm 1    |      at org.apache.activemq.console.Main.main(Main.java:115)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
jvm 1    |      at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
jvm 1    |      at java.lang.Thread.run(Unknown Source)
jvm 1    | Caused by: java.lang.IllegalStateException: BeanFactory not
initialized or already closed - call 'refresh' before accessing beans via
the ApplicationContext
jvm 1    |      at
org.springframework.context.support.AbstractRefreshableApplicationContext.getBeanFactory(AbstractRefreshableApplicationContext.java:170)
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1030)
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:556)
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:64)
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:52)
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(XBeanBrokerFactory.java:104)
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:104)
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:67)
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71)
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54)
jvm 1    |      at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:87)
jvm 1    |      ... 16 more
jvm 1    | ERROR: java.lang.IllegalStateException: BeanFactory not
initialized or already closed - call 'refresh' before accessing beans via
the ApplicationContext
jvm 1    | java.lang.IllegalStateException: BeanFactory not initialized or
already closed - call 'refresh' before accessing beans via the
ApplicationContext
jvm 1    |      at
org.springframework.context.support.AbstractRefreshableApplicationContext.getBeanFactory(AbstractRefreshableApplicationContext.java:170)
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1030)
jvm 1    |      at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:556)
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:64)
jvm 1    |      at
org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(ResourceXmlApplicationContext.java:52)
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(XBeanBrokerFactory.java:104)
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:104)
jvm 1    |      at
org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:67)
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71)
jvm 1    |      at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54)
jvm 1    |      at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:87)
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154)
jvm 1    |      at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)
jvm 1    |      at
org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
jvm 1    |      at
org.apache.activemq.console.Main.runTaskClass(Main.java:262)
jvm 1    |      at org.apache.activemq.console.Main.main(Main.java:115)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
jvm 1    |      at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
jvm 1    |      at java.lang.Thread.run(Unknown Source)
wrapper  | <-- Wrapper Stopped




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

Reply | Threaded
Open this post in threaded view
|

Re: SQL Server Error - Cannot load JDBC driver class

Tim Bain
Does that JAR contain a class named
com.microsoft.jdbc.sqlserver.SQLServerDriver
as you specified in your config file? Or is it actually
com.microsoft.sqlserver.jdbc.SQLServerDriver?

Tim

On Oct 18, 2017 2:37 AM, "ubaid" <[hidden email]> wrote:

> Following are my configurations for SQL server:
> <persistenceAdapter>
>              <jdbcPersistenceAdapter dataDirectory="${activemq.data}/sql"
> dataSource="#mssql-ds"/></persistenceAdapter>
>
> <bean id="mssql-ds" class="org.apache.commons.dbcp2.BasicDataSource"
> destroy-method="close">
>                 <property name="driverClassName">
>         <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
>     </property>
>     <property name="url">
>
> <value>jdbc:microsoft:sqlserver://localhost:1433;
> DatabaseName=activedb</value>
>     </property>
>     <property name="username">
>         <value>sa</value>
>     </property>
>     <property name="password">
>         <value>pass@word1</value>
>     </property>
>     <property name="poolPreparedStatements">
>         <value>true</value>
>     </property>
> </bean>
>
>
> I have placed the sqljdbc4-3.0.jar file in lib/optional folder, nothing
> else
> I did than pasting this code and jar file in the specific folder, but I got
> the folowing error:
>
>
>  Could not get JDBC connection: Cannot load JDBC driver class
> 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
> jvm 1    | java.sql.SQLException: Cannot load JDBC driver class
> 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
> jvm 1    |      at
> org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(
> BasicDataSource.java:2139)[commons-dbcp2-2.1.1.jar:2.1.1]
> jvm 1    |      at
> org.apache.commons.dbcp2.BasicDataSource.createDataSource(
> BasicDataSource.java:2033)[commons-dbcp2-2.1.1.jar:2.1.1]
> jvm 1    |      at
> org.apache.commons.dbcp2.BasicDataSource.getConnection(
> BasicDataSource.java:1533)[commons-dbcp2-2.1.1.jar:2.1.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.TransactionContext.lockAndWrapped(
> TransactionContext.java:70)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.TransactionContext.getConnection(
> TransactionContext.java:63)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.loadAdapter(
> JDBCPersistenceAdapter.java:454)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(
> JDBCPersistenceAdapter.java:437)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(
> JDBCPersistenceAdapter.java:386)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.
> init(JDBCPersistenceAdapter.java:299)[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.AbstractAutowireCapableBeanFac
> tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac
> tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.invokeInitMethods(AbstractAutowireCapableBeanFac
> tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.initializeBean(AbstractAutowireCapableBeanFac
> tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.doCreateBean(AbstractAutowireCapableBeanFac
> tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.createBean(AbstractAutowireCapableBeanFac
> tory.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    |  INFO | No IOExceptionHandler registered, ignoring IO exception
> jvm 1    | java.io.IOException: Cannot load JDBC driver class
> 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
> jvm 1    |      at
> org.apache.activemq.util.IOExceptionSupport.create(
> IOExceptionSupport.java:46)[activemq-client-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.TransactionContext.lockAndWrapped(
> TransactionContext.java:88)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.TransactionContext.getConnection(
> TransactionContext.java:63)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.loadAdapter(
> JDBCPersistenceAdapter.java:454)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(
> JDBCPersistenceAdapter.java:437)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(
> JDBCPersistenceAdapter.java:386)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.
> init(JDBCPersistenceAdapter.java:299)[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.AbstractAutowireCapableBeanFac
> tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac
> tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.invokeInitMethods(AbstractAutowireCapableBeanFac
> tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.initializeBean(AbstractAutowireCapableBeanFac
> tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.doCreateBean(AbstractAutowireCapableBeanFac
> tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.createBean(AbstractAutowireCapableBeanFac
> tory.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    | ERROR | Failed to start Apache ActiveMQ (localhost, null)
> jvm 1    | java.io.IOException: Cannot load JDBC driver class
> 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
> jvm 1    |      at
> org.apache.activemq.util.IOExceptionSupport.create(
> IOExceptionSupport.java:46)[activemq-client-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.TransactionContext.lockAndWrapped(
> TransactionContext.java:88)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.TransactionContext.getConnection(
> TransactionContext.java:63)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.loadAdapter(
> JDBCPersistenceAdapter.java:454)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(
> JDBCPersistenceAdapter.java:437)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(
> JDBCPersistenceAdapter.java:386)[activemq-jdbc-store-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.
> init(JDBCPersistenceAdapter.java:299)[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.AbstractAutowireCapableBeanFac
> tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac
> tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.invokeInitMethods(AbstractAutowireCapableBeanFac
> tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.initializeBean(AbstractAutowireCapableBeanFac
> tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.doCreateBean(AbstractAutowireCapableBeanFac
> tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.createBean(AbstractAutowireCapableBeanFac
> tory.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    |  INFO | Apache ActiveMQ 5.15.1 (localhost, null) is shutting
> down
> jvm 1    |  INFO | Connector openwire stopped
> jvm 1    |  INFO | Connector amqp stopped
> jvm 1    |  INFO | Connector stomp stopped
> jvm 1    |  INFO | Connector mqtt stopped
> jvm 1    |  INFO | Connector ws stopped
> jvm 1    |  INFO |
> PListStore:[C:\Users\ubaid.hassan\Desktop\apache-
> activemq-5.15.1\bin\win64\..\..\data\localhost\tmp_storage]
> stopped
> jvm 1    |  INFO | Apache ActiveMQ 5.15.1 (localhost, null) uptime 0.190
> seconds
> jvm 1    |  INFO | Apache ActiveMQ 5.15.1 (localhost, null) is shutdown
> jvm 1    |  INFO | Closing
> org.apache.activemq.xbean.XBeanBrokerFactory$1@3ca3667: startup date [Wed
> Oct 18 13:30:11 PKT 2017]; root of context hierarchy
> jvm 1    |  WARN | Exception thrown from LifecycleProcessor on context
> close
> jvm 1    | java.lang.IllegalStateException: LifecycleProcessor not
> initialized - call 'refresh' before invoking lifecycle methods via the
> context: org.apache.activemq.xbean.XBeanBrokerFactory$1@3ca3667: startup
> date [Wed Oct 18 13:30:11 PKT 2017]; root of context hierarchy
> jvm 1    |      at
> org.springframework.context.support.AbstractApplicationContext.
> getLifecycleProcessor(AbstractApplicationContext.
> java:427)[spring-context-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.context.support.AbstractApplicationContext.doClose(
> AbstractApplicationContext.java:999)[spring-context-4.3.
> 9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.context.support.AbstractApplicationContext.close(
> AbstractApplicationContext.java:958)[spring-context-4.3.
> 9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.apache.activemq.hooks.SpringContextHook.run(
> SpringContextHook.java:30)[activemq-spring-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.broker.BrokerService.stop(BrokerService.java:903)[
> activemq-broker-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.xbean.XBeanBrokerService.stop(
> XBeanBrokerService.java:122)[activemq-spring-5.15.1.jar:5.15.1]
> jvm 1    |      at
> org.apache.activemq.broker.BrokerService.start(BrokerService.java:642)[
> 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.AbstractAutowireCapableBeanFac
> tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac
> tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.invokeInitMethods(AbstractAutowireCapableBeanFac
> tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.initializeBean(AbstractAutowireCapableBeanFac
> tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.doCreateBean(AbstractAutowireCapableBeanFac
> tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.createBean(AbstractAutowireCapableBeanFac
> tory.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 | Exception encountered during context initialization -
> cancelling refresh attempt:
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean
> with name 'org.apache.activemq.xbean.XBeanBrokerService#0' defined in
> class
> path resource [activemq.xml]: Invocation of init method failed; nested
> exception is java.io.IOException: Cannot load JDBC driver class
> 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
> jvm 1    | ERROR: java.lang.RuntimeException: Failed to execute start task.
> Reason: java.lang.IllegalStateException: BeanFactory not initialized or
> already closed - call 'refresh' before accessing beans via the
> ApplicationContext
> jvm 1    | java.lang.RuntimeException: Failed to execute start task.
> Reason:
> java.lang.IllegalStateException: BeanFactory not initialized or already
> closed - call 'refresh' before accessing beans via the ApplicationContext
> jvm 1    |      at
> org.apache.activemq.console.command.StartCommand.runTask(
> StartCommand.java:91)
> jvm 1    |      at
> org.apache.activemq.console.command.AbstractCommand.
> execute(AbstractCommand.java:63)
> jvm 1    |      at
> org.apache.activemq.console.command.ShellCommand.runTask(
> ShellCommand.java:154)
> jvm 1    |      at
> org.apache.activemq.console.command.AbstractCommand.
> execute(AbstractCommand.java:63)
> jvm 1    |      at
> org.apache.activemq.console.command.ShellCommand.main(
> ShellCommand.java:104)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
> jvm 1    |      at
> org.apache.activemq.console.Main.runTaskClass(Main.java:262)
> jvm 1    |      at org.apache.activemq.console.Main.main(Main.java:115)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
> jvm 1    |      at
> org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
> jvm 1    |      at java.lang.Thread.run(Unknown Source)
> jvm 1    | Caused by: java.lang.IllegalStateException: BeanFactory not
> initialized or already closed - call 'refresh' before accessing beans via
> the ApplicationContext
> jvm 1    |      at
> org.springframework.context.support.AbstractRefreshableApplication
> Context.getBeanFactory(AbstractRefreshableApplicationContext.java:170)
> jvm 1    |      at
> org.springframework.context.support.AbstractApplicationContext.
> destroyBeans(AbstractApplicationContext.java:1030)
> jvm 1    |      at
> org.springframework.context.support.AbstractApplicationContext.refresh(
> AbstractApplicationContext.java:556)
> jvm 1    |      at
> org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(
> ResourceXmlApplicationContext.java:64)
> jvm 1    |      at
> org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(
> ResourceXmlApplicationContext.java:52)
> jvm 1    |      at
> org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(
> XBeanBrokerFactory.java:104)
> jvm 1    |      at
> org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(
> XBeanBrokerFactory.java:104)
> jvm 1    |      at
> org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(
> XBeanBrokerFactory.java:67)
> jvm 1    |      at
> org.apache.activemq.broker.BrokerFactory.createBroker(
> BrokerFactory.java:71)
> jvm 1    |      at
> org.apache.activemq.broker.BrokerFactory.createBroker(
> BrokerFactory.java:54)
> jvm 1    |      at
> org.apache.activemq.console.command.StartCommand.runTask(
> StartCommand.java:87)
> jvm 1    |      ... 16 more
> jvm 1    | ERROR: java.lang.IllegalStateException: BeanFactory not
> initialized or already closed - call 'refresh' before accessing beans via
> the ApplicationContext
> jvm 1    | java.lang.IllegalStateException: BeanFactory not initialized or
> already closed - call 'refresh' before accessing beans via the
> ApplicationContext
> jvm 1    |      at
> org.springframework.context.support.AbstractRefreshableApplication
> Context.getBeanFactory(AbstractRefreshableApplicationContext.java:170)
> jvm 1    |      at
> org.springframework.context.support.AbstractApplicationContext.
> destroyBeans(AbstractApplicationContext.java:1030)
> jvm 1    |      at
> org.springframework.context.support.AbstractApplicationContext.refresh(
> AbstractApplicationContext.java:556)
> jvm 1    |      at
> org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(
> ResourceXmlApplicationContext.java:64)
> jvm 1    |      at
> org.apache.xbean.spring.context.ResourceXmlApplicationContext.<init>(
> ResourceXmlApplicationContext.java:52)
> jvm 1    |      at
> org.apache.activemq.xbean.XBeanBrokerFactory$1.<init>(
> XBeanBrokerFactory.java:104)
> jvm 1    |      at
> org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(
> XBeanBrokerFactory.java:104)
> jvm 1    |      at
> org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(
> XBeanBrokerFactory.java:67)
> jvm 1    |      at
> org.apache.activemq.broker.BrokerFactory.createBroker(
> BrokerFactory.java:71)
> jvm 1    |      at
> org.apache.activemq.broker.BrokerFactory.createBroker(
> BrokerFactory.java:54)
> jvm 1    |      at
> org.apache.activemq.console.command.StartCommand.runTask(
> StartCommand.java:87)
> jvm 1    |      at
> org.apache.activemq.console.command.AbstractCommand.
> execute(AbstractCommand.java:63)
> jvm 1    |      at
> org.apache.activemq.console.command.ShellCommand.runTask(
> ShellCommand.java:154)
> jvm 1    |      at
> org.apache.activemq.console.command.AbstractCommand.
> execute(AbstractCommand.java:63)
> jvm 1    |      at
> org.apache.activemq.console.command.ShellCommand.main(
> ShellCommand.java:104)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
> jvm 1    |      at
> org.apache.activemq.console.Main.runTaskClass(Main.java:262)
> jvm 1    |      at org.apache.activemq.console.Main.main(Main.java:115)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> jvm 1    |      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> jvm 1    |      at java.lang.reflect.Method.invoke(Unknown Source)
> jvm 1    |      at
> org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240)
> jvm 1    |      at java.lang.Thread.run(Unknown Source)
> wrapper  | <-- Wrapper Stopped
>
>
>
>
> --
> Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-
> f2341805.html
>
>
Reply | Threaded
Open this post in threaded view
|

Re: SQL Server Error - Cannot load JDBC driver class

ubaid
that was hell of an answer
Thank you so much.



--
Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-f2341805.html
Reply | Threaded
Open this post in threaded view
|

Re: SQL Server Error - Cannot load JDBC driver class

ubaid
In reply to this post by Tim Bain
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
Reply | Threaded
Open this post in threaded view
|

Re: SQL Server Error - Cannot load JDBC driver class

Tim Bain
In reply to this post by ubaid
The StackOverflow post I got it from indicated that Microsoft may have
changed their package structure at some point, so the correct package may
be tied to which version of the JAR you use. But I don't have any more info
than that.

On Oct 18, 2017 6:32 AM, "ubaid" <[hidden email]> wrote:

> that was hell of an answer
> Thank you so much.
>
>
>
> --
> Sent from: http://activemq.2283324.n4.nabble.com/ActiveMQ-User-
> f2341805.html
>
Reply | Threaded
Open this post in threaded view
|

Re: SQL Server Error - Cannot load JDBC driver class

Tim Bain
In reply to this post by ubaid
From the logs, it looks like it's failing to drop the primary key and then
failing to create it (because it failed to drop it). For now let's assume
that we're ending up in a good place (the table exists, the index exists),
though we may have to reexamine that assumption if we find evidence of
problems that call it into question.

To know whether you're dequeuing messages, you can attach a JMX viewer such
as JConsole and look through the MBeans to find the one for your queue.
There will be attributes about enqueue and dequeue counts which should make
it clear which of the two possibilities you mentioned is actually
occurring.

Tim

On Oct 18, 2017 7:21 AM, "ubaid" <[hidden email]> wrote:

> 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.AbstractAutowireCapableBeanFac
> tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac
> tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.invokeInitMethods(AbstractAutowireCapableBeanFac
> tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.initializeBean(AbstractAutowireCapableBeanFac
> tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.doCreateBean(AbstractAutowireCapableBeanFac
> tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.createBean(AbstractAutowireCapableBeanFac
> tory.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.AbstractAutowireCapableBeanFac
> tory.invokeCustomInitMethod(AbstractAutowireCapableBeanFac
> tory.java:1758)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.invokeInitMethods(AbstractAutowireCapableBeanFac
> tory.java:1695)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.initializeBean(AbstractAutowireCapableBeanFac
> tory.java:1624)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.doCreateBean(AbstractAutowireCapableBeanFac
> tory.java:555)[spring-beans-4.3.9.RELEASE.jar:4.3.9.RELEASE]
> jvm 1    |      at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFac
> tory.createBean(AbstractAutowireCapableBeanFac
> tory.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
>
Reply | Threaded
Open this post in threaded view
|

Re: SQL Server Error - Cannot load JDBC driver class

ubaid
This post was updated on .
I have solved the issue over here, you can find the solution over  here.
The reason the messages are not storing in the database is that one of the
header property of message *Persistence* is by default set to the value *Non
Persistent*. You just have to set it to *Persistent* and the messages will
be stored in the queue as well as in your configured database.

Thanks Tim for your help, that was helpful.



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