ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From adi203793 <aditya.prajap...@tcs.com>
Subject Re: Ibatis conversion error on DB2
Date Fri, 04 Sep 2009 12:50:36 GMT

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-java@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-java@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-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message