AW: JDBC and LOB

Hi,

> -----Ursprüngliche Nachricht-----
> Von: pgsql-general-owner(at)hub(dot)org
> [mailto:pgsql-general-owner(at)hub(dot)org]Im
> Auftrag von Gabriel López Millán
> Gesendet am: Montag, 10. Juli 2000 12:34
> An: postgres; postgres-ayuda
> Betreff: [GENERAL] JDBC and LOB
>
> 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

The homepage of the driver is http://www.retep.org.uk/postgres/.
Unfortunately
the "what is planned"-item "Add Stream support to large objects" is Delayed
:-(
(I also need it for a project ...)

Bye

Thomas