com.mysql.jdbc.exceptions.jdbc4.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 'CONDIT ION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1

jboss.org | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    [jboss-user] [Datasource Configuration] - Cannot connect to mySql in Jboss 5 after changing from hsqldb to mysql

    jboss.org | 7 months ago
    com.mysql.jdbc.exceptions.jdbc4.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 'CONDIT ION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1
  2. 0

    Cannot conect to mySql DB after changing DB from HSQL to mySql in JBOSS 5

    Coderanch | 5 years ago | arturo nunez
    com.mysql.jdbc.exceptions.jdbc4.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 'CONDIT ION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1
  3. 0

    JBOSS 5.0.1.ga problem with mysql-ds and deploying service=Queue and service="PostOffice"

    Coderanch | 5 years ago | arturo nunez
    com.mysql.jdbc.exceptions.jdbc4.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 'CONDIT
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MySQL 5.1 with JBoss ESB 5.0.0 | JBoss Developer

    jboss.org | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.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 'CONDITION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1 " at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  6. 0

    MySQL 5.1 with JBoss ESB 5.0.0 | JBoss Developer

    jboss.org | 12 months ago
    com.mysql.jdbc.exceptions.jdbc4.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 'CONDITION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1 " at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.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 'CONDIT ION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    4 frames
  3. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    2. com.mysql.jdbc.Util.getInstance(Util.java:386)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2293)
    10 frames
  4. JBoss Application Server Connector
    WrappedPreparedStatement.executeQuery
    1. org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)
    1 frame
  5. org.jboss.messaging
    MessagingPostOfficeService.startService
    1. org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2487)
    2. org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2470)
    3. org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.execute(JDBCSupport.java:394)
    4. org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:416)
    5. org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2538)
    6. org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:353)
    7. org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:456)
    7 frames
  6. JBoss Application Server System
    ServiceMBeanSupport.start
    1. org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
    2. org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)
    2 frames
  7. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  8. org.jboss.mx
    ReflectedDispatcher.invoke
    1. org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
    1 frame
  9. JBoss Application Server J2SE
    Invocation.dispatch
    1. org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
    1 frame
  10. org.jboss.mx
    AbstractInterceptor.invoke
    1. org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)
    1 frame
  11. JBoss Application Server J2SE
    Invocation.invoke
    1. org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
    1 frame
  12. org.jboss.mx
    ModelMBeanOperationInterceptor.invoke
    1. org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)
    1 frame
  13. JBoss Application Server J2SE
    MBeanServerImpl.invoke
    1. org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
    2. org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    3. org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
    3 frames
  14. org.jboss.system
    ServiceProxy.invoke
    1. org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
    1 frame
  15. Unknown
    $Proxy36.start
    1. $Proxy36.start(Unknown Source)
    1 frame
  16. org.jboss.system
    StartStopLifecycleAction.installAction
    1. org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
    2. org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
    2 frames
  17. JBoss Microcontainer Dependency
    AbstractControllerContext.install
    1. org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
    2. org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
    3. org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
    4. org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
    4 frames
  18. org.jboss.system
    ServiceControllerContext.install
    1. org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
    1 frame
  19. JBoss Microcontainer Dependency
    AbstractController.change
    1. org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
    2. org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
    3. org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
    4. org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
    5. org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
    6. org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
    6 frames
  20. JBoss Application Server System
    ServiceDeployer.deploy
    1. org.jboss.system.ServiceController.doChange(ServiceController.java:688)
    2. org.jboss.system.ServiceController.start(ServiceController.java:460)
    3. org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
    4. org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
    5. org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
    5 frames
  21. JBoss Deployers SPI
    AbstractRealDeployer.deploy
    1. org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
    2. org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
    2 frames
  22. JBoss Deployers Impl
    DeployersImpl.install
    1. org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
    2. org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
    3. org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
    4. org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
    5. org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
    5 frames
  23. JBoss Microcontainer Dependency
    AbstractController.change
    1. org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
    2. org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1598)
    3. org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
    4. org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1062)
    5. org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
    6. org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
    7. org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
    7 frames
  24. JBoss Deployers Impl
    MainDeployerImpl.process
    1. org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
    2. org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:698)
    2 frames
  25. org.jboss.system
    ProfileServiceBootstrap.start
    1. org.jboss.system.server.profileservice.ProfileServiceBootstrap.loadProfile(ProfileServiceBootstrap.java:304)
    2. org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:205)
    2 frames
  26. org.jboss.bootstrap
    AbstractServerImpl.start
    1. org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:405)
    1 frame
  27. JBoss Application Server Server
    Main$1.run
    1. org.jboss.Main.boot(Main.java:209)
    2. org.jboss.Main$1.run(Main.java:547)
    2 frames
  28. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame