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: 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 12:03:23
Message-ID: 44eac2baff3ace9ad1d2459237eb39ce@smogura-softworks.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-jdbc

I checked against other parameter bindings and it looks like problem is
connected with oid=0.
In those cases:
1. Executing statement with parameter sent as varchar, int, long, with
text and binary format is ok.
2. Executing statement with oid=0 fail always; I've sent parameter in text
mode (encoded '2'), and in binary mode encoded int4 2 - both failed.

On Thu, 25 Nov 2010 01:56:02 -0800, Maciek Sakrejda
<msakrejda(at)truviso(dot)com>
wrote:
> Haven't really gotten much further, but an interesting note: the named
> / unnamed prepared statement and portal stuff seems to be a red
> herring. I can add a name to the portal, or move to an unnamed
> prepared statement, and I still see the same thing. Which is
> interesting, since that's not what Radosław saw (his original test
> only failed once named prepared statements kicked in)...
> ---
> 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 Alvaro Herrera 2010-11-25 12:55:02 Re: pgsql: Remove useless whitespace at end of lines
Previous Message Heikki Linnakangas 2010-11-25 10:52:08 Re: GiST insert algorithm rewrite

Browse pgsql-jdbc by date

  From Date Subject
Next Message Martin Goodfellow 2010-11-25 16:00:07 Problem with COPY using PostgreSQL 9 and JDBC 4
Previous Message Maciek Sakrejda 2010-11-25 09:56:02 Re: [JDBC] JDBC and Binary protocol error, for some statements