CLOB issue with JDBC, IBATIS and Oracle 10g
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.