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

Google Groups | Michel van der Kleij | 1 year ago
  1. 0

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

    Google Groups | 1 year 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 | 5 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 | 3 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 | 3 months ago
    java.sql.SQLException: Before start of result set

  1. kuldeep 2 times, last 3 months ago
2 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. 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