org.postgresql.util.PSQLException: ERROR: function year(timestamp without time zone) does not exist

openxava | tokugawa69 | 9 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

    Problema fechas y buscador en listas

    openxava | 9 years ago | tokugawa69
    org.postgresql.util.PSQLException: ERROR: function year(timestamp without time zone) does not exist
  2. 0

    Errores obteniendo los datos de la lista!!

    openxava | 5 years ago | rsalesbeltran
    org.postgresql.util.PSQLException: ERROR: no existe la relación «cliente»   Position: 23
  3. 0

    Filtering table with a description list

    openxava | 7 years ago | malleblas
    org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying   Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.   Position: 277
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Como crear una Clase transitoria

    openxava | 6 years ago | mingoro43
    org.postgresql.util.PSQLException: ERROR: no existe la relación «consultapersonacuota»   Position: 23
  6. 0

    Problema en nueva opcion de filtro en lista

    openxava | 7 years ago | crcm
    org.postgresql.util.PSQLException: ERROR: la referencia a la columna «idgerencia» es ambigua   Position: 118

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

    ERROR: function year(timestamp without time zone) does not exist

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
    6 frames
  3. org.apache.tomcat
    DelegatingPreparedStatement.executeQuery
    1. org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
    1 frame
  4. org.openxava.tab
    Tab.getTotalSize
    1. org.openxava.tab.impl.JDBCTabProvider.getResultSize(JDBCTabProvider.java:326)
    2. org.openxava.tab.impl.EntityTabDataProvider.getResultSize(EntityTabDataProvider.java:216)
    3. org.openxava.tab.impl.EntityTab.getResultSize(EntityTab.java:560)
    4. org.openxava.tab.impl.TableModelBean.getTotalSize(TableModelBean.java:276)
    5. org.openxava.tab.impl.XTableModelDecoratorBase.getTotalSize(XTableModelDecoratorBase.java:87)
    6. org.openxava.tab.Tab.getTotalSize(Tab.java:681)
    6 frames