Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group