setBlob(InputStream) not supported?

From: Benson Margulies <bimargulies(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: setBlob(InputStream) not supported?
Date: 2011-09-28 11:34:49
Message-ID: CALhtWkdULaVhygihLX=dLQ0p7D4JY9Dk7JX795OoZv4d7zba3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Mikko Tiihonen 2011-09-28 18:42:58 Collection of small fixes to binary transfer code and unit tests
Previous Message Mike Fowler 2011-09-28 08:28:09 Re: Further Buildfarm Errors: Missing org.postgresql.util.PGBinaryObject