org.hibernate.exception.SQLGrammarException: could not retrieve generated id after insert: [org.openxava.tracking.model.Access]

openxava | yerikab | 3 years 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

    Access Tracking MySQL 5.5 issue ?

    openxava | 3 years ago | yerikab
    org.hibernate.exception.SQLGrammarException: could not retrieve generated id after insert: [org.openxava.tracking.model.Access]
  2. 0

    dotCMS Users Group - DotCMS isnt starting: Whats wrong?

    dotcms.com | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dotcms2.qrtz_triggers' doesn't exist
  3. 0

    Reindex problem when admin portlets in Italian language

    GitHub | 3 years ago | linuxatico
    com.dotmarketing.exception.DotRuntimeException: Could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't save category permissions with Mysql and Lower case table Off

    GitHub | 4 years ago | mabouza
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dotcms22.Inode' doesn't exist
  6. 0

    Make dotCMS Support MySQL 5.6

    GitHub | 4 years ago | cfalzone
    org.quartz.JobPersistenceException: Couldn't acquire next trigger: 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 'OPTION SQL_SELECT_LIMIT=1' at line 1 [See nested exception: 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 'OPTION SQL_SELECT_LIMIT=1' at line 1]

  1. osvzs 1 times, last 1 month ago
  2. Kialandei 1 times, last 5 months ago
  3. davidvanlaatum 8 times, last 7 months ago
  4. AndrewProg 2 times, last 7 months ago
  5. kuldeep 2 times, last 7 months ago
26 more registered users
69 unregistered visitors
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

    PROCEDURE DVCEWEB.identity does not exist

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    4. java.lang.reflect.Constructor.newInstance(Unknown Source)
    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:1053)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2318)
    10 frames
  4. org.apache.tomcat
    DelegatingPreparedStatement.executeQuery
    1. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    1 frame
  5. Hibernate
    AbstractEntityPersister.insert
    1. org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:78)
    2. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2346)
    3. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2853)
    3 frames
  6. Hibernate
    EntityIdentityInsertAction.execute
    1. org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
    1 frame
  7. Hibernate
    ActionQueue.execute
    1. org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
    1 frame
  8. Hibernate
    SessionImpl.save
    1. org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:320)
    2. org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
    3. org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
    4. org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
    5. org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
    6. org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
    7. org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
    8. org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
    9. org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
    10. org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
    11. org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
    11 frames
  9. org.openxava.tracking
    AccessTrackingListener.trackReadAccess
    1. org.openxava.tracking.AccessTrackingCalculator.calculate(AccessTrackingCalculator.java:45)
    2. org.openxava.tracking.AccessTrackingListener.trackAccess(AccessTrackingListener.java:43)
    3. org.openxava.tracking.AccessTrackingListener.trackReadAccess(AccessTrackingListener.java:25)
    3 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  11. Hibernate EJB
    EJB3PostLoadEventListener.onPostLoad
    1. org.hibernate.ejb.event.ListenerCallback.invoke(ListenerCallback.java:45)
    2. org.hibernate.ejb.event.EntityCallbackHandler.callback(EntityCallbackHandler.java:94)
    3. org.hibernate.ejb.event.EntityCallbackHandler.postLoad(EntityCallbackHandler.java:87)
    4. org.hibernate.ejb.event.EJB3PostLoadEventListener.onPostLoad(EJB3PostLoadEventListener.java:47)
    4 frames
  12. Hibernate
    AbstractEntityPersister.load
    1. org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:250)
    2. org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:982)
    3. org.hibernate.loader.Loader.doQuery(Loader.java:857)
    4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
    5. org.hibernate.loader.Loader.loadEntity(Loader.java:2037)
    6. org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
    7. org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
    8. org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3294)
    8 frames
  13. Hibernate
    SessionImpl.get
    1. org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
    2. org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
    3. org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
    4. org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
    5. org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
    6. org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1090)
    7. org.hibernate.impl.SessionImpl.get(SessionImpl.java:1005)
    8. org.hibernate.impl.SessionImpl.get(SessionImpl.java:998)
    8 frames
  14. Hibernate EJB
    AbstractEntityManagerImpl.find
    1. org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:781)
    2. org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:756)
    2 frames
  15. org.openxava.jpa
    EntityManagerDecorator.find
    1. org.openxava.jpa.impl.EntityManagerDecorator.find(EntityManagerDecorator.java:147)
    1 frame
  16. org.openxava.model
    MapFacade.getValues
    1. org.openxava.model.impl.JPAPersistenceProvider.find(JPAPersistenceProvider.java:28)
    2. org.openxava.model.impl.POJOPersistenceProviderBase.find(POJOPersistenceProviderBase.java:92)
    3. org.openxava.model.impl.POJOPersistenceProviderBase.find(POJOPersistenceProviderBase.java:63)
    4. org.openxava.model.impl.MapFacadeBean.findEntity(MapFacadeBean.java:1484)
    5. org.openxava.model.impl.MapFacadeBean.findEntity(MapFacadeBean.java:1617)
    6. org.openxava.model.impl.MapFacadeBean.getValuesImpl(MapFacadeBean.java:636)
    7. org.openxava.model.impl.MapFacadeBean.getValues(MapFacadeBean.java:99)
    8. org.openxava.model.MapFacade.getValues(MapFacade.java:397)
    8 frames
  17. org.openxava.actions
    SearchByViewKeyAction.execute
    1. org.openxava.actions.SearchByViewKeyAction.execute(SearchByViewKeyAction.java:56)
    1 frame
  18. org.openxava.controller
    ModuleManager.execute
    1. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:444)
    2. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:363)
    3. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:557)
    4. org.openxava.controller.ModuleManager.executeAction(ModuleManager.java:363)
    5. org.openxava.controller.ModuleManager.execute(ModuleManager.java:323)
    5 frames
  19. org.apache.jsp
    execute_jsp._jspService
    1. org.apache.jsp.xava.execute_jsp._jspService(execute_jsp.java:192)
    1 frame
  20. GWT dev
    HttpJspBase.service
    1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    1 frame
  21. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    1 frame
  22. GWT dev
    JspServlet.service
    1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    3 frames
  23. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    1 frame
  24. Glassfish Core
    ApplicationDispatcher.include
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
    4. org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
    5. org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
    5 frames
  25. org.openxava.web
    Module.request
    1. org.openxava.web.servlets.Servlets.getURIAsStream(Servlets.java:66)
    2. org.openxava.web.dwr.Module.getURIAsStream(Module.java:203)
    3. org.openxava.web.dwr.Module.request(Module.java:62)
    3 frames
  26. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  27. Direct Web Remoting
    DwrServlet.doPost
    1. org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34)
    2. org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428)
    3. org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431)
    4. org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283)
    5. org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52)
    6. org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101)
    7. org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146)
    7 frames
  28. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    2 frames
  29. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    2 frames
  30. com.openxava.naviox
    NaviOXFilter.doFilter
    1. com.openxava.naviox.web.NaviOXFilter.doFilter(NaviOXFilter.java:45)
    1 frame
  31. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
    8 frames
  32. Grizzly HTTP
    AprEndpoint$Worker.run
    1. org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
    2. org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:574)
    3. org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1527)
    3 frames
  33. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame