AW: JDBC and LOB - Mailing list pgsql-general

From tna@FIZ-Karlsruhe.DE
Subject AW: JDBC and LOB
Date
Msg-id 41EA24EC431CD411AA8200008385014F490FAA@pc.FIZ-Karlsruhe.DE
Whole thread Raw
List pgsql-general
Hi,

> -----Ursprüngliche Nachricht-----
> Von: pgsql-general-owner@hub.org
> [mailto:pgsql-general-owner@hub.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

pgsql-general by date:

Previous
From: "Ing. Roberto Andrade Fonseca"
Date:
Subject: Postgres DateStyle
Next
From: tna@FIZ-Karlsruhe.DE
Date:
Subject: AW: Using the JDBC Driver in version 7.02