File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "BLOB column storage issue" Watch "BLOB column storage issue" New topic
Author

BLOB column storage issue

Gopikrishna Kunisetty
Ranch Hand

Joined: Jun 12, 2008
Posts: 35
Hi,

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:

com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@68f4808e
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.executeCreate(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.CBNotExistState.ejbCreate(Unknown Source)
at com.ibm.ws.ejbpersistence.beanextensions.ConcreteBeanStatefulInstanceExtensionImpl.ejbPostCreate(Unknown Source)

Caused by: java.sql.SQLException: Cannot bind stream to a ScrollableResultSet or UpdatableResultSet
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
at oracle.jdbc.driver.OraclePreparedStatement.setBinaryStreamInternal(OraclePreparedStatement.java:9705)
at oracle.jdbc.driver.OraclePreparedStatement.setBinaryStream(OraclePreparedStatement.java:9687)
at com.nytimes.adtimespro.business.ejb.entity.workorder.websphere_deploy.ORACLE_V8_1.BlobTableBeanFunctionSet_578a1a3e.Create(BlobTableBeanFunctionSet_578a1a3e.java:40)
at com.nytimes.adtimespro.business.ejb.entity.workorder.websphere_deploy.ORACLE_V8_1.BlobTableBeanFunctionSet_578a1a3e.execute(BlobTableBeanFunctionSet_578a1a3e.java:271)
at com.ibm.ws.rsadapter.cci.WSInteractionImpl.execute(WSInteractionImpl.java:417)
at com.ibm.ws.rsadapter.cci.WSRelationalRAAdapter.executeCreate(WSRelationalRAAdapter.java:130)
... 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: http://aspose.com/file-tools
 
subject: BLOB column storage issue