Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <25288763.post@talk.nabble.com>
Date: Thu, 3 Sep 2009 23:03:38 -0700 (PDT)
From: adi203793 <aditya.prajapati@tcs.com>
To: user-java@ibatis.apache.org
Subject: Ibatis conversion error on DB2
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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