Received: from hub.org.org (localhost [127.0.0.1])
	by hub.org (8.10.1/8.10.1) with SMTP id e9A08GJ71821
	for <pgsql-interfaces@hub.org>; Mon, 9 Oct 2000 20:08:16 -0400 (EDT)
Received: from mel.alcatel.fr (mel.alcatel.fr [212.208.74.132])
	by hub.org (8.10.1/8.10.1) with ESMTP id e96CSRJ86756
	for <pgsql-interfaces@postgresql.org>;
	Fri, 6 Oct 2000 08:28:27 -0400 (EDT)
Received: from aifhs2.alcatel.fr (mailhub.alcatel.fr [155.132.180.80])
	by mel.alcatel.fr (ALCANET/SMTP) with ESMTP id OAA22490;
	Fri, 6 Oct 2000 14:27:37 +0200
Received: from dns1.nextenso.alcatel.fr (dns1.nextenso.alcatel.fr
	[139.54.130.251])
	by aifhs2.alcatel.fr (ALCANET/SMTP2) with ESMTP id OAA24261;
	Fri, 6 Oct 2000 14:25:40 +0200 (MET DST)
Received: from nextenso.com (IDENT:db@nx0022.nextenso.alcatel.fr
	[139.54.130.22])
	by dns1.nextenso.alcatel.fr (8.9.3/8.9.3) with ESMTP id OAA27588;
	Fri, 6 Oct 2000 14:27:07 +0200
Message-ID: <39DDC53B.DC22F0BE@nextenso.com>
Date: Fri, 06 Oct 2000 14:27:39 +0200
From: Didier Boudigue <didier.boudigue@nextenso.com>
Organization: Nextenso
X-Mailer: Mozilla 4.73 [en] (X11; I; Linux 2.2.15-4mdk i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org, pgsql-interfaces@hub.org
Subject: JDBC and BLOB in Postgres
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200010/54
X-Sequence-Number: 1411

Hi,

I'm trying  Blob with JDBC Driver jdbc7.0-1.2  on postgresql 7.0.2
(Mandrake 7.1) follwing the example given in paragraph "Using Large
Objects" Chapter 58. JDBC Interface.

the getBinaryStream seems ok provided the blob is in the database, 
while the setBinaryStream method call returns : 

	Error : InputStream as parameter not supported

Did I miss something ?

Thanks in advance.

The Code I'm using: 

File file = new File("Blob.class");
FileInputStream fis = new FileInputStream(file);			
cx.setAutoCommit(false);
ps = cx.prepareStatement("insert into mytable (myid, myblob) values (1,
?)");
ps.setBinaryStream(1, fis, (int) file.length());
ps.executeUpdate();
ps.close();
fis.close();
cx.commit();