| From: | Gabriel López Millán <gabilm(at)dif(dot)um(dot)es> |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | JDBC Interfaces |
| Date: | 2000-07-10 11:16:57 |
| Message-ID: | 3969B0A9.84CD6B2E@dif.um.es |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
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 | Michael Ansley | 2000-07-10 12:38:18 | RE: SPI documentation |
| Previous Message | Carolyn Lu Wong | 2000-07-10 01:59:08 | Cursor library not capable |