In the hibernate-reverse-engineering file how would I express
the following constraints:

Only reverse-engineer all tables in the UCN schema *and* the one table "CLIENT" in the SHIPLOGDB schema

Put another way:

Reverse-engineer only UCN.* and SHIPLOGDB.CLIENT

Any help is appreciated - Thanks.

voila...the logic:

include everything that matches schema="UCN"
include everything that matches schema="SHIPLOGDB" AND name="CLIENT"
exclude everything else.

Remember that the ordering matters...first hit wins
[/code]

"...Remember that the ordering matters...first hit wins"

Ah ha. That last comment says a lot!

Thanks for the help.

Ron

Hmm...

More strangeness. Tried Max's suggestion:

---- file: hibernate.reveng.xml ---

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering PUBLIC
"-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd" >
<hibernate-reverse-engineering>
<table-filter match-schema="UCN"/>
<table-filter match-schema="SHIPLOGDB" match-name="CLIENT"/>
<table-filter match-schema=".*" exclude="true" />
</hibernate-reverse-engineering>

---- end file: hibernate.reveng.xml ---

When I use the wizard to reverse engineer my database I get a (vague) error message:

org.hibernate.MappingException:Could not configure overrides from file: C:\Java\Projects\UCN\com.expd.domain.ucn\src\hibernate.reveng.xml

Is there somewhere a more detailed stack trace can be found ?

Thanks,

Ron

Responding to my own post...

More details were in the error log view. Turns out the match-name
attribute is *required* so I added match-name to each entry and things
started coming together.

<hibernate-reverse-engineering>
<table-filter match-schema="UCN" match-name=".*" />
<table-filter match-schema="SHIPLOGDB" match-name="CLIENT"/>
<table-filter match-schema=".*" match-name=".*" exclude="true" />
</ibernate-reverse-engineering>

Thanks Again to Max for both adding this feature and helping out.

Onward...

Ron