Hi Mario, Thanks for the reply. The OS name i5/AS400. One more thing value which I have inserted is perfectly fine. As I mentioned sometimes it failed but most of the times it worked. Please help me out!!!!
Mario Briggs wrote: > > Nothing to do with ibatis. Look up the error definitions of SQLStates > SQL302 & SQL406 and you will understand why it occurs arbitarily :-) > > The value that is trying to be inserted in out-of-range for the column in > the db. > > Mario > > > > > adi203793 > <aditya.prajapati > @tcs.com> To > user-java@ibatis.apache.org > 04/09/2009 11:33 cc > > Subject > Please respond to Ibatis conversion error on DB2 > user-j...@ibatis. > apache.org > > > > > > > > > > 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 > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org > For additional commands, e-mail: user-java-h...@ibatis.apache.org > > > -- View this message in context: http://www.nabble.com/Ibatis-conversion-error-on-DB2-tp25288763p25290403.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
