ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From joson yu <yuqian...@gmail.com>
Subject db2 -302 error
Date Tue, 23 Mar 2010 02:09:46 GMT
there is an error happend in my situation.and want to know is there anyone
else meet this problem.
i use  ibatis2.  the database is used  db2.
sql: select [columns] from  tables where column1 = ''.
and the column1 is varchar type and it's length is 30.
the sql is execute fine in the db2 client. but when i use ibatis to execute
it .it throw exception ,blow is all exception info.






org.springframework.dao.DataIntegrityViolationException: SqlMapClient
operation; SQL [];
--- The error occurred in
com/hcss/fy/business/resource/ccr/model/HCSS_CCR_INFO_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the load_inheritor_baseinfo-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.ibm.db2.jcc.a.jm: DB2 SQL Error: SQLCODE=-302,
SQLSTATE=22001, SQLERRMC=null, DRIVER=3.50.151; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
com/hcss/fy/business/resource/ccr/model/HCSS_CCR_INFO_SqlMap.xml.
--- The error occurred while applying a parameter map.
--- Check the load_inheritor_baseinfo-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.ibm.db2.jcc.a.jm: DB2 SQL Error: SQLCODE=-302,
SQLSTATE=22001, SQLERRMC=null, DRIVER=3.50.151
    at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:114)
    at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
    at
org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
    at
org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
    at
com.hcss.fy.business.resource.ccr.dao.impl.InheritorDaoImpl.loadInheritor(InheritorDaoImpl.java:48)
    at
com.hcss.fy.business.resource.ccr.dao.InheritorDaoTest.loadInheritor(InheritorDaoTest.java:57)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at
org.springframework.test.context.junit4.SpringTestMethod.invoke(SpringTestMethod.java:160)
    at
org.springframework.test.context.junit4.SpringMethodRoadie.runTestMethod(SpringMethodRoadie.java:233)
    at
org.springframework.test.context.junit4.SpringMethodRoadie$RunBeforesThenTestThenAfters.run(SpringMethodRoadie.java:333)
    at
org.springframework.test.context.junit4.SpringMethodRoadie.runWithRepetitions(SpringMethodRoadie.java:217)
    at
org.springframework.test.context.junit4.SpringMethodRoadie.runTest(SpringMethodRoadie.java:197)
    at
org.springframework.test.context.junit4.SpringMethodRoadie.run(SpringMethodRoadie.java:143)
    at
org.springframework.test.context.junit4.SpringJUnit4ClassRunner.invokeTestMethod(SpringJUnit4ClassRunner.java:160)
    at
org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:59)
    at
org.junit.internal.runners.JUnit4ClassRunner$1.run(JUnit4ClassRunner.java:52)
    at
org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:34)
    at
org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:44)

Mime
View raw message