javax.jbi.messaging.MessagingException

Error occured while executing sql.select * from .mbmessage where monitored != 1ormonitoredis NULL

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web20

  • Error occured while executing sql.select * from .mbmessage where monitored != 1ormonitoredis NULL
  • via Oracle Community by 843830, 1 year ago
    Error occured while executing sql.select * from .mbmessage where monitored != 1ormonitoredis NULL
  • via Oracle Community by 843830, 1 year ago
    Error occured while executing sql.select * from TBD_HOUSE_INFO where FLAG != 1or FLAG is NULL
  • Stack trace

    • javax.jbi.messaging.MessagingException: Error occured while executing sql.select * from .mbmessage where monitored != 1ormonitoredis NULL at com.sun.jbi.jdbcbc.InboundMessageProcessor.executeInboundSQLSelect(InboundMessageProcessor.java:484) at com.sun.jbi.jdbcbc.InboundMessageProcessor.processInOnly(InboundMessageProcessor.java:388) at com.sun.jbi.jdbcbc.InboundMessageProcessor.execute(InboundMessageProcessor.java:308) at com.sun.jbi.jdbcbc.InboundMessageProcessor.run(InboundMessageProcessor.java:231) at java.lang.Thread.run(Thread.java:619) Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3256) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1448) at com.sun.jbi.jdbcbc.InboundMessageProcessor.executeInboundSQLSelect(InboundMessageProcessor.java:480) ... 4 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago