InputStream as parameter not supported

From: "Steven Smith" <steven(at)geometryit(dot)com>
To: "PostgreSQL JDBC Mailing List" <pgsql-jdbc(at)postgresql(dot)org>
Subject: InputStream as parameter not supported
Date: 2001-04-19 02:08:24
Message-ID: NEBBKBCGPMGCJLHJBICKIEBACAAA.steven@geometryit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Adam Rossi 2001-04-19 04:06:51 7.1 RPM has old JDBC driver - SQL statement too long
Previous Message Tom Lane 2001-04-19 00:55:01 Re: JDBC Driver under load