join tables from different schema in jpa

[sangeetha krishnamurthi]

Hi,

I am using ejb3 amd i want to join two tables which are present in different schemas.how to do that in jpa.let me know some sites where i can find some examples for join.

Regards,
Sangeetha

[David O'Meara]

I'm not sure about its use in JPA, but it can be done in general by fully qualifying the schema.table in queries. It will only work if the user has access to all schemas. It's not a good idea though, and the only time I have needed to do it, we found it easier to import the table temporarily, run the queries and drop the table.

[sangeetha krishnamurthi]

Hi david,

i tried the same way you said i was able to execute that query in oracle but while mapping to my entity i am wrong somewhere. could you provide me a example for joining two tables with object relational mapping.

thanks
sangeetha

[David O'Meara]

This is what I mean about its usage in JPA - I'm not sure it is supported.

[Mark Spritzler]

It isn't supported, so to speak. You can always create an SQLQuery instead of hoping for any mapping solution.

Mark