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

openxava | yerikab | 2 years ago
  1. 0

    Access Tracking MySQL 5.5 issue ?

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

    Reindex problem when admin portlets in Italian language

    GitHub | 2 years ago | linuxatico
    com.dotmarketing.exception.DotRuntimeException: Could not execute query
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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]
  6. 0

    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException, but it does exist?

    Stack Overflow | 3 years ago | Ccortina
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'patient0_.doctor_idStaffMember' in 'field list'

  1. Kialandei 1 times, last 2 weeks ago
  2. davidvanlaatum 8 times, last 2 months ago
  3. AndrewProg 2 times, last 3 months ago
  4. kuldeep 2 times, last 3 months ago
  5. tvrmsmith 1 times, last 4 months ago
27 more registered users
64 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