| 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
|
 |
 |
|
|
subject: BLOB column storage issue
|
|
|