Re: JDBC Driver Problem

From: Dave Cramer <Dave(at)micro-automation(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Gautham S(dot) Rao" <gautam(dot)rao(at)tatainfotech(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC Driver Problem
Date: 2002-04-05 16:52:51
Message-ID: 1018025572.20047.62.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

This would be my guess too. It would make sense that the code that is
checking for escape sequences is broken

Dave

On Fri, 2002-04-05 at 11:09, Tom Lane wrote:
> "Gautham S. Rao" <gautam(dot)rao(at)tatainfotech(dot)com> writes:
> > This query returns 4 records when executed from the back end which is the
> > desired result. But when it is executed using the JDBC driver for postgreSQL
> > 7.1 and JDK 1.2, it returns only 3 records. This is the result of the first
> > query excluding the union. So it appears as if only the first part of the
> > query is working through the JDBC driver.
>
> Could the driver be dropping part of the query? I suggest turning on
> query logging at the backend (restart postmaster with -d2 switch, or
> set debug_print_query = true in postgresql.conf) and then look in the
> postmaster log to see exactly what query is being sent by JDBC.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-04-05 21:47:12 Re: Syntax of LIKE in PreparedStatement
Previous Message Tom Lane 2002-04-05 16:09:58 Re: JDBC Driver Problem