[Opensource] Trouble with CLOB field when Writing/Reading data size > 4000

[Jennifer Chen]

Hi Everyone,

I got the following Exception when inserting/updating
a CLOB field with data size greater than 4000
characters. The framework works fine when the data
size is smaller. 

I also tried the LOBSupport class as an alternative
that running without the exception but the data did
not get into the database and I got other failures
that I cannot explain.

We are using Expresso framework 503 with Weblogic 7
SP2 and Oracle9i. The data type mapping in
expresso-config.xml is:

<type-mapping>
      <java-type>CLOB</java-type>
      <db-type>CLOB</db-type>
</type-mapping>

Any suggestions or solutions are welcome:-)

Thanks

-Jennifer


ConfigManager: Reading XML config
ConfigManager: Done reading XML config - no errors or
warnings
ConfigMLoading Messagebundle:
com.jcorporate.expresso.core.ExpressoSchema
Loading MeConfigManager: Expresso initialization
complete
java.sql.SQLException: Data size bigger than max size
for this type: 4434
        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at
oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:147)
        at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.jav
a:2461)
        at
oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStat
ement.java:1155)
        at
oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedSt
atement.java:1572)
        at
com.jcorporate.expresso.core.dataobjects.jdbc.JDBCExecutor.update(JDB
CExecutor.java:505)
        at
com.jcorporate.expresso.core.dbobj.DBObject.update(DBObject.java:7145
)
        at
com.jcorporate.expresso.core.dbobj.SecuredDBObject.update(SecuredDBOb
ject.java:747)
        at
company.myappl.dbservice.BaseDBSrvc.update(BaseDBSrvc.java:125
)
        at
company.myappl.dbservice.EmConfigSrvc.update(EmConfigSrvc.java
:355)
        at
company.myappl.dbservice.EmConfigSrvc.saveBean(EmConfigSrvc.ja
va:210)
        at
company.myappl.dbservice.EmConfigSrvc.saveBean(EmConfigSrvc.ja
va:157)
        at
company.myappl.dbservice.EmConfigSrvc.propulateTable(EmConfigS
rvc.java:455)
        at
company.myappl.dbservice.EmConfigSrvc.initSystem(EmConfigSrvc.
java:695)
        at
company.myappl.servlet.SystemInitServlet.emConfigInit(SystemIn
itServlet.java:103)
        at
company.myappl.servlet.SystemInitServlet.init(SystemInitServle
t.java:58)
        at
weblogic.servlet.internal.ServletStubImpl$ServletInitAction.run(Servl
etStubImpl.java:1075)
        at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic
eManager.java:780)
        at
weblogic.servlet.internal.ServletStubImpl.createServlet(ServletStubIm
pl.java:899)
        at
weblogic.servlet.internal.ServletStubImpl.createInstances(ServletStub
Impl.java:833)
        at
weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubI
mpl.java:773)
        at
weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppS
ervletContext.java:2782)
        at
weblogic.servlet.internal.WebAppServletContext.preloadServlets(WebApp
ServletContext.java:2727)
        at
weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAp
pServletContext.java:2700)
        at
weblogic.servlet.internal.HttpServer.preloadResources(HttpServer.java
:563)
        at
weblogic.servlet.internal.WebService.preloadResources(WebService.java
:476)
        at
weblogic.t3.srvr.ServletInitRunner$1.run(ServletInitRunner.java:50)
        at
weblogic.security.service.SecurityServiceManager.runAs(SecurityServic
eManager.java:780)
        at
weblogic.t3.srvr.ServletInitRunner.run(ServletInitRunner.java:46)
        at java.lang.Thread.run(Thread.java:479)
com.jcorporate.expresso.core.dataobjects.DataException:
Error setting character
stream for field: config_specs with value:
[Configuration File Version 1.0]#**** ...]
.
.
.


__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com