Received: from snmsu2.montrouge.omnes.slb.com (snmsu2.montrouge.omnes.slb.com [163.187.152.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAU9q1t16365 for ; Thu, 30 Nov 2000 04:52:02 -0500 (EST) (envelope-from jeannet@montrouge.tt.slb.com) Received: from snmsu1.montrouge.omnes.slb.com (snmsu1 [163.187.152.2]) by snmsu2.montrouge.omnes.slb.com (8.9.3/8.9.3) with ESMTP id KAA24377; Thu, 30 Nov 2000 10:50:02 +0100 (MET) Received: from montrouge.tt.slb.com (ttmdy019216.montrouge.tt.slb.com [163.187.19.216]) by snmsu1.montrouge.omnes.slb.com (8.9.3/8.9.1) with ESMTP id KAA20204; Thu, 30 Nov 2000 10:44:55 +0100 (MET) Message-ID: <3A2623E3.66A73425@montrouge.tt.slb.com> Date: Thu, 30 Nov 2000 10:54:43 +0100 From: Olivier Jeannet Reply-To: ojeannet@slb.com X-Mailer: Mozilla 4.72 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: Peter Mount CC: pgsql-interfaces@postgresql.org Subject: Re: bytea not recognized by JDBC (7.0.2) References: <1B3D5E532D18D311861A00600865478CF1B5E1@exchange1.nt.maidstone.gov.uk> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/296 X-Sequence-Number: 333 Peter Mount wrote: > > How can I select a "bytea" field ? > > getBytes() should work. Can you be more precise please ? As I get an error from the JDBC driver doing the select, on what variable should I use getBytes() ? > > Is this a bug of the JDBC driver (or a not implemented feature) ? > > No not quite. getObject() currently doesn't know about bytea, so it's > passing it on to the Serializable code which is then failing. And what is the solution or work around ? Regards, -- Olivier Jeannet - e-Payment solutions I prefer not running 32 bit extensions for a 16 bit patch to an 8 bit operating system originally coded for a 4 bit microprocessor, written by a 2 bit company, that can't stand 1 bit of competition.