mybatis: Using mapper interfaces with XML config for global parameters

Question

I like the XML notation for specifying global parameters such as connection strings. I also like Mapper annotations. When I try to combine the two, I get this exception.

Is there a way to combine the two? I would like to use an XML file for the global configurations, but have mybatis take Mapper interfaces into account.

The problem is that SqlSessionFactoryBuilder().build() takes either a Reader (which I want to use to pass the XML config), or a Configuration object (which I see has the addMappers() method that can help me) - but I don't understand how to combine the two.

I'd really like to know this! Adding the mapper Interfaces by hand isn't a suitable solution. How can we configure mappers in XML and using MapperInterfaces together without adding them by hand? — Chris
– Chris, Commented May 4, 2011 at 11:47

Dariusz · Accepted Answer · 2015-09-14 12:41:12Z

12

factory.getConfiguration().addMapper(...);

edited Sep 14, 2015 at 12:41

Dariusz

22.5k9 gold badges82 silver badges116 bronze badges

answered Jan 6, 2011 at 14:38

Atilio Ranzuglia

1361 silver badge3 bronze badges

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

Comments

Achow · Accepted Answer · 2012-03-22 04:39:47Z

6

When u create the mapper interface with the abstract methods having the exact method signature as the sql in the xml.

For eg. This was the namespace for the dao.xml which contained the actual query.

<mapper namespace=" com.mybatis.dao.EntityMapperInterface">
    <select id="selectEmployeeWithId" parameterType="Long"
        resultType="com.mybatis.domain.Employee">
        select id,name from employee where 1=1
        <if test="_parameter != null"> 
            AND id=#{id} 
        </if>
        order by id
    </select>

It will be mapped in the interface com.mybatis.dao.EntityMapperInterface

public interface EntityMapperInterface {
    public List<Employee> selectEmployeeWithId(Long id);

Mybatis-config file

<mappers>
    <mapper resource="com/mybatis/mappers/EntityMapper.xml" />
</mappers>

How do u call it from the Action class/Servlet? When u have the SqlSession initialized,

EntityMapperInterface emi = session.getMapper(EntityMapperInterface.class);
List eList = emi.selectEmployeeWithId(1);

answered Mar 22, 2012 at 4:39

Achow

8,6886 gold badges41 silver badges49 bronze badges

1 Comment

erickson Over a year ago

Where is this mentioned in the documentation?

quentinLi · Accepted Answer · 2022-10-01 03:43:51Z

1

Thanks, It helps me a lot. I use no XML config mybatis with spring. Here's what I do:

SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
Configuration configuration = new Configuration();
configuration.addMapper(AccountMapper.class);
factoryBean.setConfiguration(configuration);
return factoryBean.getObject();

answered Oct 1, 2022 at 3:43

quentinLi

112 bronze badges

Comments

Anoop Isaac · Accepted Answer · 2011-12-13 20:15:10Z

0

I had the same issue and was because the name space in mybatis mapper file and the package of the mapper interface were not matching.

answered Dec 13, 2011 at 20:15

Anoop Isaac

94212 silver badges15 bronze badges

Collectives™ on Stack Overflow

mybatis: Using mapper interfaces with XML config for global parameters

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related