hi!
I am working on migration of BEA Portal to JBoss.
I am using Hibernate and the IDE JBoss Developer Studio.

In Oracle database I have 2 different schemas I want to fetch data from different tables from these two schemas.

Schema 1 : table name ABC

Schema 2: table name XYZ

Can someone help me in writing an HQL query or Hibernate Reverse Engineering using JBoss Developer Studio or MyEclipse.

I tried using my Eclipse it gave me "Please, select tables from a single Schema or Catalog"


Is it possible fetching data from two difffrent tables using a single HQL query???

I want to join the two tables that are in two different schemas using one HQL statement.

Please, any information in this regard is appreciated.

Thanks in Advance.

Take Care

Yes it is if your database supports it. I have almost no experience with Oracle, but I know that, for example, with PostgreSQL you can have table in different schemas, but not in different catalogs.

When you define your entities you can provide information about which schema and catalog a certain table lives in. See for http://www.hibernate.org/hib_docs/v3/re ... tion-class for more information.

I have no experience with the reverse engineering tools so I can't help you with that. Maybe it is a limitation in those tools.

Please,
I want to join the two tables in two different schemas using one HQL statement.

Once you have mapped your classes, you no longer have to care about in which schema they live. Hibernate will take care of it. The HQL is the same as if the tables are in the same schema.