Re: JDBC + large objects problem

Today, in a message to pgsql-interfaces, Patrick Goodwill wrote:
>
> "InputStream as parameter not supported"
>
> PreparedStatement pstmt = ...
> ...
> pstmt.setBinaryStream(3, textStream, text.length());

As the error message says, streams are not yet supported for blobs.
Instead, read the contents of the stream into a byte array and use the
setBytes() method of PreparedStatement.

> if ya'll have any ideas why it does what it does, i just might kiss your
> feet. =)

Better yet, you could consult the archives of this mailing list. This
question seems to come up every couple of weeks. You can find an archive
at http://www.geocrawler.com/lists/3/Databases/105/0/.

Joachim

--
work: joachima(at)realtimeint(dot)com (http://www.realtimeint.com)
private: joachim(at)kraut(dot)bc(dot)ca (http://www.kraut.bc.ca)