I have been using Ibatis through Spring to acccessing data from DB2 to java. I have been run this query so many times sometimes it works and sometimes not. 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 rg.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). -- View this message in context: http://www.nabble.com/Ibatis-conversion-error-on-DB2-tp25288763p25288763.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
