Generate POJOs from a limited set of tables using eclipse

oneovthamany · **Joined:** Thu Dec 11, 2003 3:27 pm **Posts:** 12

In the eclipse plugin's Hibernate Artificact Generation wizard I don't see any option for generated mappings and POJOs for a specified set of tables. In fact, there's not even an option for restricting generation to tables from a particular schema. That causes my attempt at code generation to fail with a message like this: "Column(XXX already exists in Table(null.xxxx)" The reason for that error is that in my workplace our database instance houses qa and dev versions of our table structure, and so every Table, including Table XXX, appears in both schemas.

So is there some way to limit code generation to a limited set of tables?

max · **Posted:** Sat May 28, 2005 4:26 am

in alpha 1/2 set default schema/catalog

in cvs version use a .reveng.xml to limit it.

oneovthamany · **Joined:** Thu Dec 11, 2003 3:27 pm **Posts:** 12

I don't see 'set default/schema catalog', or anything like it, in any of the three eclipse Hibernate wizards in alpha1. Where do I set the schema? (By the way, you mention alpha2, but the downloads page only shows alpha1. Is there an alpha2 available?)

max · **Posted:** Tue May 31, 2005 4:49 pm

jbosside downloads contain alpha2

default schema-catalog is as always with hibernate specfified in the hibernate.cfg.xml

sliepmann · **Posted:** Wed Jun 08, 2005 4:36 pm

Max,

I'm not sure if the entire original question was answered. Can the Artifact Generation Wizard be configured so that only a subset of tables from a schema are generated?

Middlegen allows this type of functionality. Before I upgrade to Hibernate 3.0 and use the Artifact Generation Wizard, I need this functionality. Sometimes, a database schema contains tables that don't have primary keys, etc. and I would like to leave those out of the reverse engineering process. It is also useful if the database is large.

Stefanie

max · **Posted:** Wed Jun 08, 2005 4:40 pm

Yes.

http://www.hibernate.org/hib_docs/tools ... .html#gen9

http://www.hibernate.org/hib_docs/tools ... lpha4.html

(See under Wizard section - here you can specify the .reveng.xml documented in the first link)

-max

max · **Posted:** Wed Jun 08, 2005 4:45 pm

And note in middlegen you had to specify every table (which I found a pain) or take it all.

In the reveng.xml you can setup table-filter to include/exclude what you want - IMO much more effective for large schemas.

sliepmann · **Posted:** Wed Jun 08, 2005 4:48 pm

Cool. Thanks for your prompt response. I will take a look. I only had 3.0 alpha 1 version as per what was posted on the tools.hibernate.org site. I see that 3.0 alpha 4 is there now.

Stefanie