SQL select doesn't work

From: Leonid Vygovskiy <leonid(dot)vygovsky(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: SQL select doesn't work
Date: 2011-02-06 08:40:53
Message-ID: d0250c10-0572-4232-b5bb-ef6fd6566aa1@d16g2000yqd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello!

I use xwiki with postgresql, xwiki uses hibernate. I have exception on
select, that successful executed in psql:

select distinct xwikidocum0_.XWD_WEB as col_0_0_,
xwikidocum0_.XWD_NAME as col_1_0_, xwikidocum0_.XWD_DATE as col_2_0_
from xwikidoc xwikidocum0_ where (xwikidocum0_.XWD_HIDDEN<>true or
xwikidocum0_.XWD_HIDDEN is null) and 1=1 and
xwikidocum0_.XWD_AUTHOR='XWiki.leonidv' order by xwikidocum0_.XWD_DATE
desc

Exception:
org.postgresql.util.PSQLException: ERROR: could not find hash function
for hash operator 2060
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:
2102)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:
1835)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
257)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:
500)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:
388)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:
273)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:
96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:
96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:
96)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:
186)

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Lew 2011-02-06 16:24:00 Re: JDBC CallableStatement bug on functions with return parameter
Previous Message Radosław Smogura 2011-02-05 22:19:14 Re: ssl connection strangely stops working