| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Rob Kirkbride <rob(at)rkcomputing(dot)co(dot)uk> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: More Verbose Logging of Statements |
| Date: | 2005-11-10 16:15:44 |
| Message-ID: | Pine.BSO.4.61.0511101112450.28629@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Thu, 10 Nov 2005, Rob Kirkbride wrote:
> I've been trying to understand the documentation at
> http://www.postgresql.org/docs/8.0/static/runtime-config.html but I can't get
> it to put into my logfile the actual contents of prepared statement
> parameters. I just get $1, $2 etc. I'd like to show me what those are either
> in the actual line or below I don't mind which.
>
No, the JDBC driver uses the new extended query protocol by default which
the server does not log very well. You could make the driver fallback to
the older protocol by using the URL parameter ?protocolVersion=2 which is
logged fully, but then you're not really testing the same thing if you are
trying to debug a problem or do a performance analysis.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Kirkbride | 2005-11-10 16:19:53 | Re: More Verbose Logging of Statements |
| Previous Message | Rob Kirkbride | 2005-11-10 11:54:37 | More Verbose Logging of Statements |