Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Other Programming (https://www.askmehelpdesk.com/forumdisplay.php?f=437)
-   -   Whenever I'm trying to execute a simple hibernate example I'm getting this error.. (https://www.askmehelpdesk.com/showthread.php?t=814382)

  • Jul 22, 2015, 03:53 AM
    DVNRaju
    Whenever I'm trying to execute a simple hibernate example I'm getting this error..
    the error is
    Exception in thread "main" org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.exception.internal.SQLExceptionTypeD elegate.convert(SQLExceptionTypeDelegate.java:80)
    at org.hibernate.exception.internal.StandardSQLExcept ionConverter.convert(StandardSQLExceptionConverter .java:49)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.c onvert(SqlExceptionHelper.java:126)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.c onvert(SqlExceptionHelper.java:112)
    at org.hibernate.engine.jdbc.internal.ResultSetReturn Impl.executeUpdate(ResultSetReturnImpl.java:211)
    at org.hibernate.engine.jdbc.batch.internal.NonBatchi ngBatch.addToBatch(NonBatchingBatch.java:62)
    at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:3124)
    at org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:3581)
    at org.hibernate.action.internal.EntityInsertAction.e xecute(EntityInsertAction.java:104)
    at org.hibernate.engine.spi.ActionQueue.executeAction s(ActionQueue.java:463)
    at org.hibernate.engine.spi.ActionQueue.executeAction s(ActionQueue.java:349)
    at org.hibernate.event.internal.AbstractFlushingEvent Listener.performExecutions(AbstractFlushingEventLi stener.java:350)
    at org.hibernate.event.internal.DefaultFlushEventList ener.onFlush(DefaultFlushEventListener.java:56)
    at org.hibernate.internal.SessionImpl.flush(SessionIm pl.java:1222)
    at org.hibernate.internal.SessionImpl.managedFlush(Se ssionImpl.java:425)
    at org.hibernate.engine.transaction.internal.jdbc.Jdb cTransaction.beforeTransactionCommit(JdbcTransacti on.java:101)
    at org.hibernate.engine.transaction.spi.AbstractTrans actionImpl.commit(AbstractTransactionImpl.java:177 )
    at main.java.EmplDaoImpl.addEmployee(EmplDaoImpl.java :32)
    at main.java.EmplTest.main(EmplTest.java:12)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: 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 'group, name, id) values ('it', 'dvn', 121)' at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Construc tor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:40 6)
    at com.mysql.jdbc.Util.getInstance(Util.java:381)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1030)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:956)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3491)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3423)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 36)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2060)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2542)
    at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1734)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2019)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1937)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1922)
    at org.hibernate.engine.jdbc.internal.ResultSetReturn Impl.executeUpdate(ResultSetReturnImpl.java:208)
    ... 14 more

  • All times are GMT -7. The time now is 11:04 AM.