This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Getting MEAN with Mongo, Express, Angular, and Node and have Simon Holmes on-line!
See this thread for details.
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

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