I am developing four different web application (A1, A2, A3, and A4) using two different DB schema (S1 and S2). Both schema have there own tables and are in Oracle DB. But these application share schema except A1 (i.e. A1 uses S1 and all other A2, A3, A4 use both S1 and S2).
For each application I have separate web project. Now I am wondering how should I create my DAO project(s) which I am creating as a independent from application. Reason is I would be able to distribute that DAO jar.
I am thinking of developing two different DAO for each schema and use them as necessary in application. If I do so then three of the project will have two DAOs. Is this a good design or there is some better approach/practice?