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 'order (BILLED_AMOUNT, BILLING_INFO_ADDR_LINE_1, BILLING_INFO_ADDR_LINE_2, BILLIN' at line 1

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 web1241

  • 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 'order (BILLED_AMOUNT, BILLING_INFO_ADDR_LINE_1, BILLING_INFO_ADDR_LINE_2, BILLIN' at line 1
  • 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 ''',,,'')' at line 1
  • via GitHub by liyongcun
    , 3 months ago
    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 '' at line 1
  • Stack trace

    • 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 'order (BILLED_AMOUNT, BILLING_INFO_ADDR_LINE_1, BILLING_INFO_ADDR_LINE_2, BILLIN' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.7.0_67] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)[na:1.7.0_67] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[na:1.7.0_67] at java.lang.reflect.Constructor.newInstance(Constructor.java:526)[na:1.7.0_67] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:382)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333)[mysql-connector-java-5.1.15-bin.jar:na] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318)[mysql-connector-java-5.1.15-bin.jar:na] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3032)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3558)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:98)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:490)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:195)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:179)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:214)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:324)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:288)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:194)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.jpa.event.internal.core.JpaPersistEventListener.saveWithGeneratedId(JpaPersistEventListener.java:84)[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:206)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:149)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:75)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:811)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:784)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:789)[hibernate-core-4.3.6.Final.jar:4.3.6.Final] at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1181)[hibernate-entitymanager-4.3.6.Final.jar:4.3.6.Final] at com.accenture.extremeex.dao.OrderDAO.salvar(OrderDAO.java:97)[classes/:na] at com.accenture.extremeex.dao.OrderDAO.main(OrderDAO.java:34)[classes/:na]

    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

    2 times, 1 month ago
    Once, 1 month ago
    Once, 1 month ago
    2 times, 2 months ago
    Once, 2 months ago
    117 more bugmates