when i try to save xml content (which is more than 4k characters)as text in XMLTYPE column, am getting below error:
org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into SHV_TRC_SHMT_AUD_DTLS (XML_MSG_TEXT, STAT_TYPE, MSG_TYPE, STAT_DESC_TEXT, CRTN_DT, LAST_UPTD_DT, HBNT_VRSN_NBR, SHMT_AUD_DTL_ID) values (?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; Could not execute JDBC batch update; nested exception is org.hibernate.QueryTimeoutException: Could not execute JDBC batch update Caused by: org.hibernate.QueryTimeoutException: Could not execute JDBC batch update Caused by: java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column
Am using oracle.version 11.2.0.1.0, hibernate :3.6.
If i save xml which is of less than 4k then it is working fine, for xml content more than 4k, its giving this issue.
Any work around for this issue.
|