org.postgresql.util.PSQLException: No value specified for parameter 9.

Stack Overflow | We are Borg | 9 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Hibernate, PostgreSQL : No value specified for parameter 9 with Criteria

    Stack Overflow | 9 months ago | We are Borg
    org.postgresql.util.PSQLException: No value specified for parameter 9.
  2. 0

    Obscure error reporting

    GitHub | 4 years ago | omj
    org.postgresql.util.PSQLException: ERROR: relation "project" does not exist org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
  3. 0

    PostgreSQL syntax error in param passed in a BeanPropertyRowMapper

    Stack Overflow | 2 years ago | SilvioC90
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "$3" Posizione: 3939
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ERROR : column "this_.date" must appear in the GROUP BY clause or be used in an aggregate function

    Stack Overflow | 1 year ago | Chengappa
    org.postgresql.util.PSQLException: ERROR: column "this_.date" must appear in the GROUP BY clause or be used in an aggregate function Position: 296
  6. 0

    PostgreSQL 8.3 support

    GitHub | 4 years ago | flyway
    org.apache.maven.lifecycle.LifecycleExecutionException: Flyway Error: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select typname from pg_catalog.pg_type where typcategory in ('P', 'U') and typnamespace in (select oid from pg_catalog.pg_namespace where nspname = ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column "typcategory" does not exist
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.postgresql.util.PSQLException

    No value specified for parameter 9.

    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:223)
    2. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:244)
    3. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
    5 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    2 frames
  4. Hibernate
    CriteriaImpl.list
    1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
    2. org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
    3. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
    4. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
    5. org.hibernate.loader.Loader.doQuery(Loader.java:910)
    6. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
    7. org.hibernate.loader.Loader.doList(Loader.java:2554)
    8. org.hibernate.loader.Loader.doList(Loader.java:2540)
    9. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
    10. org.hibernate.loader.Loader.list(Loader.java:2365)
    11. org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126)
    12. org.hibernate.internal.SessionImpl.list(SessionImpl.java:1718)
    13. org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)
    13 frames
  5. com.journaldev.spring
    HostDAOImpl.getRecommendedHosts
    1. com.journaldev.spring.dao.HostDAOImpl.getRecommendedHosts(HostDAOImpl.java:166)
    1 frame
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  7. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    3 frames
  8. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    3 frames
  9. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    2 frames
  10. com.sun.proxy
    $Proxy51.getRecommendedHosts
    1. com.sun.proxy.$Proxy51.getRecommendedHosts(Unknown Source)
    1 frame
  11. com.journaldev.spring
    HostServiceImpl.getRecommendedHosts
    1. com.journaldev.spring.service.HostServiceImpl.getRecommendedHosts(HostServiceImpl.java:411)
    1 frame
  12. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  13. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    3 frames
  14. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    3 frames
  15. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
    2 frames
  16. com.sun.proxy
    $Proxy70.getRecommendedHosts
    1. com.sun.proxy.$Proxy70.getRecommendedHosts(Unknown Source)
    1 frame
  17. com.journaldev.spring
    PageNavigationController$$FastClassBySpringCGLIB$$92569e93.invoke
    1. com.journaldev.spring.controller.PageNavigationController.profile(PageNavigationController.java:75)
    2. com.journaldev.spring.controller.PageNavigationController$$FastClassBySpringCGLIB$$92569e93.invoke(<generated>)
    2 frames
  18. Spring Core
    MethodProxy.invoke
    1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    1 frame
  19. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    2 frames