CLOB issue with JDBC, IBATIS and Oracle 10g

[kartechy]

Hi,

I have some JAVA code to make connection and insert some data into
Oracle 10g via Ibatis framework, its failing for CLOB data type, Can
you please help me to resolve this ?

see the JAVA code flow below

FileA.java
-------------

SqlMapClient sqlMap = SQLConfig.getSqlMapInstance(); // this sqlconfig
xml contains all the login details..
sqlMap.StartTransaction();
FileB_Object.setExampleText(myStringBuffer.toString()); // this file
contains get/set methods
sqlMap.insert("insertExampleText", FileB_Object);
sqlMap.CommitTransaction();

FileB.java
-----------------
private String exampleText;
public String getExampleText() {
return exampleText;
}

public void setExampleText(String exampleText) {
this.exampleText =exampleText;
}
FileC.XML
----------------
which contains all the SQLs , Properties , reference to FileB.Class -
part of IBatis and I added the following line also.
<result property="exampleText" column="exampleText" jdbcType="BLOB"/>

The same code is working fine if the length is less than 4000 and
failed for more than 4000 chars

I am getting this error

com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in c:\temp\FileC.xml.
--- The error occurred while applying a parameter map.
--- Check the insertExampleText-InlineParameterMap.
--- Check the parameter mapping for the 'exampleText' property.
--- Cause: java.sql.SQLException: Data size bigger than max size for
this type: 7821
Caused by: java.sql.SQLException: Data size bigger than max size for
this type: 7821

After this error I tried to change the "exampleText" as java.sql.CLOB
in all the places - but its again failed and getting the same error

Any help would be great

Thanks

Kart.

 

[RedGrittyBrick]

Hi,

I have some JAVA code to make connection and insert some data into
Oracle 10g via Ibatis framework, its failing for CLOB data type, Can
you please help me to resolve this ?

Multiposted
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html