By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,978 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,978 IT Pros & Developers. It's quick & easy.

ERROR [STDERR] java.sql.SQLException: Data size bigger than max size forthis type: 40

P: 1
i am getting the following error while updating a clob field.

ERROR [STDERR] java.sql.SQLException: Data size bigger than max size forthis type: 4003
19:28:27,499 ERROR [STDERR] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:180)
19:28:27,499 ERROR [STDERR] at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:222)
19:28:27,499 ERROR [STDERR] at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java :126)
19:28:27,499 ERROR [STDERR] at
oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindIte m(DBDataSetImpl.java:1784)
19:28:27,499 ERROR [STDERR] at
oracle.jdbc.driver.OraclePreparedStatement.setItem (OraclePreparedStatement.java:874)
19:28:27,499 ERROR [STDERR] at
oracle.jdbc.driver.OraclePreparedStatement.setStri ng(OraclePreparedStatement.java:1256)
19:28:27,499 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.setString(WrappedPreparedStatement.java:316 )
19:28:27,499 ERROR [STDERR] at
com.arionsystems.utility.Database.executeParamUpda te(Database.java:463)
19:28:27,499 ERROR [STDERR] at
com.arionsystems.cms.dao._CMS_CONTENT_PRIMARY.save Data(_CMS_CONTENT_PRIMARY.java:1149)
19:28:27,499 ERROR [STDERR] at
com.arionsystems.cms.dao._CMS_CONTENT_PRIMARY.save (_CMS_CONTENT_PRIMARY.java:1170)
19:28:27,499 ERROR [STDERR] at
com.arionsystems.cms.action.admin.PageContentSaveA ction.execute(PageContentSaveAction.java:232)
19:28:27,499 ERROR [STDERR] at
org.apache.struts.chain.commands.servlet.ExecuteAc tion.execute(ExecuteAction.java:58)
19:28:27,499 ERROR [STDERR] at
org.apache.struts.chain.commands.AbstractExecuteAc tion.execute(AbstractExecuteAction.java:67)
19:28:27,499 ERROR [STDERR] at
org.apache.struts.chain.commands.ActionCommandBase .execute(ActionCommandBase.java:51)
19:28:27,499 ERROR [STDERR] at
org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:190)
19:28:27,499 ERROR [STDERR] at
org.apache.commons.chain.generic.LookupCommand.exe cute(LookupCommand.java:304)
19:28:27,499 ERROR [STDERR] at
org.apache.commons.chain.impl.ChainBase.execute(Ch ainBase.java:190)
19:28:27,499 ERROR [STDERR] at
org.apache.struts.chain.ComposableRequestProcessor .process(ComposableRequestProcessor.java:283)
19:28:27,499 ERROR [STDERR] at
org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1913)
19:28:27,499 ERROR [STDERR] at
org.apache.struts.action.ActionServlet.doPost(Acti onServlet.java:462)
19:28:27,499 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
19:28:27,499 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet .java:810)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
19:28:27,499 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doF ilter(ReplyHeaderFilter.java:96)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:202)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:178)
19:28:27,499 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationV alve.invoke(SecurityAssociationValve.java:175)
19:28:27,499 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.inv oke(JaccContextValve.java:74)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:126)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:105)
19:28:27,499 ERROR [STDERR] at
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve .invoke(CachedConnectionValve.java:156)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:107)
19:28:27,499 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148)
19:28:27,499 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
19:28:27,499 ERROR [STDERR] at
org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
19:28:27,499 ERROR [STDERR] at
org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
19:28:27,499 ERROR [STDERR] at
org.apache.tomcat.util.net.MasterSlaveWorkerThread .run(MasterSlaveWorkerThread.java:112)
19:28:27,499 ERROR [STDERR] at java.lang.Thread.run(Unknown Source)
19:28:27,499 INFO [STDOUT] RIns Debug: Mon Nov 10 19:28:27 GMT+05:30 2008: Error

I have replaced the latest odbc driver also. but it did not worked.
recently i have changed the version of Oracle from 8i to 9i.
Please help !
Nov 11 '08 #1
Share this Question
Share on Google+
2 Replies


amitpatel66
Expert 100+
P: 2,367
Please post your code for reference that you are trying to write to CLOB field
Nov 12 '08 #2

P: n/a
use ojdbc14.jar for 9i
Nov 22 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.