Re: SQL select doesn't work

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Leonid Vygovskiy <leonid(dot)vygovsky(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: SQL select doesn't work
Date: 2011-02-06 17:31:11
Message-ID: AANLkTi=bEeGdXN3few5XpUNeCsXGaHWKC1g-tpnBFFuv@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Given that this is an error from the backend (see receiveErrorResponse
in the stack trace), my guess is you're not running quite the same
query in psql.

So,

1. What is the definition of the xwikidoc table?
2. How did you figure out what SQL Hibernate is using here? How are
you executing it in psql? I imagine the main difference here could be
if Hibernate is using a prepared statement and you're just
substituting parameters directly into the psql query instead of using
PREPARE/EXECUTE (which still might not be *quite* the same thing, but
it's probably closer).

---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
www.truviso.com

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andreas Joseph Krogh 2011-02-06 23:01:21 ResultSet.getClob() causing problems when used with JPA's @Lob
Previous Message Lew 2011-02-06 16:24:00 Re: JDBC CallableStatement bug on functions with return parameter