Received: from unimur.um.es (unimur.um.es [155.54.1.1])
	by hub.org (8.10.1/8.10.1) with ESMTP id e6ABH5W62494
	for <pgsql-interfaces@postgresql.org>;
	Mon, 10 Jul 2000 07:17:05 -0400 (EDT)
Received: from aries.dif.um.es (aries.dif.um.es [155.54.210.253])
	by unimur.um.es (8.9.1b+Sun/8.9.1) with ESMTP id NAA18667
	for <pgsql-interfaces@postgresql.org>;
	Mon, 10 Jul 2000 13:17:04 +0200 (MET DST)
Received: from dif.um.es (labredes15.dif.um.es [155.54.210.9])
	by aries.dif.um.es (Postfix) with ESMTP id 03315EC1A
	for <pgsql-interfaces@postgresql.org>;
	Mon, 10 Jul 2000 13:16:57 +0200 (MET DST)
Message-ID: <3969B0A9.84CD6B2E@dif.um.es>
Date: Mon, 10 Jul 2000 13:16:57 +0200
From: Gabriel =?iso-8859-1?Q?L=F3pez=20Mill=E1n?= <gabilm@dif.um.es>
X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC Interfaces
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from base64 to 8bit by hub.org id e6ABH6W62500
X-Archive-Number: 200007/41

Hi, I try to run  this example:

     String query = "INSERT INTO requestTable VALUES (?,?);";
     int i = 1;

     PreparedStatement ps =
(PreparedStatement)connection.prepareStatement(query);
     ps.setInt(1,i);
     ByteArrayInputStream bis = new ByteArrayInputStream(b);
     ps.setBinaryStream(2,bis,bis.available());
     ps.executeUpdate();        // execute the insert statement
     System.out.println("ejecuta");
     ps.close();                // close the prepared statement
     bis.close();

     where de segundo parameter is a oid type.

    The response is:


    SQL Exception: InputStream as parameter not supported

    What tipes of InputStream are supported?
    Where can I find more information?

    Thanks, Gabi.