I have been using Ibatis through Spring to acccessing data from DB2 to java.
Since one and half year,I have never seen the problem which I am facing now a days.
which I have never received earlier.we have used this queries so many times
and after few minuts its working fine again,means I m not able to replicate it.
while updating the record I got the error like this:
UPDATE STHEDRL1 SET STHRIN=? WHERE STHINT=? AND STHNUM=? AND STHSCD=? AND STHADT=?
Types: [java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.Integer]
ERRORID :org.springframework.dao.DataIntegrityViolationExc eption
--EXCEPTION DETAILS--
Message : SqlMapClient operation; SQL [];
--- Cause: java.sql.SQLException: [SQL0302] Conversion error on host variable or parameter *N.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred while applying a parameter map.
--- Check the ShopDatesEntrySqlMap.updateRingForUltraInspectionR ecord-InlineParameterMap.
--- Check the statement (update failed).
Please send ur suggesstion.Thanks in advance.

and after few days again I got the error:which I have never received earlier.we have used this query so many times
and after few minuts its working fine again.Please send ur suggesstion.Thanks in advance.

Cause: java.sql.SQLException: [SQL0406] Conversion error on assignment to column TRNPTM.
at org.springframework.jdbc.support.SQLStateSQLExcept ionTranslator.translate(SQLStateSQLExceptionTransl ator.java:111)
at org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator.translate(SQLErrorCodeSQLExcepti onTranslator.java:322)
at org.springframework.orm.ibatis.SqlMapClientTemplat e.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplat e.insert(SqlMapClientTemplate.java:397)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLExceptio n:
--- The error occurred while applying a parameter map.
--- Check the PresentationData.insertCarMarkIntoMFCARCHG-InlineParameterMap.
--- Check the statement (update failed).