File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes BLOB column storage issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "BLOB column storage issue" Watch "BLOB column storage issue" New topic

BLOB column storage issue

Gopikrishna Kunisetty
Ranch Hand

Joined: Jun 12, 2008
Posts: 35

I'm getting exception whenever I try to insert data into a BLOB column. When the data size is less than 4KB it is going fine, but when it is more than 4KB. It is failing.
I'm using WSAD 5.1, Oracle 10g , Java 1.4.
Here is the exception: PMGR6022E: Error using adapter to create or execute an Interaction.
at Source)
at Source)
at Source)
at Source)

Caused by: java.sql.SQLException: Cannot bind stream to a ScrollableResultSet or UpdatableResultSet
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.OraclePreparedStatement.setBinaryStreamInternal(
at oracle.jdbc.driver.OraclePreparedStatement.setBinaryStream(
... 41 more

Does any body has an idea about this issues? please share your experiences.

- Krishna<br /> SCJP 1.4 SCWCD 5
I agree. Here's the link:
subject: BLOB column storage issue