--
-- SqlMapConfig.xml
--
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <environments default="default">
        <environment id="default">
            <transactionManager type="MANAGED"/>
            <dataSource type="POOLED">
                <property name="driver"   value="stuff"/>
                <property name="url"      value="stuff"/>
                <property name="username" value="stuff"/>
                <property name="password" value="stuff"/>
                <property name="poolMaximumActiveConnections" value="2"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <!-- Doesn't work when I package my app as a single JAR. -->
        <package name="testmy.sqlmaps" />
        
        <!-- Works even when mapper files are in a JAR file. -->
        <!--
        <mapper class="testmy.sqlmaps.TestMyMapper" />
        -->
    </mappers>
</configuration>

--
-- TestMyMapper.xml
--

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="testmy.sqlmaps.TestMyMapper">
    <select id="testMyBatisQuery" resultType="string">
        SELECT 'Testing'
          FROM SYSIBM.SYSDUMMY1
    </select>
</mapper>

--
-- TestMyMapper.java
--

package testmy.sqlmaps;

public interface TestMyMapper {
    public String testMyBatisQuery();
}

--
-- RunTest.java
--

package testmy;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.session.TransactionIsolationLevel;
import testmy.sqlmaps.TestMyMapper;

public class RunTest {
	public static void main(String[] args) throws Exception {
		try(SqlSession session = new SqlSessionFactoryBuilder()
				.build(Resources.getResourceAsReader("testmy/sqlmaps/SqlMapConfig.xml"))
				.openSession(TransactionIsolationLevel.NONE)
		) {
			System.out.println(session.getMapper(TestMyMapper.class).testMyBatisQuery());
		}
	}
}

--
-- RunTest.bat file
--

@echo off
CD C:/test/testMyBatisBatch

:: Jar deployement blows up
::SET CPATH="MybatisCommandLine.jar"

:: exploded deployment works
SET CPATH="."

FOR /R ./lib %%a in (*.jar) DO CALL :AddToPath %%a

:: echo %CPATH%

java -cp %CPATH% testmy.RunTest

:AddToPath
SET CPATH=%1;%CPATH%
GOTO :EOF