<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<properties resource="project/properties/db/database.properties.dev"/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="${driver}" />
<property name="JDBC.ConnectionURL" value="${jdbc.url}" />
<property name="JDBC.Username" value="${username}" />
<property name="JDBC.Password" value="${password}" />
<!--OPTIONAL PROPERTIES BELOW -->
<property name="JDBC.DefaultAutoCommit" value="true" />
<property name="Pool.MaximumActiveConnections" value="100"/>
<property name="Pool.MaximumIdleConnections" value="50"/>
<property name="Pool.MaximumCheckoutTime" value="120000"/>
<property name="Pool.TimeToWait" value="500"/>
<property name="Pool.PingQuery" value="select 1"/>
<property name="Pool.PingEnabled" value="false"/>
<property name="Pool.PingConnectionsOlderThan" value="1"/>
<property name="Pool.PingConnectionsNotUsedFor" value="1"/>
</dataSource>
</transactionManager>
<sqlMap resource="sqlmaps/common/selectCommon.xml" />
<sqlMap resource="sqlmaps/concept/deleteConcept.xml" />
<sqlMap resource="sqlmaps/concept/insertConcept.xml" />
<sqlMap resource="sqlmaps/concept/selectConcept.xml" />
<sqlMap resource="sqlmaps/concept/updateConcept.xml" />
<sqlMap resource="sqlmaps/conceptRelationship/deleteConceptRelationship.xml" />
<sqlMap resource="sqlmaps/conceptRelationship/insertConceptRelationship.xml" />
<sqlMap resource="sqlmaps/conceptRelationship/selectConceptRelationship.xml" />
<sqlMap resource="sqlmaps/domain/deleteDomain.xml" />
<sqlMap resource="sqlmaps/domain/insertDomain.xml" />
<sqlMap resource="sqlmaps/domain/selectDomain.xml" />
<sqlMap resource="sqlmaps/domain/updateDomain.xml" />
<sqlMap resource="sqlmaps/domainRelationship/deleteDomainRelationship.xml" />
<sqlMap resource="sqlmaps/domainRelationship/insertDomainRelationship.xml" />
<sqlMap resource="sqlmaps/domainRelationship/replaceDomainRelationship.xml" />
<sqlMap resource="sqlmaps/domainRelationship/selectDomainRelationship.xml" />
<sqlMap resource="sqlmaps/domainSameConcept/deleteDomainSameConcept.xml" />
<sqlMap resource="sqlmaps/domainSameConcept/insertDomainSameConcept.xml" />
<sqlMap resource="sqlmaps/domainSameConcept/selectDomainSameConcept.xml" />
<sqlMap resource="sqlmaps/domainSameConcept/updateDomainSameConcept.xml" />
<sqlMap resource="sqlmaps/domainToConcept/deleteDomainToConcept.xml" />
<sqlMap resource="sqlmaps/domainToConcept/insertDomainToConcept.xml" />
<sqlMap resource="sqlmaps/domainToConcept/replaceDomainToConcept.xml" />
<sqlMap resource="sqlmaps/domainToConcept/selectDomainToConcept.xml" />
<sqlMap resource="sqlmaps/idIssue/replaceIdIssue.xml" />
<sqlMap resource="sqlmaps/menu/selectMenu.xml" />
<sqlMap resource="sqlmaps/referenceSystemToConcept/deleteReferenceSystemToConcept.xml" />
<sqlMap resource="sqlmaps/referenceSystemToConcept/insertReferenceSystemToConcept.xml" />
<sqlMap resource="sqlmaps/referenceSystemToConcept/replaceReferenceSystemToConcept.xml" />
<sqlMap resource="sqlmaps/referenceSystemToConcept/selectReferenceSystemToConcept.xml" />
<sqlMap resource="sqlmaps/term/deleteTerm.xml" />
<sqlMap resource="sqlmaps/term/insertTerm.xml" />
<sqlMap resource="sqlmaps/term/replaceTerm.xml" />
<sqlMap resource="sqlmaps/term/selectTerm.xml" />
<sqlMap resource="sqlmaps/term/updateTerm.xml" />
<sqlMap resource="sqlmaps/user/insertUser.xml" />
<sqlMap resource="sqlmaps/user/updateUser.xml" />
<sqlMap resource="sqlmaps/user/deleteUser.xml" />
<sqlMap resource="sqlmaps/user/selectUser.xml" />
</sqlMapConfig>
현재 동일한 스키마를 가진 DB를 4개 사용중인데, 그래서 SqlMapConfig.xml도 이름이 다르게 내용은 똑같이 4개입니다.
근데 sqlMap resource를 추가하면 파일 4개에 모두 <sqlMap resource=""/> 부분을 추가해 줘야해서
<sqlMap resource=""/> 부분을 하나의 파일로 따로 빼서 각각 4개의 SqlMapConfig.xml에서 인클루드 하고 싶거든요
혹시 이런 설정이 가능한지 고수님들의 답변을 부탁 드립니다.
감사합니다.
짧은글 일수록 신중하게.