Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01461: with spring ibatis on Oracle11g

908707Jan 3 2012 — edited Jan 9 2012
Happy 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2012
Added on Jan 3 2012
6 comments
2,229 views