Hi all,

Does hibernate have any way of supporting MySQL catlogs? I asked a similar question some time ago and got the feeling that perhaps support for my particular issue was on the way.

My problem is that a design decision was made years ago that means that our database is split up into several catalogs (or databases as MySQL calls them). Each of the catalogs contain the same table structures. They were split like this to speed up queries (some of the tables have between thousands and millions of rows).

There is also a "central" catalog and sometimes queries will traverse the central and one or two of the other catalogs. this has made finding an object/relational mapping system somewhat tricky.

Obviously we can't create a mapping file and objects for every single instance of a table on our system so we need something a little more dynamic, where you can set the catalog at runtime depending on the user.

Any thoughts?

M.