If so, where can I input multiple tables in ant env.?

many-to-one ? sure, that has always been possible.

But I don't understand what your question is for. by default we reverse engineer all tables.

I don't want to generate hbm for all tables in schema, and the table names should be dynamically input from ant prompt. In this case, how can I pass dynamical table names into revers eng xml file?

generate a reveng.xml from your ant input and run it with that.

or maybe even better implement a ReverseEngineeringStrategy that just do what you want (e.g. return the table names you want to accept) or provide a DatabaseMetaDialect that only returns those tables...

I prefer ant solution if it is applicable. In my case, I will have multi. table name input from ant prompt, say like "table_A, table_B". Then I need them shown in rev.eng.xml file for <table name="table_A">, <table name="table_B">. Hibernate tools will take care of generating hbm files and many-to-one relationship between table_A and table_B. Not sure how ant will work to generate dynamical rev.eng.xml file including these table names. Ant supports javascript, and I have used it to parse table names based on comma delimition. Do you have any idea? Thanks!

all of this is possible via ant, you just need to implement a reveng strategy that gets your input e.g. via a property.

I know I can pass a @table.name@ in reveng.xml file, but not know how I can pass undetermined number of @table.name@ in it. Do you have any sample code for this case?

Do you mean wriete a reveng strategy which takes table names from a property file? That is a Java solution, not an ant one. I want to avoid creating a Java class if ant solution can do it.

I don't have other suggestions than to write a custom strategy.

To generate many-to-one relationship, I have to specify something as below in reveng.xml file. I remember in middlegen, what I need is only provide table names and it takes care of parsing relationship among tables without specifying foreign key stuff. Can we have this feature in future release?

<foreign-key constraint-name="ORDER_CUST">
<many-to-one property="customer"/>
<set property="orders"/>
</foreign-key>

Huh? Hibernate Tools detects that fine today.

Same requirements as with middlegen: You need to have a driver and db that has the foreignkey constraints defined.

So, no you can't have it in a future release because its already there.

There is no need to specify these *unless* you want to

a) override some of the default values

b) define additonal foreign keys.

again, please be more specific ;)