I know hibernate but I wonder if there would be a lighter ORM engine for a read only database. I mean, I don't need some transactional queries or to update some records. On the other side, I need to handle some large list of records:
List<MyRecord> list= object.getMyRecords(); // list.size() > 1E7
Does such engine exist ? Many thanks,
Pierre
You can check out JIRM (yes, that is a shameless plug) which is an ORM focused on using immutable objects.
It sits right on top of Spring JDBC so, if you're using Spring, it's very low risk to try it.
It also has really nice SQL placeholder templates that do not require Spring.
Another project you should checkout is jOOQ.