Re: [JDBC] JDBC and Binary protocol error, for some statements

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Radosław Smogura <rsmogura(at)softperience(dot)eu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL JDBC List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] JDBC and Binary protocol error, for some statements
Date: 2010-11-25 20:59:53
Message-ID: AANLkTik+vZWCaywc0XyufvkrhJ5b659N9tG5m76VBZ+t@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

> 21:43:02.264 (26) FE=> Describe(statement=S_1)

You're still doing the statement-flavor Describe. As Tom pointed out,
this won't tell you the result types because it doesn't know them.
Actually, technically if you issue a statement-flavor Describe *after*
a Bind, the server does have this information, but I'm not surprised
that it doesn't send it correctly, since it seems pointless to send
the statement variation after already doing a Bind.

You may be able to change the JDBC code to call sendDescribePortal() instead.

---
Maciek Sakrejda | System Architect | Truviso

1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2010-11-25 21:06:03 Re: Extensions, this time with a patch
Previous Message Steve Singer 2010-11-25 20:58:40 Re: Patch to add a primary key using an existing index

Browse pgsql-jdbc by date

  From Date Subject
Next Message Thomas Kellerer 2010-11-25 21:51:57 Re: getTables() doesn't handle umlauts correctly
Previous Message Radosław Smogura 2010-11-25 20:46:47 Re: [JDBC] JDBC and Binary protocol error, for some statements