Hi All,
I am using middlegen-hibernate r4 to read from an existing Oracle 9i database with 3 schemas under a JDK 1.4 environment.

I am facing 2 issues:

a) How do I get middlegen to recognize the different schemas in the DB?In the ant middlegen task you can only specify one schema element? Is there a way in which this can be achieved??


b) Also how do I write Hibernate queries ( I do not wish to write SQL queries) in which tables from 2 schemas are referenced?


Any help in this matter will be highly appreciated :)

Thanks and Regards.

I would never cross schema boundaries. If you need to then consider synoyms (maybe views) and approriate grants allocated thats accessible from the primary schema. It comes down to the JDBC driver being able to get access to it.