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

Stack Overflow | We are Borg | 4 months ago
  1. 0

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

    Stack Overflow | 4 months ago | We are Borg
    org.postgresql.util.PSQLException: No value specified for parameter 9.
  2. 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
  3. 0

    PostgreSQL 8.3 support

    GitHub | 3 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Obscure error reporting

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

    Non-admin users unable to connect to geoserver

    GitHub | 3 years ago | singhdonald
    org.postgresql.util.PSQLException: ERROR: column layers_layer.id does not exist Where: PL/pgSQL function "geonode_authorize_layer" line 13 at SQL statement

  1. haerick 8 times, last 5 months ago
  2. csanyigabor 4 times, last 3 months ago
  3. Tahir 1 times, last 3 months ago
  4. RoiOtero 3 times, last 5 months ago
  5. silex 15 times, last 6 months ago
2 more registered users
33 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.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