In my project I'm using spring framework 3, jpa 2 (provider hibernate). I want to design my project such a way that my database schema is replicated on different database instances with same schema. And at the run time I want to switch over the schema for data operations.
So it means that one instance of my business logic and multiple instance of database. So it is possible?
Edit: No of schemas are not predefined it will be decided on the fly.