myBatis multi db vendor support

1. 최초 확인한곳..
http://code.google.com/p/mybatis/issues/detail?id=21&colspec=ID%20Type%20Component%20Status%20Priority%20Version%20Target%20Summary%20Reporter


2.  DTD 적용 확인,   http://mybatis.org/dtd/mybatis-3-mapper.dtd

3. 3.1.0 SNAPSHOT 다운로드 / http://code.google.com/p/mybatis/wiki/Downloads?tm=2

4. 사용법

public static SqlSessionFactory sqlMapper = MyBatisManager.getInstance();

System.out.println(  sqlMapper.getConfiguration().getDatabaseId() ); 

등으로 DatabaseId 확인...


testMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="testMapper">

<!-- DB2 용 -->

<select id="getUserId" resultType="HashMap" databaseId="DB2/AIX64">

SELECT * FROM DB2_TABLE

</select>

<!-- CUBRID 용-->

<select id="getUserId" resultType="HashMap" databaseId="CUBRID">

SELECT * FROM CUBRID_TABLE

</select>

<!-- databaseId가 정의가 안되었을시... -->

<select id="getUserId" resultType="HashMap">

SELECT * FROM ETC_TABLE

</select>
 

</mapper>

 

in Java...

list = session.selectList("testMapper.getUserId");
일상적으로 사용...