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

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
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 19:34:41
Message-ID: 3fdb6c535dfee20399b31e792b5eaf76@smogura-softworks.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

On Thu, 25 Nov 2010 11:28:02 -0800, Maciek Sakrejda
<msakrejda(at)truviso(dot)com>
wrote:
>> So, to summarise, I shouldn't believe server DescribeRow (in context of
>> format), in this situation, but only I should look at this what I asked
>> for, isn't it? If I asked for columns in binary format, I need to do
>> binary reading regarding what server has responded?
>
> Yes, because in this case "0" doesn't mean "the result will be in
> text", it means, "you issued the statement-variant of Describe, so I'm
> not sure what the result format will be yet."
>
>> If I asked for odd columns in text, even in binary do I need to choose
>> proper format basing only on my request?
>
> I don't quite understand this question, but I think so. I don't think
> there's ever a situation where the server will ignore your result
> format requests.
>
>> But to the last part of cited protocol specification, when I've sent
>> message with statement parameter's type int4, int8, varchar the format
>> field wasn't set to 0, but 1.
>
> I wasn't able to reproduce that with my standalone test case. When I
> changed the parameter oid to 23, I still got the same behavior. Can
> you alter my test case to reproduce the error?
>
I will do it tomorrow.

In this situation I need to test portals as well.

> ---
> Maciek Sakrejda | System Architect | Truviso
>
> 1065 E. Hillsdale Blvd., Suite 215
> Foster City, CA 94404
> (650) 242-3500 Main
> www.truviso.com

--
----------
Radosław Smogura
http://www.softperience.eu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-11-25 19:42:09 Re: [JDBC] JDBC and Binary protocol error, for some statements
Previous Message Maciek Sakrejda 2010-11-25 19:28:02 Re: [JDBC] JDBC and Binary protocol error, for some statements

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2010-11-25 19:42:09 Re: [JDBC] JDBC and Binary protocol error, for some statements
Previous Message Maciek Sakrejda 2010-11-25 19:28:02 Re: [JDBC] JDBC and Binary protocol error, for some statements