• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
abhishek khandelwal
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

 
Leandro Coutinho
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic