O/R mapping tools – comparison
For a very extensive comparison between seemingly all the O/R mapping tools known to mankind check this wiki page.
Perhaps a relevant observation: despite the zealoting, Toplink, OJB and Hibernate (by far _the_ most popular ORM-tool, and the basis for EJB3) all seem to offer roughly the same functionality. And actually, the XML configfiles also don’t look all that different to me either..
Some notable differences/facts:
- Hibernate has a big following, development continues at a rapid pace. Free, OS, but no GUI except for some crude 3rd party tool
- OJB has a JDO implementation, the other two have not (for what it’s worth, since the JDO movement seems to be running out of steam). Also OS and free as in beer. GUI under development.
- Toplink doesn’t support MySQL, PostgreSQL or SAP-DB like the other two. It does have a pricetag but also a nice GUI
You may like to read an interview with Dennis Leung, VP TopLink Development, dating back to January 2003, on TheServerSide: Hard Core Tech Talk with Dennis Leung, VP TopLink Development and perhaps even more the many discussion threads spun from this interview. JDO is discussed at length – and not very positively. There is also a pretty healthy stance from Rod Johnson on “Java-experts” ignoring the strengths of relational databases and database experts in order to “OO and EJB” the world.
There is also this MagpieBrain blog which discusses various persistency frameworks. Brian McCallister notes there: “The most common I see used, in order, are: EJB CMP, EJB BMP, Hibernate, OJB, TopLink, Various JDO impls, Cayenne, Cocobase (yes, people use this despite Warren). This is very informal and unscientific, however.”