How do I create MyBatis SqlSession object?

To create an SqlSession you can use the SqlSessionFactory class openSession() method. This method offers some overloaded method with can configure the property of the session. For example the auto commit mode and the transaction isolation level for the session.

package org.kodejava.example.mybatis;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.kodejava.example.mybatis.domain.Record;


public class SqlSessionDemo {
    public static void main(String[] args) throws IOException {
        SqlSessionDemo demo = new SqlSessionDemo();
        // Build an SqlSessionFactory.
        SqlSessionFactory factory = demo.getSessionFactory();
        // Create an SqlSession by using the factory.openSession() method.
        // It is a good practice to use a try-finally block when working
        // with an SqlSession where you can close the session in the 
        // finally block when it finishes the job.
        SqlSession session = factory.openSession();
        try {
            Record record = (Record) session.selectOne("getRecord", 1);
            System.out.println("Record = " + record);
        } finally {

     * Build an SqlSessionFactory.
     * @return an SqlSessionFactory.
     * @throws IOException when fail to read the configuration file.
    public SqlSessionFactory getSessionFactory() throws IOException {
        String res = "org/kodejava/example/mybatis/Configuration.xml";
        Reader reader = Resources.getResourceAsReader(res);

        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();

Wayan Saryada

Programmer, runner, recreational diver, currently living in the island of Bali, Indonesia. Mostly programming in Java, creating web based application with Spring Framework, Hibernate / JPA.

Leave a Reply