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

Hibernate JIRA | Mathias Bogaert | 1 decade ago
  1. 0

    When enabling hibernate.use_sql_comments I get the following exceptions: INFO - SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase] Hibernate: /*criteria query*/select this_.USER_ID as USER1_0_, this_1_.LOGIN as LOGIN28_0_, this_1_.FIRST_NAME as FIRST3_28_0_, th is_1_.LAST_NAME as LAST4_28_0_, this_1_.FULL_NAME as FULL5_28_0_, this_1_.EMAIL_ADDRESS as EMAIL6_28_0_, this_1_.STATUS as STATUS2 8_0_, this_1_.UNIT_ID as UNIT8_28_0_, this_.PHONE as PHONE30_0_, this_.COUNTRY_ISO as COUNTRY3_30_0_, this_.LAST_LOGIN as LAST4_30 _0_, this_.LAST_PASSWORD_ENTERED as LAST5_30_0_, roles2_.USER_ID as USER1___, roles2_.ROLE_ID as ROLE2___ from AUD_USERS this_ inn er join AUD_REF_USERS_VIEW this_1_ on this_.USER_ID=this_1_.USER_ID left outer join AUD_REF_USERS_ROLES_VIEW roles2_ on this_.USER _ID=roles2_.USER_ID where this_1_.LOGIN=? WARN - SQL Error: 1009, SQLState: 72000 ERROR - ORA-01009: missing mandatory parameter ERROR - Could not execute action org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1565) at org.hibernate.loader.Loader.list(Loader.java:1545) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1316) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:299) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:432) at eu.cec.regio.sysaudit.domain.reference.persistence.hibernate.HibernateReferenceDao.findUserByLogin(HibernateReferenceDa o.java:311) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy65.findUserByLogin(Unknown Source) at eu.cec.regio.sysaudit.security.OracleSecurityService.authenticate(OracleSecurityService.java:52) at eu.cec.regio.sysaudit.web.action.security.MultipleRoleLogin.authenticate(MultipleRoleLogin.java:23) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... with undelying trace: Caused by: java.sql.SQLException: ORA-01009: missing mandatory parameter at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1250) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295) at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.next(Unknown Source) at org.hibernate.loader.Loader.doQuery(Loader.java:391) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210) at org.hibernate.loader.Loader.doList(Loader.java:1562)

    Hibernate JIRA | 1 decade ago | Mathias Bogaert
    org.hibernate.exception.GenericJDBCException: could not execute query
  2. 0

    When enabling hibernate.use_sql_comments I get the following exceptions: INFO - SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase] Hibernate: /*criteria query*/select this_.USER_ID as USER1_0_, this_1_.LOGIN as LOGIN28_0_, this_1_.FIRST_NAME as FIRST3_28_0_, th is_1_.LAST_NAME as LAST4_28_0_, this_1_.FULL_NAME as FULL5_28_0_, this_1_.EMAIL_ADDRESS as EMAIL6_28_0_, this_1_.STATUS as STATUS2 8_0_, this_1_.UNIT_ID as UNIT8_28_0_, this_.PHONE as PHONE30_0_, this_.COUNTRY_ISO as COUNTRY3_30_0_, this_.LAST_LOGIN as LAST4_30 _0_, this_.LAST_PASSWORD_ENTERED as LAST5_30_0_, roles2_.USER_ID as USER1___, roles2_.ROLE_ID as ROLE2___ from AUD_USERS this_ inn er join AUD_REF_USERS_VIEW this_1_ on this_.USER_ID=this_1_.USER_ID left outer join AUD_REF_USERS_ROLES_VIEW roles2_ on this_.USER _ID=roles2_.USER_ID where this_1_.LOGIN=? WARN - SQL Error: 1009, SQLState: 72000 ERROR - ORA-01009: missing mandatory parameter ERROR - Could not execute action org.hibernate.exception.GenericJDBCException: could not execute query at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92) at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1565) at org.hibernate.loader.Loader.list(Loader.java:1545) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1316) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:299) at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:432) at eu.cec.regio.sysaudit.domain.reference.persistence.hibernate.HibernateReferenceDao.findUserByLogin(HibernateReferenceDa o.java:311) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy65.findUserByLogin(Unknown Source) at eu.cec.regio.sysaudit.security.OracleSecurityService.authenticate(OracleSecurityService.java:52) at eu.cec.regio.sysaudit.web.action.security.MultipleRoleLogin.authenticate(MultipleRoleLogin.java:23) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ... with undelying trace: Caused by: java.sql.SQLException: ORA-01009: missing mandatory parameter at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1983) at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:1250) at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:295) at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.next(Unknown Source) at org.hibernate.loader.Loader.doQuery(Loader.java:391) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210) at org.hibernate.loader.Loader.doList(Loader.java:1562)

    Hibernate JIRA | 1 decade ago | Mathias Bogaert
    org.hibernate.exception.GenericJDBCException: could not execute query
  3. 0

    Tomcat - User - Tomcat 5.0.27 >> java.net.SocketException: Software caused connection abort: recv failed

    nabble.com | 7 months ago
    org.hibernate.exception.GenericJDBCException: could not execute query
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Tomcat 5.0.27 >> java.net.SocketException: Software caused connection abort: recv failed

    apache.org | 1 year ago
    org.hibernate.exception.GenericJDBCException: could not execute query
  6. 0

    [HHH-811] Error when using Expression.ilike with Firebird - Hibernate JIRA

    atlassian.net | 1 year ago
    org.hibernate.exception.GenericJDBCException: could not execute query

    1 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. org.hibernate.exception.GenericJDBCException

      could not execute query

      at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException()
    2. Hibernate
      CriteriaLoader.list
      1. org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
      2. org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
      3. org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      4. org.hibernate.loader.Loader.doList(Loader.java:1565)
      5. org.hibernate.loader.Loader.list(Loader.java:1545)
      6. org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:111)
      6 frames
    3. Hibernate
      CriteriaImpl.uniqueResult
      1. org.hibernate.impl.SessionImpl.list(SessionImpl.java:1316)
      2. org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:299)
      3. org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:432)
      3 frames
    4. eu.cec.regio
      HibernateReferenceDao.findUserByLogin
      1. eu.cec.regio.sysaudit.domain.reference.persistence.hibernate.HibernateReferenceDao.findUserByLogin(HibernateReferenceDao.java:311)
      1 frame
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:324)
      4 frames
    6. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
      3 frames
    7. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
      1 frame
    8. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
      2 frames
    9. Unknown
      $Proxy65.findUserByLogin
      1. $Proxy65.findUserByLogin(Unknown Source)
      1 frame
    10. eu.cec.regio
      MultipleRoleLogin.authenticate
      1. eu.cec.regio.sysaudit.security.OracleSecurityService.authenticate(OracleSecurityService.java:52)
      2. eu.cec.regio.sysaudit.web.action.security.MultipleRoleLogin.authenticate(MultipleRoleLogin.java:23)
      2 frames
    11. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame