Received: from fancy.ocn.ne.jp (fancy.ocn.ne.jp [210.190.142.52])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1Q4iGx02252
	for <pgsql-interfaces@postgresql.org>;
	Sun, 25 Feb 2001 23:44:16 -0500 (EST)
	(envelope-from hkasa@fancy.ocn.ne.jp)
Received: from fancy.ocn.ne.jp (q20-dn02sasebo.nagasaki.ocn.ne.jp
	[211.17.41.21])
	by fancy.ocn.ne.jp (8.9.1a/OCN/) with ESMTP id NAA16969
	for <pgsql-interfaces@postgresql.org>;
	Mon, 26 Feb 2001 13:44:10 +0900 (JST)
Message-ID: <3A99DD12.585E8854@fancy.ocn.ne.jp>
Date: Mon, 26 Feb 2001 13:35:30 +0900
From: "NSB)Hiroshi Kasamatsu" <hkasa@fancy.ocn.ne.jp>
X-Mailer: Mozilla 4.73 [ja] (Win98; U)
X-Accept-Language: ja
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Alternative to setBinaryStream
Content-Type: text/plain; charset=iso-2022-jp
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200102/175
X-Sequence-Number: 1139

  As of now,it seems that PreparedStatement.setBinaryStream is not
supported in PosrgreSQL-jdbc.But I sincerely need method similar to this
stream.
The reason is that in my servlet application jpg image is dynamically
displayed by <img
src=http://www.kasa.com/Image/servlet/ImageServlet?imgname=kasa.jpg>
tag.
Throughout this process,binary stream ,or getBinaryStream is used.
Therefore,image needs to be inserted into database by
PreparedStatement.setBinaryStream in advance.
 One suggestions from mailing list is using ByteArrayInputStream:
That is ,ByteArrayInputStream bi=new ByteArrayInputStream(bytes);
ps.setBinaryInputStream(imgoid,bi,bytes.length);
To be sorry,the result is the same:InputStream as parameter not
supported;

Please tell me an alternative to setBinaryStream.

Thanks in advance.


Hiroshi Kasamatsu