I'm looking at Spring and iBatis as the basis for a new project. My requirements are two fold.
firstly i need to provide CRUD functionality supporting PL/SQL calls and SQL which i've modelled and understood.
secondly i need to provide isolated data migration across multiple database instances. for example i'm offering CRUD of a Party bean but I also need to offer copy of Party bean from one database instance to another. Even though I'm dealing with mulitple instances i can get away without JTA because a "write" transaction would only ever exist on one database (read from a and write to b). What I can't clearly realise is the modelling of one Party bean that can exist programatically in n number of instances. (the declaration of DAO explicitly ties it to a data source.)
My initial modelling consists of a lookUp database instance that holds information of all Party Beans and the environments they exist in.
All advice would be welcome.