We are building a web based db design client, something similar to something like toad. Users can define tables, queries, etc. in their own db (or schema). Each user will have their own db, and thus datasource which may be to an oracle or to a mysql backend.

Is Hibernate the right tool to use for persistence? What is the right pattern to apply here? We plan to create mappings dynamically based on metadata for the db objects. Presumably, each user for a particular db/schema will require his own session factory?

Any comments/thoughts/etc. appreciated...