This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

BLOB column storage issue

 
Gopikrishna Kunisetty
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic