Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

java.sql.SQLException: Data size bigger than max size for this type : 34500

 
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,

I seek your immediate help.
My project is based on J2EE1.3 specification, it uses Oracle 9i as back end, The JDK version is 1.3 (local) and 1.4 (on application server)

We have a functionality that calls an oracle stored proc and passes a big xml string into that. The destination data type defined in proc is CLOB and from front end we use
CallableStatement.setAsciiStream(1,ByteArrayInputStream,length) to set the value.

Recently, we enhanced the functionality and The length of the input xml string gets increased (crosses 32K) in some scenario.
When the length is greater than 32K, we are getting following exception:

java.sql.SQLException: Data size bigger than max size for this type
For all other instances when the length is less than 32K, The functionality works fine without an issue.

we use Oracle thin driver version 9.0.2.0.

Please let us know your thoughts asap. Your suggestion/advise would be a great help to me.

Thanks & Regards
Abhishek Khandelwal

 
Ranch Hand
Posts: 423
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
maybe is this:

http://publib.boulder.ibm.com/infocenter/wasinfo/v4r0/index.jsp?topic=/com.ibm.support.was40.doc/html/DB_Connections_Connection_Pooling/swg21145818.html wrote:
java.sql.SQLException: Data size bigger than max size for this type: 1188
Technote (FAQ)

Problem
After upgrading the Oracle repository database from 8i to 9i, the administrative server fails to start and the following message appears in the tracefile:

ExceptionUtil X CNTR0021E: Non-application exception occurred on bean BeanId
(admin#nssrcm.jar#Binding, BindingKey(domain,a8f5d6d8-00f1-e758-d2e3-83013c7baa77)):
java.rmi.RemoteException: ; nested exception is:
java.sql.SQLException: Data size bigger than max size for this type: 1188

Cause
This error is caused by incompatible Oracle ODBC driver files on the database server machine.

Solution
Make sure that you have the Oracle ODBC driver version that matches the database server version you are running on the server machine.

 
I do some of my very best work in water. Like this tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic