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
[email protected]
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
> [email protected]
> 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: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
--
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
