Hi,
After getting hibernate and Middlegen working today I was wondering if anyone could tell me whether they works accross multiple (sybase) databases, e.g. can I join accross two tables in two databases.

Also, is it possible to set relationships between tables via the Middlegen graphical tool, it didn't see any way to do it but would be surprised if that functionality is not available.

Thanks
David

Hibernate can join across schemas (it can do whatever a jdbc connection can do in this respect)

Middlegen i remember as having a limitation on schema handling, but david is better suited for that question ;)

Be surprised. Middlegen shows the current state of the database and the relationships. It does not allow you to edit the relationship or the database state at all (which is not hard to add). Obviously, is easy to drop out of Middlegen, add the constraint using your DB tool and then start Middlegen again. I can understand your desire to be able to so as the make this process easier. I think Max will add this feature request to the desired feature set for the extensions to JBossIDE he's working on.

Hi
I read max said middlegen can do join accross schemas. I'm trying to generate mapping file for tables that are stored in different schemas. However i didn't succeed in it. What option(s) (for middlegen) shall i use in order to generate the mapping files of the different schemas WITHOUT losing the relations between the tables that are not in the same schemas.
Thx

Hi wblitz,

Please reread what I wrote...

I said *Hibernate* could join across schemas, and that Middelgen had troubles with it.