Hibernate Community • View topic - 1 SQL with tables from 2 Schema

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

1 SQL with tables from 2 Schema

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Renogen

Post subject: 1 SQL with tables from 2 Schema

Posted: Mon Dec 09, 2013 6:45 am

Newbie

Joined: Mon Dec 09, 2013 6:41 am
Posts: 1

Hi guys,

I got a physical database with 2 schemas. I need to do a query that access table from 2 schema which looks something like this:

SELECT * FROM schema1.table1 t1, schema2.table2 t2
WHERE t1.field1 = t2.field2

Can this be achieve since i can do something like this in mySQL query editor.

Thanks.

Top

CDillinger

Post subject: Re: 1 SQL with tables from 2 Schema

Posted: Mon Dec 09, 2013 7:17 am

Senior

Joined: Tue Oct 28, 2008 10:39 am
Posts: 196

Put the schema-mapping into your Annotations/XML-Mapping and you are done.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum