| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Gautham S(dot) Rao" <gautam(dot)rao(at)tatainfotech(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: JDBC Driver Problem |
| Date: | 2002-04-05 16:09:58 |
| Message-ID: | 24564.1018022998@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-04-05 16:52:51 | Re: JDBC Driver Problem |
| Previous Message | Elisabeth Julg | 2002-04-05 15:47:30 | Re: Accents for TEXT |