No, It's not like that,When the sql query failed. I have tried with same parameter and It worked properly. As I mentioned earlier I am not able to replicate it. This was the first and last time query failed while updating and same case while inserting a record.Next time it inserted properly. These are the only 2 intanse when code crashed in past 1.5 year. We have rollout on very next week. Please suggest me. Thanks.
Mario Briggs wrote: > > when it succeeds it means u inserted a value which was in the range. When > it fails, u or user was try to insert a value that was not in the required > range. > > > > > adi203793 > <aditya.prajapati > @tcs.com> To > user-java@ibatis.apache.org > 04/09/2009 14:10 cc > > Subject > Please respond to Re: Ibatis conversion error on DB2 > user-j...@ibatis. > apache.org > > > > > > > > > > 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 > > > > > --------------------------------------------------------------------- > 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-tp25288763p25293765.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
