How to reverse engineer table from multiple schemas?

gnl · **Joined:** Wed Nov 02, 2005 3:29 pm **Posts:** 20

hibernate tools beta4

I need to reverse engineer tables that live under different
schemas.

I tried:

<table-filter match-name="NC_ORG_UNIT" match-schema="NTWKCOMP"/>
<table-filter match-name="DBA_ROLE_PRIVS" match-schema="SYS"/>

but I only got NC_ORG_UNIT.

Debuging a bit more it seems that the value

<property name="hibernate.default_schema">NTWKCOMP</property>

limits me to just one scheme.

Do I have to have two cfg/reveng xml files?

George

max · **Posted:** Thu Mar 09, 2006 3:25 am

for this particular situation yes. In the next release there will be a different mechanism than looking at default_schema/catalog for specifying which schemas should be used as a a strating point..

greater_lake · **Joined:** Mon Jul 09, 2007 2:21 pm **Posts:** 24

What if i had foreign key relationship between the tables in 2 different schemas?

How will i generate associations, if i have 2 reveng.xml and 2 cfg files?

max · **Posted:** Wed Sep 12, 2007 9:44 am

2 reveng.xml and 2 cfg files doesn't make sense.

N reveng.xml and 1 cfg file is ok - but N cfg files is not sensible.