Quoting Steven Smith <steven(at)geometryit(dot)com>:
> 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
> '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
> The exact same code runs beautifully under Oracle, but throws this
> under PostgreSQL.
> I have followed the documentation to the letter so I don't see why it
> the exception.
> The field in the table is of type 'oid', which the documentation uses.
These methods are implemented in 7.1. Prior to 7.1, you have to use the
getBytes/getBytes methods or the large object api's.
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
In response to
pgsql-jdbc by date
|Next:||From: Peter T Mount||Date: 2001-04-23 15:14:03|
|Subject: Re: 7.1 RPM has old JDBC driver - SQL statement too long|
|Previous:||From: B.N.V. Raman||Date: 2001-04-23 10:17:55|
|Subject: RE: Another Problem Connecting to JDBC7.0|