Multiple schema support in Middlegen?

[Sagar Bilgi]

Hi All,
Does anyone know if middlegen supports multiple database schemas? I am currently using an oracle database with tables split across 3 schemas and I plan on using Hibernate to access/modify them. How do I specify that in the middlegen ANT task?

Can any one point out how I can do that? ( or even "IF" it can be done? )

Regards
Sagar

P.S: As with all issues this is rather urgent

[Paul Sturrock]

tables split across 3 schemas

If you have three seperate, unrelated schemas you want to map thats OK. However if you have three schemas with relationships across three DB instances (with constraints between the DBs) this can't be done by Hibernate - so its immaterial whether middlegen can support it. If you require this then look at Oracle's docs for maintaining relationships between schemas.