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

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

Subscribe Post Reply

5622

amitpatel66

2,367

Expert 2GB

Please post your code for reference that you are trying to write to CLOB field

Nov 12 '08 #2

saravanaprabhu

use ojdbc14.jar for 9i

Nov 22 '10 #3

Similar topics

Error log empty

by: Wayno | last post by:

My php logs are coming up empty. I have done all I can think of, and all that made sense to me. Can someone take a look at my php.ini please and tell me what you think may be the problem. I...

PHP

bytea SQL ERROR with size

by: lionel pacoud | last post by:

Hi, ok, so I have pictures that I store in Postgres (7.2.4) via JDBC. if the size of my picture is small (less than 1ko) it's ok, there is no pb. but I never succed to put a bigger picture....

PostgreSQL Database

Suitable Driver Error

by: Luong Phan | last post by:

--0-342085162-1061547060=:86593 Content-Type: text/plain; charset=us-ascii Hi all, In my web application, I use mysql supported by Redhat Linux 7.3 to store database, jakarta-tomcat-3.2.4,...

MySQL Database

Strange JDBC error when retrieving data

by: FX NICOLAS | last post by:

Can anyone help me. I'm trying to retrieve data from DB2/AIX v8.1 using JDBC connectivity (Universal Driver - Type 4 - v1.1.67) . I get a recurrent error (after connection, apparently) : BEGIN...

DB2 Database

Error: Object doesn't support this property or method

by: Roman | last post by:

I'm trying to create the form which would allow data entry to the Client table, as well as modification and deletion of existing data rows. For some reason the DataGrid part of functionality stops...

ASP.NET

Error Updating SQL DB

by: Trez | last post by:

Hey guys, Am new at using ASP.Net. am having some problems updating my SQL DB. whenever i try i get this Error. Can someone help me? Incorrect syntax near 'nvarchar'. Description: An unhandled...

.NET Framework

Protocol violation, Bigger than maximum error

by: meru | last post by:

Hi The highlighted below is the sample code I used for calling my stored procedure. Callable statement cstmt = conn.prepareCall( BEGIN STOREDPROCNAME(?,?,?);END;); ArrayDescriptor...

Java

Http status 404 error in struts!!

by: ajos | last post by:

hi frnds, the situation is im developing a web application in struts-- my specifications-eclipse3.2.2,struts1.1,tomcat5.5.23 mysql5.0 db. the scenario-i have a jsp page which adds the...

Java

how i do fix this error

by: DUMAS64 | last post by:

Exception in thread "main" java.lang.NullPointerException at matchBeans.Results.entryMatchResults(Results.java:112) at matchBeans.Results.displayMenu(Results.java:51) at...

Java

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++