JDBC and LOB

From: Gabriel López Millán <gabilm(at)dif(dot)um(dot)es>
To: postgres <pgsql-general(at)postgresql(dot)org>, postgres-ayuda <pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx>
Subject: JDBC and LOB
Date: 2000-07-10 10:33:51
Message-ID: 3969A68F.C7DA777D@dif.um.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda pgsql-general

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.

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Miguel Angel López Hernández 2000-07-10 15:13:09 Re: [pgsql-ayuda] [GENERAL] PostgreSQL vs. MySQL (fwd)
Previous Message Gabriel López Millán 2000-07-10 08:31:31 [pgsql-ayuda] datos binarios ..

Browse pgsql-general by date

  From Date Subject
Next Message Travis Bauer 2000-07-10 10:37:09 SQL question
Previous Message Holger Klawitter 2000-07-10 09:36:19 Re: Counting affected rows