From: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
---|---|
To: | 'Gabriel López Millán' <gabilm(at)dif(dot)um(dot)es>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: JDBC Interfaces |
Date: | 2000-07-10 13:56:52 |
Message-ID: | 1B3D5E532D18D311861A00600865478CF1B050@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hmmm, its not clear what you are trying to do. I presume you are writing to
a blob?
If so, then yes Streams are not yet supported. However, if it's a normal
column (ie: text, varchar, etc), then yes Streams are supported and it
should work.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council
-----Original Message-----
From: Gabriel López Millán [mailto:gabilm(at)dif(dot)um(dot)es]
Sent: Monday, July 10, 2000 12:17 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] JDBC 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 | Thomas Lockhart | 2000-07-10 15:04:39 | Re: Smalltalk driver |
Previous Message | Bruce Badger | 2000-07-10 12:41:12 | Smalltalk driver |