I have been looking at EJB CMP 2.0 and JDO for the last few weeks, trying to figure out if we could use any of them for our next project.
The thing is, we have already have a database schema with an home made persistance layer. We want to switch to a commercial persistance manager, if possible.
We thought about EJB 2.0 with CMP, but the problem is that we don't have a very simple O/R mapping, i.e. we often have more than one table for one entity. That is a problem with CMP, since there's no way an entity bean can be persisted to more that one table, right?
Also, sometimes we have one table to store many different entities (inheritance)...
Is there a workaround for this? Creating a new DB schema and migrating our current application is not an option because we have dozens of (very large) instances of our schema all around (each customer has its own instance). Using database views seems to solve some issues, but not all.
IMO, JDO suffers from the same limitations...
We will look at advanced O/R mapping solutions, like Toplink and Cocobase. But, can anybody provide a solution to this problem, or any advice?
Thanks in advance