activemq mysql 报错,activemq和mysql 使用JDBC来配置持久化消息报错

最新推荐文章于 2024-03-26 08:39:58 发布

成都AG超玩会老帅

最新推荐文章于 2024-03-26 08:39:58 发布

阅读量349

点赞数

文章标签： activemq mysql 报错

activemq.xml 配置信息：

xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans [url]http://www.springframework.org/schema/beans/spring-beans.xsd[/url]

[url]http://activemq.apache.org/schema/core[/url] [url]http://activemq.apache.org/schema/core/activemq-core.xsd[/url]">

file:${activemq.conf}/credentials.properties

lazy-init="false" scope="singleton"

init-method="start" destroy-method="stop">

transactionIsolation="4"/>

com.mysql.jdbc.Driver

jdbc:mysql://192.168.1.104:3306/activemq?useUnicode=true&characterEncoding=UTF-8

goods

错误信息：

2017-07-01 18:08:53,194 | INFO | Refreshing org.apache.activemq.xbean.XBeanBrokerFactory$1@773e467: startup date [Sat Jul 01 18:08:53 CST 2017]; root of context hierarchy | org.apache.activemq.xbean.XBeanBrokerFactory$1 | main

2017-07-01 18:08:55,033 | WARN | Failed to get host name: java.net.UnknownHostException: linux: linux: Name or service not known | io.fabric8.insight.log.support.LogQuerySupport | main

java.net.UnknownHostException: linux: linux: Name or service not known

at java.net.InetAddress.getLocalHost(InetAddress.java:1473)[:1.7.0_71]

at io.fabric8.insight.log.support.LogQuerySupport.(LogQuerySupport.java:55)[insight-log-core-1.2.0.Beta4.jar:1.2.0.Beta4]

at io.fabric8.insight.log.log4j.Log4jLogQuery.(Log4jLogQuery.java:72)[insight-log4j-1.2.0.Beta4.jar:1.2.0.Beta4]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.7.0_71]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[:1.7.0_71]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.7.0_71]

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)[:1.7.0_71]

at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:147)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:89)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1092)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1044)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)[spring-beans-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:762)[spring-context-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)[spring-context-4.1.9.RELEASE.jar:4.1.9.RELEASE]

at org.apache.xbean.spring.context.ResourceXmlApplicationContext.(ResourceXmlApplicationContext.java:64)[xbean-spring-4.2.jar:4.2]

at org.apache.xbean.spring.context.ResourceXmlApplicationContext.(ResourceXmlApplicationContext.java:52)[xbean-spring-4.2.jar:4.2]

at org.apache.activemq.xbean.XBeanBrokerFactory$1.(XBeanBrokerFactory.java:104)[activemq-spring-5.14.4.jar:5.14.4]

at org.apache.activemq.xbean.XBeanBrokerFactory.createApplicationContext(XBeanBrokerFactory.java:104)[activemq-spring-5.14.4.jar:5.14.4]

at org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:67)[activemq-spring-5.14.4.jar:5.14.4]

at org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:71)[activemq-broker-5.14.4.jar:5.14.4]

at org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:54)[activemq-broker-5.14.4.jar:5.14.4]

at org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:87)[activemq-console-5.14.4.jar:5.14.4]

at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)[activemq-console-5.14.4.jar:5.14.4]

at org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:154)[activemq-console-5.14.4.jar:5.14.4]

at org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:63)[activemq-console-5.14.4.jar:5.14.4]

at org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:104)[activemq-console-5.14.4.jar:5.14.4]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[:1.7.0_71]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[:1.7.0_71]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[:1.7.0_71]

at java.lang.reflect.Method.invoke(Method.java:606)[:1.7.0_71]

at org.apache.activemq.console.Main.runTaskClass(Main.java:262)[activemq.jar:5.14.4]

at org.apache.activemq.console.Main.main(Main.java:115)[activemq.jar:5.14.4]

2017-07-01 18:09:00,243 | INFO | Using Persistence Adapter: JDBCPersistenceAdapter(org.apache.commons.dbcp.BasicDataSource@46c807db) | org.apache.activemq.broker.BrokerService | main

2017-07-01 18:09:00,416 | INFO | Database adapter driver override recognized for : [mysql-ab_jdbc_driver] - adapter: class org.apache.activemq.store.jdbc.adapter.MySqlJDBCAdapter | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main

2017-07-01 18:09:00,418 | INFO | Database lock driver override not found for : [mysql-ab_jdbc_driver]. Will use default implementation. | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main

2017-07-01 18:09:00,420 | INFO | Attempting to acquire the exclusive lock to become the Master broker | org.apache.activemq.store.jdbc.DefaultDatabaseLocker | main

2017-07-01 18:09:00,429 | INFO | Becoming the master on dataSource: org.apache.commons.dbcp.BasicDataSource@46c807db | org.apache.activemq.store.jdbc.DefaultDatabaseLocker | main

2017-07-01 18:09:00,433 | INFO | PListStore:[/usr/common/activemq-5.14.4/data/localhost/tmp_storage] started | org.apache.activemq.store.kahadb.plist.PListStoreImpl | main

2017-07-01 18:09:00,474 | WARN | Old message cleanup failed due to: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'PRIORITY' in 'where clause' | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | ActiveMQ JDBC PA Scheduled Task

2017-07-01 18:09:00,476 | WARN | Failure Details: Unknown column 'PRIORITY' in 'where clause' | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | ActiveMQ JDBC PA Scheduled Task

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'PRIORITY' in 'where clause'

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.7.0_71]

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[:1.7.0_71]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.7.0_71]

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)[:1.7.0_71]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.Util.getInstance(Util.java:381)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2643)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)[mysql-connector-java-5.1.9.jar:]

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)[mysql-connector-java-5.1.9.jar:]

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)[commons-dbcp-1.4.jar:1.4]

at org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doDeleteOldMessages(DefaultJDBCAdapter.java:832)[activemq-jdbc-store-5.14.4.jar:5.14.4]

at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.cleanup(JDBCPersistenceAdapter.java:349)[activemq-jdbc-store-5.14.4.jar:5.14.4]

at org.apache.activemq.store.jdbc.JDBCPersistenceAdapter$3.run(JDBCPersistenceAdapter.java:327)[activemq-jdbc-store-5.14.4.jar:5.14.4]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)[:1.7.0_71]

at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)[:1.7.0_71]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)[:1.7.0_71]

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)[:1.7.0_71]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[:1.7.0_71]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[:1.7.0_71]

at java.lang.Thread.run(Thread.java:745)[:1.7.0_71]

2017-07-01 18:09:00,852 | INFO | Apache ActiveMQ 5.14.4 (localhost, ID:linux-48837-1498903740722-0:1) is starting | org.apache.activemq.broker.BrokerService | main

2017-07-01 18:09:00,868 | WARN | JDBC Failure: Unknown column 'XID' in 'field list' | org.apache.activemq.store.jdbc.JDBCPersistenceAdapter | main

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'XID' in 'field list'