Hi Again, Little correction to my previous post. I get that exception regardless of what the content is in that CLOB field. My apologies.
Regards, parth -----Original Message----- From: Parth Pandya Sent: Wednesday, 9 July 2008 11:14 AM To: [email protected] Subject: java.io.StreamCorruptedException on oracle (CLOB problem) Hi Guys, I'm on weblogic-oracle combination and while trying to run a named query (listed below) I'm getting java.io.StreamCorruptedException(stack trace provided below). The sql is correct and I get results back when I run it in sql tools. The field types in 'submission' table have few varchar2, number, timespamp fields AND one CLOB type of field. I'm using Cayenne 3.0. And I'm using oracle thin driver for oracle 10g. It looks like some CLOB related read problem to me. I cleared the contents of that CLOB field and I didn't get any exceptions. But as soon as I ran the query on the record with some data in CLOB field I see the below exception. Can someone please suggest what can be the solution so reading CLOB contents happen properly? Thanks a lot, Parth Content of Named Query: SELECT s.* FROM submission s WHERE submission_oid IN (SELECT DISTINCT submission_oid FROM submission_version WHERE submission_status = 'submitted' AND assigned_user = 240) ORDER BY s.modification_timestamp DESC Exception: java.io.StreamCorruptedException: invalid stream header at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:764) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:277) at org.apache.cayenne.access.types.SerializableTypeFactory$SerializableType .toJavaObject(SerializableTypeFactory.java:113) at org.apache.cayenne.access.types.ExtendedTypeDecorator.materializeObject( ExtendedTypeDecorator.java:54) at org.apache.cayenne.access.jdbc.JDBCResultIterator.readDataRow(JDBCResult Iterator.java:296) at org.apache.cayenne.access.jdbc.JDBCResultIterator.nextDataRow(JDBCResult Iterator.java:142) at org.apache.cayenne.access.jdbc.JDBCResultIterator.dataRows(JDBCResultIte rator.java:112) at org.apache.cayenne.access.jdbc.SQLTemplateAction.processSelectResult(SQL TemplateAction.java:231) at org.apache.cayenne.dba.oracle.OracleSQLTemplateAction.processSelectResul t(OracleSQLTemplateAction.java:83) at org.apache.cayenne.access.jdbc.SQLTemplateAction.execute(SQLTemplateActi on.java:171) at org.apache.cayenne.access.jdbc.SQLTemplateAction.performAction(SQLTempla teAction.java:127) at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryActi on.java:58) at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:230) at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQuery Action.java:424) at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQue ryAction.java:68) at org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQu eryAction.java:397) at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:84 7) at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(Da taDomainQueryAction.java:394) at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryA ction.java:120) at org.apache.cayenne.access.DataDomain.onQuery(DataDomain.java:740) at org.apache.cayenne.util.ObjectContextQueryAction.runQuery(ObjectContextQ ueryAction.java:317) at org.apache.cayenne.util.ObjectContextQueryAction.execute(ObjectContextQu eryAction.java:96) at org.apache.cayenne.access.DataContext.onQuery(DataContext.java:1336) at org.apache.cayenne.access.DataContext.performQuery(DataContext.java:1325 ) at com.avoka.fcl.cayenne.CayenneTemplate.performQuery(CayenneTemplate.java: 233) at com.avoka.fcl.dao.SubmissionDao.getParticipatedInSubmissions(SubmissionD ao.java:100) at com.avoka.fcl.page.admin.SubmissionsPage.onInit(SubmissionsPage.java:43) at net.sf.click.ClickServlet.processPage(ClickServlet.java:497) at net.sf.click.ClickServlet.handleRequest(ClickServlet.java:327) at net.sf.click.ClickServlet.doGet(ClickServlet.java:250) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(St ubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityH elper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:2 83) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
