eGovFrame 표준프레임워크 포털

메뉴 건너띄기
상단메뉴 바로가기
본문 바로가기

이 누리집은 대한민국 공식 전자정부 누리집입니다.

본문 영역

We provide technical issue resolution support through Application Support, FAQ, and Q&A boards.

SUPPORT

Runtime Environment
How to use Multi DB
  • Author

    Admin

  • Date of registration

    2012-04-18

  • Views

    4,717

Question

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?

Attached files

  • Multiple DataSource Transaction.txt [4,042 Byte]

    Downaload

  • JEUS JTA Settings.txt [1,787 Byte]

    Downaload
Answer

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)

List