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
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to