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: use..ayenne.apache.org
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)
This archive was generated by hypermail 2.0.0 : Tue Jul 08 2008 - 21:50:40 EDT