java无效的列索引,mybatis jdbc select查询不工作引发无效的列索引

我在Mybatis第3版中有以下问题。请帮助我查找此问题。

Java代码:

@Select("SELECT A.PERSON_ID,A.PERSON_ADDRESS, C.CUSTOMER_NAME," +

" B.CUSTOMER_DOB," +

" FROM PERSON A, CUSTOMER B, CUSTOMER_DETAILS C" +

" WHERE A.CUSTOMER_ID=C.CUSTOMER_ID" +

" AND A.CUSTOMER_ID=B.CUSTOMER_ID (+)" +

" AND C.PERSON_NAME='#{personName, jdbcType=VARCHAR, mode=IN, javaType=String}'" +

" AND C.CUSTOMER_ID='#{customerID, jdbcType=VARCHAR, mode=IN, javaType=String}'")

@Results(value = {

@Result(property = "personId", column = "PERSON_ID"),

@Result(property = "personAddress", column = "PERSON_ADDRESS"),

@Result(property = "customerName", column = "CUSTOMER_NAME"),

@Result(property = "customerDOB", column = "CUSTOMER_DOB")

})

List getPersonCustomerByID(@Param("personName") String personName,@Param("customerID") String customerID);

异常跟踪:

nested exception is org.apache.ibatis.type.TypeException:

Could not set parameters for mapping: ParameterMapping{property='personName', mode=IN, javaType=class java.lang.String, jdbcType=VARCHAR,

numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}.

Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType VARCHAR .

Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Invalid column index