Gautham,
So what was the solution? Is the driver broken? Did you work around the
problem?
Dave
On Mon, 2002-04-08 at 08:01, Gautham S. Rao wrote:
> Hi Dave/Tom,
>
> Thanks very much for the suggestion. The problem was beacuse the paramaters
> in the where clause were not getting replaced with the actual values. This I
> could figure out from the log and have corrected the logic to handle it
> properly. Now the queries are working fine.
>
> Thanks & Regards,
> Gautham
>
> ----- Original Message -----
> From: "Dave Cramer" <Dave@micro-automation.net>
> To: "Tom Lane" <tgl@sss.pgh.pa.us>
> Cc: "Gautham S. Rao" <gautam.rao@tatainfotech.com>;
> <pgsql-jdbc@postgresql.org>
> Sent: Friday, April 05, 2002 10:22 PM
> Subject: Re: [JDBC] JDBC Driver Problem
>
>
> > 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.rao@tatainfotech.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
> > >
> > >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
>
