ibaits

Question

org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];   
--- The error occurred in com/all/xml/user.xml.  
--- The error occurred while preparing the mapped statement for execution.  
--- Check the bloguser.selectUserByaddress.  
--- Cause: java.sql.SQLException: Invalid parameter object type.  Expected 'java.lang.String' but found '[Ljava.lang.String;'.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/all/xml/user.xml.  
--- The error occurred while preparing the mapped statement for execution.  
--- Check the bloguser.selectUserByaddress.  
--- Cause: java.sql.SQLException: Invalid parameter object type.  Expected 'java.lang.String' but found '[Ljava.lang.String;'.
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:271)
at com.blog.user.dao.impl.RegistDaoUserImpl.selectUserByAddress(RegistDaoUserImpl.java:17)
at com.blog.junit.JunitBlogUser.testBlogUser(JunitBlogUser.java:15)
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:585)
at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99)
at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75)
at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45)
at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66)
at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35)
at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42)
at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34)
at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/all/xml/user.xml.  
--- The error occurred while preparing the mapped statement for execution.  
--- Check the bloguser.selectUserByaddress.  
--- Cause: java.sql.SQLException: Invalid parameter object type.  Expected 'java.lang.String' but found '[Ljava.lang.String;'.
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
at org.springframework.orm.ibatis.SqlMapClientTemplate$1.doInSqlMapClient(SqlMapClientTemplate.java:273)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209)
... 23 more
Caused by: java.sql.SQLException: Invalid parameter object type.  Expected 'java.lang.String' but found '[Ljava.lang.String;'.
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.validateParameter(MappedStatement.java:245)
at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:167)
... 29 more<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="bloguser">
<typeAlias alias="user" type="com.blog.user.domain.User"/> <select id="selectUserByaddress" parameterClass="java.lang.String" resultClass="user">
select *
from blogUser
where emailaddress=#emailaddress#
</select>
</sqlMap>找不到错在哪里了，求高手回答！！  再线等！

Answer 1

你定义的数据类型出错了， 你看看配置文件里面的
xml/user.xml
'java.lang.String' 你写成这个了
[Ljava.lang.String;

Answer 2

select *
这样是不行的,你查出来的字段不能和User中的字段对应
例如 数据库里的字段为USER_NAME而User类中叫userName;
<select id="selectUserByaddress" parameterClass="java.lang.String" resultClass="user">
select USER_NAME as userName
from blogUser
where emailaddress=#emailaddress#
</select> 

Answer 3

不是这样的，我的错是低级的，正确的是sqlMapClientTemplate.queryForObject("bloguser.selectUserByaddress",address) != null ? true:false;而我原来参数写成了new String[]{address}.当然类型匹配错误。哎！ 低级啊，脑袋进水了那时侯我。