[jboss-user] [JBoss Messaging] - Unknown column 'NODE_ID' in 'where clause'
nvijsan
do-not-reply at jboss.com
Wed Apr 15 14:10:13 EDT 2009
Hi,
I am trying to use jboss-messaging-1.4.2.GA-SP1 in jboss-4.2.1.GA and am stuck with this issue -
| 2009-04-15 10:46:18,238 (main) ERROR [org.jboss.messaging.util.ExceptionUtil] ServerPeer[0] startService
| com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'NODE_ID' in 'where clause'
| at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:3176)
| at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153)
| at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266)
| at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
| at org.jboss.messaging.core.impl.JDBCPersistenceManager.retrievePreparedTransactions(JDBCPersistenceManager.java:336)
| at org.jboss.messaging.core.impl.tx.TransactionRepository.loadPreparedTransactions(TransactionRepository.java:176)
| at org.jboss.jms.server.ServerPeer.startService(ServerPeer.java:330)
| at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
| at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
|
The database has been recreated to check whether the issue gets resolved, but that hasn't helped. Has anyone encountered this issue? Any thoughts on how this can be overcome?
Thanks,
Naga Vijayapuram
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4225715#4225715
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4225715
More information about the jboss-user
mailing list