Re: setBlob(InputStream) not supported?

So looking at the jdbc4 code for this it would make sense to refactor
the jdbc2 code to allow passing in an input stream.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Wed, Sep 28, 2011 at 7:34 AM, Benson Margulies <bimargulies(at)gmail(dot)com> wrote:
> I've got a web service that is coded to stream data into a database
> blob via jdbc, and which uses, therefore, the setBlob(InputStream) API
> on the prepared statement.
>
> I was rewarded in the very latest driver with a 'not yet implemented'.
> Is there a recommended workaround for this?
>
>
> org.springframework.dao.InvalidDataAccessApiUsageException:
> PreparedStatementCallback; SQL [insert into document (id, contents,
> created, metadata) values (?, ?, ?, ?)]; Method
> org.postgresql.jdbc4.Jdbc4PreparedStatement.setBlob(int, InputStream)
> is not yet implemented.; nested exception is
> java.sql.SQLFeatureNotSupportedException: Method
> org.postgresql.jdbc4.Jdbc4PreparedStatement.setBlob(int, InputStream)
> is not yet implemented.
>        ...
> Caused by: java.sql.SQLFeatureNotSupportedException: Method
> org.postgresql.jdbc4.Jdbc4PreparedStatement.setBlob(int, InputStream)
> is not yet implemented.
>        at org.postgresql.Driver.notImplemented(Driver.java:753)
>        at org.postgresql.jdbc4.AbstractJdbc4Statement.setBlob(AbstractJdbc4Statement.java:164)
>        at com.basistech.jdd.sql.JDDDao$1.doInPreparedStatement(JDDDao.java:198)
>        at com.basistech.jdd.sql.JDDDao$1.doInPreparedStatement(JDDDao.java:1)
>        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
>        ... 28 more
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>