aspose file tools
The moose likes JDBC and the fly likes BLOB column storage issue Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: BLOB column storage issue
 
Similar Threads
java.sql.SQLException: Closed Statement
java.sql.SQLException: Io exception: Unknown host specified
SQLException Exhausted resultset
java.sql.SQLException: No more data to read from socket
java.sql.SQLException: Invalid column index