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#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...