6 Replies Latest reply on Sep 10, 2002 11:52 AM by Gaetan

    Problem with Oracle8 Blobs

    David Baillieul Newbie

      I have set up an Oracle8 datasource by modifying an existing Hypersonic configuration. My entity EJBs retrieve data fine from most tables until I hit a BLOB column, in which I get:

      2002-08-26 21:02:36,520 DEBUG [com.zaplet.server.process.ProcessBean] setEntityContext
      2002-08-26 21:02:36,520 DEBUG [com.zaplet.server.process.ProcessBean] ejbActivate
      2002-08-26 21:02:36,520 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Process] Executing SQL: SELECT VERSION, DEFINITIONID, NAME, TITLE, CREATORID, OWNERID, CREATEDDATE, MODIFIERID, MODIFIEDDATE, STARTEDDATE, COMPLETEDDATE, STATE, SECURITYLEVEL, DATA FROM PROCESS WHERE (PROCESSID=?)
      2002-08-26 21:02:36,560 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException, causedBy:
      java.sql.SQLException: Unable to load to deserialize result: java.io.StreamCorruptedException: invalid stream header
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.convertByteArrayToObject(JDBCUtil.java:612)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.getResult(JDBCUtil.java:311)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadArgumentResults(JDBCAbstractCMPFieldBridge.java:350)
      at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.loadInstanceResults(JDBCAbstractCMPFieldBridge.java:304)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:142)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEntityCommand.java:62)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadEntity(JDBCStoreManager.java:572)


      The process table contains a BLOB. I have fiddled with the standardjaws.xml file to try to get around this error, but have had no luck. Ideas????