ps:in the sql the parameter should passed in with String that is longger than 30.
2010/3/23 joson yu <yuqian...@gmail.com> > 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) >
