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? )
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.