mybatis »ç¿ëÇÏ¿©
¿©·¯ DB¿¡ µ¿ÀûÀ¸·Î Á¢±ÙÇÏ·Á°í ÇÕ´Ï´Ù
< bean id="dynamicDataSource" class="com.mypro.util.DynamicRoutingDataSource">
< property name="targetDataSources">
< map key-type="com.mypro.util.DynamicDS">
< entry key="ds1" value-ref="dataSource_1">
< entry key="ds2" value-ref="dataSource_2">
< entry key="ds3" value-ref="dataSource_3">
< entry key="ds4" value-ref="dataSource_4">
< entry key="ds5" value-ref="dataSource_5">
< /map>
< /property>
< property name="defaultTargetDataSource" ref="dataSource_1" />
< /bean>
ÀÌÀü¿¡´Â À§¿Í °°Àº ¹æ¹ýÀ¸·Î
XML¿¡ ¿©·¯°³ÀÇ datasource¸¦ beanÀ¸·Î Á¤ÀÇÇسõ°í
¶§¿¡ ¸Â°Ô ENUM °ªÀ» ds1, ds2 ·Î º¯°æÇÏ¿©
±×¿¡ ¸Â´Â datasource¸¦ Àоî DB¿¡ Á¢±ÙÇϵµ·Ï ÇÏ´Â ¹æ¹ýÀ» ½á¿Ô½À´Ï´Ù.
±×·±µ¥ Á¢±ÙÇÒ DB°¡ ´Ã¾î³ª¸é XMLÀÇ beanÀ» Ãß°¡ÇÏ°í ¼öÁ¤ÇÏ´Â µî
¼Ò½º¸¦ °íÃÄ¾ß ÇÏ´Â ÀÏÀÌ ¸¹ÀÌ »ý°Ü¼ ¹®Á¦°¡ µÇ¾ú½À´Ï´Ù.
±×·¡¼ properties ÆÄÀϸ¸ ¼öÁ¤ÇÏ°í,
À̸¦ ÂüÁ¶ÇÏ¿© µ¿ÀûÀ¸·Î datasource¸¦ ¸¸µé°í, sqlSessionFactory¸¦ ¸¸µé¾î¼ (java ÄÚµå »ó¿¡¼)
DB¿¡ Á¢±ÙÇÏ´Â ¹æ½ÄÀ¸·Î ¸¸µå·Á°í Çϴµ¥
¾î¶»°Ô ÇؾßÇÏ´ÂÁö ¹æ¹ýÀ» ã´Ù°¡ Áú¹®±ÛÀ» ¿Ã¸³´Ï´Ù.
DataSource dataSource = dbServiceImpl.createDataSource(driverClassName, url, username, password);
À§¿Í °°ÀÌ createDataSource·Î datasource¸¦ »ý¼ºÇÏ´Â ¸Þ¼Òµå´Â ¸¸µç »óȲÀε¥,
ÀÌ datasource·Î sqlSessionFactory¸¦ ¸¸µé°í.. ÇÏ´Â ¹æ¹ýÀ» ¸ð¸£°Ú½À´Ï´Ù.
µµ¿òÀ» ÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù. | |
|