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@realtimeint.com  (http://www.realtimeint.com)
private:  joachim@kraut.bc.ca       (http://www.kraut.bc.ca)