JDBC Interfaces

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: Raw Message | Whole Thread | 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.

Browse pgsql-interfaces by date

  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