org.hibernate.exception.GenericJDBCException: could not execute query

Google Groups | Michel van der Kleij | 2 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

    Bug Report: Java heap space out-of-memory when opening a table

    Google Groups | 2 years ago | Michel van der Kleij
    org.hibernate.exception.GenericJDBCException: could not execute query
  2. 0

    Erro ao acessar lista-contatos-elegante FJ-21 (exemplo da apostila) [RESOLVIDO] - Front-end - GUJ

    com.br | 8 months ago
    java.lang.RuntimeException: java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date
  3. 0

    MySQL Bugs: #69788: Some ResultSet methods don't throw the proper exception when on an invalid row

    mysql.com | 5 months ago
    java.sql.SQLException: Before start of result set
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    MySQL Bugs: #69788: Some ResultSet methods don't throw the proper exception when on an invalid row

    mysql.com | 5 months ago
    java.sql.SQLException: Before start of result set

Root Cause Analysis

  1. java.sql.SQLException

    Value '0000-00-00' can not be represented as java.sql.Date

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    ResultSetImpl.getDate
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)[mysql-connector-java-5.1.32.jar:na]
    2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:997)[mysql-connector-java-5.1.32.jar:na]
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:983)[mysql-connector-java-5.1.32.jar:na]
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:928)[mysql-connector-java-5.1.32.jar:na]
    5. com.mysql.jdbc.ResultSetRow.getDateFast(ResultSetRow.java:141)[mysql-connector-java-5.1.32.jar:na]
    6. com.mysql.jdbc.ByteArrayRow.getDateFast(ByteArrayRow.java:238)[mysql-connector-java-5.1.32.jar:na]
    7. com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2206)[mysql-connector-java-5.1.32.jar:na]
    8. com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2168)[mysql-connector-java-5.1.32.jar:na]
    9. com.mysql.jdbc.ResultSetImpl.getDate(ResultSetImpl.java:2233)[mysql-connector-java-5.1.32.jar:na]
    9 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyResultSet.getDate
    1. com.mchange.v2.c3p0.impl.NewProxyResultSet.getDate(NewProxyResultSet.java:3212)[c3p0-0.9.1.1.jar:0.9.1.1]
    1 frame
  4. Hibernate
    QueryImpl.list
    1. org.hibernate.type.descriptor.sql.DateTypeDescriptor$2.doExtract(DateTypeDescriptor.java:75)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    2. org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    3. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:267)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    4. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:263)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    5. org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    6. org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:338)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    7. org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2969)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    8. org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1696)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    9. org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1628)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    10. org.hibernate.loader.Loader.getRow(Loader.java:1515)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    11. org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:726)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    12. org.hibernate.loader.Loader.processResultSet(Loader.java:953)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    13. org.hibernate.loader.Loader.doQuery(Loader.java:921)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    14. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    15. org.hibernate.loader.Loader.doList(Loader.java:2554)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    16. org.hibernate.loader.Loader.doList(Loader.java:2540)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    17. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    18. org.hibernate.loader.Loader.list(Loader.java:2365)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    19. org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    20. org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    21. org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    22. org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    23. org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)[hibernate-core-4.3.8.Final.jar:4.3.8.Final]
    23 frames
  5. com.manydesigns.portofino
    AbstractCrudAction.execute
    1. com.manydesigns.portofino.persistence.QueryUtils.runHqlQuery(QueryUtils.java:586)[portofino-database-4.1.3.jar:4.1.3]
    2. com.manydesigns.portofino.persistence.QueryUtils.getObjects(QueryUtils.java:421)[portofino-database-4.1.3.jar:4.1.3]
    3. com.manydesigns.portofino.pageactions.crud.CrudAction.loadObjects(CrudAction.java:267)[portofino-crud-4.1.3.jar:4.1.3]
    4. com.manydesigns.portofino.pageactions.crud.AbstractCrudAction.executeSearch(AbstractCrudAction.java:342)[portofino-crud-4.1.3.jar:4.1.3]
    5. com.manydesigns.portofino.pageactions.crud.AbstractCrudAction.doSearch(AbstractCrudAction.java:304)[portofino-crud-4.1.3.jar:4.1.3]
    6. com.manydesigns.portofino.pageactions.crud.AbstractCrudAction.execute(AbstractCrudAction.java:264)[portofino-crud-4.1.3.jar:4.1.3]
    6 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_79]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_79]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_79]
    4. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_79]
    4 frames
  7. Stripes
    ExecutionContext.proceed
    1. net.sourceforge.stripes.controller.DispatcherHelper$6.intercept(DispatcherHelper.java:456)[stripes-1.5.8.jar:1.5.8]
    2. net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:158)[stripes-1.5.8.jar:1.5.8]
    2 frames
  8. com.manydesigns.portofino
    GuardsInterceptor.intercept
    1. com.manydesigns.portofino.interceptors.GuardsInterceptor.intercept(GuardsInterceptor.java:61)[portofino-base-4.1.3.jar:4.1.3]
    1 frame
  9. Stripes
    DispatcherServlet.service
    1. net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:155)[stripes-1.5.8.jar:1.5.8]
    2. net.sourceforge.stripes.controller.BeforeAfterMethodInterceptor.intercept(BeforeAfterMethodInterceptor.java:113)[stripes-1.5.8.jar:1.5.8]
    3. net.sourceforge.stripes.controller.ExecutionContext.proceed(ExecutionContext.java:155)[stripes-1.5.8.jar:1.5.8]
    4. net.sourceforge.stripes.controller.ExecutionContext.wrap(ExecutionContext.java:74)[stripes-1.5.8.jar:1.5.8]
    5. net.sourceforge.stripes.controller.DispatcherHelper.invokeEventHandler(DispatcherHelper.java:454)[stripes-1.5.8.jar:1.5.8]
    6. net.sourceforge.stripes.controller.DispatcherServlet.invokeEventHandler(DispatcherServlet.java:278)[stripes-1.5.8.jar:1.5.8]
    7. net.sourceforge.stripes.controller.DispatcherServlet.service(DispatcherServlet.java:160)[stripes-1.5.8.jar:1.5.8]
    7 frames
  10. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:731)[servlet-api.jar:na]
    1 frame
  11. Stripes
    DynamicMappingFilter.doFilter
    1. net.sourceforge.stripes.controller.DynamicMappingFilter$2.doFilter(DynamicMappingFilter.java:453)[stripes-1.5.8.jar:1.5.8]
    2. net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilter.java:260)[stripes-1.5.8.jar:1.5.8]
    3. net.sourceforge.stripes.controller.DynamicMappingFilter.doFilter(DynamicMappingFilter.java:440)[stripes-1.5.8.jar:1.5.8]
    3 frames
  12. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[catalina.jar:7.0.62]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[catalina.jar:7.0.62]
    2 frames
  13. com.manydesigns.portofino
    I18nFilter.doFilter
    1. com.manydesigns.portofino.servlets.I18nFilter.doFilter(I18nFilter.java:60)[portofino-base-4.1.3.jar:4.1.3]
    1 frame
  14. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[catalina.jar:7.0.62]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[catalina.jar:7.0.62]
    2 frames
  15. Stripes
    StripesFilter.doFilter
    1. net.sourceforge.stripes.controller.StripesFilter.doFilter(StripesFilter.java:260)[stripes-1.5.8.jar:1.5.8]
    1 frame
  16. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[catalina.jar:7.0.62]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[catalina.jar:7.0.62]
    2 frames
  17. com.manydesigns.portofino
    CleanupFilter.doFilter
    1. com.manydesigns.portofino.servlets.CleanupFilter.doFilter(CleanupFilter.java:47)[portofino-database-4.1.3.jar:4.1.3]
    1 frame
  18. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[catalina.jar:7.0.62]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[catalina.jar:7.0.62]
    2 frames
  19. com.manydesigns.portofino
    DispatcherFilter.doFilter
    1. com.manydesigns.portofino.servlets.DispatcherFilter.doFilter(DispatcherFilter.java:61)[portofino-pageactions-4.1.3.jar:4.1.3]
    1 frame
  20. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[catalina.jar:7.0.62]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[catalina.jar:7.0.62]
    2 frames
  21. Shiro
    OncePerRequestFilter.doFilter
    1. org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)[shiro-web-1.2.3.jar:1.2.3]
    2. org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)[shiro-web-1.2.3.jar:1.2.3]
    3. org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)[shiro-core-1.2.3.jar:1.2.3]
    4. org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)[shiro-core-1.2.3.jar:1.2.3]
    5. org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)[shiro-core-1.2.3.jar:1.2.3]
    6. org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)[shiro-web-1.2.3.jar:1.2.3]
    7. org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)[shiro-web-1.2.3.jar:1.2.3]
    7 frames
  22. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[catalina.jar:7.0.62]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[catalina.jar:7.0.62]
    2 frames
  23. com.manydesigns.elements
    ElementsFilter.doFilter
    1. com.manydesigns.elements.servlet.ElementsFilter.doHttpFilter(ElementsFilter.java:132)[elements-4.1.3.jar:4.1.3]
    2. com.manydesigns.elements.servlet.ElementsFilter.doFilter(ElementsFilter.java:83)[elements-4.1.3.jar:4.1.3]
    2 frames
  24. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)[catalina.jar:7.0.62]
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)[catalina.jar:7.0.62]
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)[catalina.jar:7.0.62]
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)[catalina.jar:7.0.62]
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)[catalina.jar:7.0.62]
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)[catalina.jar:7.0.62]
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)[catalina.jar:7.0.62]
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)[catalina.jar:7.0.62]
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)[catalina.jar:7.0.62]
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)[catalina.jar:7.0.62]
    10 frames
  25. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)[tomcat-coyote.jar:7.0.62]
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)[tomcat-coyote.jar:7.0.62]
    3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)[tomcat-coyote.jar:7.0.62]
    3 frames
  26. Java RT
    ThreadPoolExecutor$Worker.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_79]
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_79]
    2 frames
  27. Tomcat Util
    TaskThread$WrappingRunnable.run
    1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)[tomcat-coyote.jar:7.0.62]
    1 frame
  28. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)[na:1.7.0_79]
    1 frame