How to use Multi DB
- 작성자
- 관리자
- 작성일자
- 2012-04-18
- 조회수
- 4,635
Q
I’d like to use several databases. What configuration do I have to make?
In addition, could you let me know the method for ensuring transaction?
A
Hello
There are two ways. The first is simply choosing another DB without transaction, the second is using global transaction such as 2PC(two-phase commit).
The first case which is simply choosing another DB will be handled as follows:
1. Define additional DataSource (context-datasource.xml)
2. Define additional sqlMapClient (context-sqlMap.xml)
3. Add AbstractDAO
4. Implement development DAO (Inherit added AbstractDAO)
The second case which is global transaction will be implemented with JTA of WAS. The attached file will explain the configuration and how to apply. (including JEUS case study)
There are two ways. The first is simply choosing another DB without transaction, the second is using global transaction such as 2PC(two-phase commit).
The first case which is simply choosing another DB will be handled as follows:
1. Define additional DataSource (context-datasource.xml)
2. Define additional sqlMapClient (context-sqlMap.xml)
3. Add AbstractDAO
4. Implement development DAO (Inherit added AbstractDAO)
The second case which is global transaction will be implemented with JTA of WAS. The attached file will explain the configuration and how to apply. (including JEUS case study)