ORA-01461: with spring ibatis on Oracle11g
908707Jan 3 2012 — edited Jan 9 2012Happy new year to all,
I ran into a problem with XMLTYPE database column. In our application we have an async implementation where we store the Request and Response XMLs of a service. The problem here is, during insertion of XML data into the columns we see the below error. We use XMLTYPE columns for storing xmls and we use ibatis ORM with Spring. In sql map file we use java type of String.
The detailed error is : SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [72000]; error code [1461];
- The error occurred while applying a parameter map.
- Check the ASYC_T.ibatorgenerated_updateByPrimaryKeySelective-InlineParameterMap.
- Check the statement (update failed).
- Cause: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
- The error occurred while applying a parameter map.
- Check the ASYC_T.ibatorgenerated_updateByPrimaryKeySelective-InlineParameterMap.
- Check the statement (update failed).
- Cause: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
We observed that, this is happening only in case of huge xml, and the same is working well with small xmls.
Any help is much appreciated.
TIA --Praveen