Any Java ORM for dynamically created database tables?

Question

We are thinking about switching from our custom made code to an ORM, in order to simplify our code base and move to a possibly more robust code. Currently we have a few "system" tables and a variable number of "custom" tables. Those custom tables are different for each installation: a customer may have tables about invoices, anther may have tables about insurance policies, and so on. These custom tables may be added any time and should be immediately available to the users. We wrote a bunch of java classes following the DBO schema: a class for each system table, plus one generic class for the custom tables. And, we have a generic java object that instantiate the custom records; this class have generic methods like Object getProperty(String name).

We had a look at a few ORMs, but we could not find any that will simplify the use of such custom tables.

Is there anyone with similar experience? Thanks.

Answer 1

Maybe it is a task for a query mapper framework better than an ORM.

For example, using MyBatis you can dynamically map even the table name (See Setting the FROM clause via parameter in MyBatis)

<select id="getLookupRows" parameterType="map" resultMap="lookupMap">
   select id, name, active, valid
   from ${table}
</select>