Mybatis error : The error occurred while setting parameters

Question

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

Wil · Accepted Answer · 2016-04-06 06:37:21Z

2

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.

answered Apr 6, 2016 at 6:37

Wil

213 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hailin Tan · Accepted Answer · 2018-10-05 02:03:06Z

1

In my case was that added 'useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true' in jdbc.url, that solved my issue:)

jdbc.url=jdbc:mysql://127.0.0.1:3306/xxx?useUnicode=true&characterEncoding=utf8&autoReconnect=true&allowMultiQueries=true

answered Oct 5, 2018 at 2:03

Hailin Tan

1,15910 silver badges7 bronze badges

Comments

Ian Lim · Accepted Answer · 2013-10-25 01:39:35Z

0

The resultType SHOULD NOT be list, the below shows the revised type, but you have to make sure the select statement can map to DataResult1 accordingly

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

alternatively, you may try this:

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

and the changes to the java source code

List<Map<String,Object> list = session.selectList("kr.co.techinmotion.mybatis.mappers.dataOutputMapper.selectData1", token);

answered Oct 25, 2013 at 1:39

Ian Lim

4,2943 gold badges34 silver badges44 bronze badges

1 Comment

LinuxLars Over a year ago

And NEVER use select * in production - you are guaranteeing a future failure.

p.s.w.g · Accepted Answer · 2013-12-23 07:13:05Z

0

1 floor is right, but I want to say resultType = "" respect a row in your database but not all, perhaps you may select count(user_id) from user, now your resultType = 'long', if you select more than two results, you may use resultType = 'map' or yourself map, resultType = 'yourselfMap'

edited Dec 23, 2013 at 7:13

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges

answered Dec 23, 2013 at 6:55

mousycoder

1

Comments

Izuka · Accepted Answer · 2017-03-02 12:13:03Z

0

You have to declare the "jdbcType=VARCHAR" or "jdbcType=NUMERIC" of the variable depending upon the type of variable passed in order to pass the null value. Try using this:

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

edited Mar 2, 2017 at 12:13

Izuka

2,5925 gold badges33 silver badges37 bronze badges

answered Mar 2, 2017 at 10:15

Aamir Iqubal

4273 silver badges11 bronze badges

Collectives™ on Stack Overflow

Mybatis error : The error occurred while setting parameters

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related