From: | tna(at)FIZ-Karlsruhe(dot)DE |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | AW: JDBC and LOB |
Date: | 2000-07-11 13:47:04 |
Message-ID: | 41EA24EC431CD411AA8200008385014F490FAA@pc.FIZ-Karlsruhe.DE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | tna | 2000-07-11 13:48:57 | AW: Using the JDBC Driver in version 7.02 |
Previous Message | Bruce Momjian | 2000-07-11 13:09:51 | Re: pg_backup symlink? |