aspose file tools*
The moose likes JDBC and the fly likes java.sql.SQLException: Data size bigger than max size for this type : 34500 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Data size bigger than max size for this type : 34500" Watch "java.sql.SQLException: Data size bigger than max size for this type : 34500" New topic
Author

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

abhishek khandelwal
Greenhorn

Joined: Apr 17, 2007
Posts: 11
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


Abhishek Khandelwal
SCPJ1.4, SCWCD1.4
Leandro Coutinho
Ranch Hand

Joined: Mar 04, 2009
Posts: 417
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 agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Data size bigger than max size for this type : 34500