InputStream as parameter not supported - Mailing list pgsql-jdbc

From Steven Smith
Subject InputStream as parameter not supported
Date
Msg-id NEBBKBCGPMGCJLHJBICKIEBACAAA.steven@geometryit.com
Whole thread Raw
Responses Re: InputStream as parameter not supported  (Peter T Mount <peter@retep.org.uk>)
List pgsql-jdbc
I am using PostgreSQL 7.0, with the jdbc7.0-1.2.jar file.
I am trying to send a Large Object to the database but get an error saying
'InputStream as parameter not supported'
The offending statement is
'stmt.setBinaryStream(1, geomStream, geomStream.available());'
where geomStream is an instanceof ByteArrayInputStream and stmt is a
PreparedStatement.
The exact same code runs beautifully under Oracle, but throws this exeption
under PostgreSQL.
I have followed the documentation to the letter so I don't see why it throws
the exception.
The field in the table is of type 'oid', which the documentation uses.


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: JDBC Driver under load
Next
From: "Mike Cannon-Brookes"
Date:
Subject: RE: JDBC Driver under load