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.
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 .. |
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 |