Mybatis error : The error occurred while setting parameters

mybatis

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.UnsupportedOperationException
### The error may exist in kr/co/techinmotion/mybatis/mappers/dataOutputMapper.xml
### The error may involve kr.co.techinmotion.mybatis.mappers.dataOutputMapper.selectData1-Inline
### The error occurred while setting parameters
### SQL: select * from tbl_id, tbl_feed     where tbl_id.id = tbl_feed.upid     and tbl_id.token = ?
### Cause: java.lang.UnsupportedOperationException
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
at kr.co.techinmotion.daoImpl.DataDaoImplMybatis.selectData1(DataDaoImplMybatis.java:47)

I don't know why this error occurred.

This is my sql in mapper.

<select id="selectData1" parameterType="string" resultType="list">
    select * from tbl_id, tbl_feed  
    where tbl_id.id = tbl_feed.upid  
    and tbl_id.token = #{token}
</select>

and.. this is DAO.

public class DataDaoImplMybatis implements IdataDao {

    private DataDaoImplMybatis(){}

    private static DataDaoImplMybatis dao;

    public static DataDaoImplMybatis getInstance(){
        if(dao == null){
            dao = new DataDaoImplMybatis();
        }

        return dao;
    }

    SqlSessionFactory sessionFactory = SqlMapSessionFactory.getSqlSessionFactory();

    @Override
    public List<DataResult1> selectData1(String token){
        SqlSession session = sessionFactory.openSession();
        List<DataResult1> list = session.selectList("kr.co.techinmotion.mybatis.mappers.dataOutputMapper.selectData1", token);
        session.close();

        return list;
    }

}

please help me.. T_T

Best Answer

The "MyBatis-3-User-Guide" says: resultType: The fully qualified class name or alias for the expected type that will be returned from this statement. Note that in the case of collections, this should be the type that the collection contains, not the type of the collection itself. Use resultType OR resultMap, not both.

Related Topic