I'm trying to reverse-engineer some classes from my 'dev' database, and then I want to be able to use those classes across my dev, test, and prod databases, since they're all generated from the same database definition.

However, the generated classes (from my hbm2java) all have the dev catalog listed in them. This causes my DAO's to target the dev database each time regardless of whether my dataSource is configured for test or prod.

I'm sure there must be a switch or property that will prevent inclusion of the catalog name in my generated classes, but all Googling has proved futile so far. Anybody know whether there's a switch I can use? Be much obliged.

Regards,
Darryl Pentz

when doing the reverse engineering set hibernate.default_catalog then hibernate tools won't put the catalog there if its the default.

Awesome! That did the trick. Thanks Max!

Hi I am a newbie in Hibernate. I am facing the same issue as mentioned by Darryl Pentz. I am using MyEclipse Enterprise Workbench 9 and sqlserver2008 as my DB. I am using Hibernate Reverse Engineering and use the feature " Hibernate annotation mapping to pojo " to generate pojo.

The pojo has annotations like

@Entity
@Table(name = "xxx", schema = "yyy", catalog = "zzz")

I have added <property name="hibernate.default_catalog">MyDatabaseName</property> in my hibernate.cfg.xml But, there is no change in the annotations in the generated pojo.

My requirement is that I should not get the catalog field in the generated pojo.

Please guide me

Guys I figured it out on how to exclude the catalog field.

As stated before I added a property in my hibernate.cfg.xml as

<property name="hibernate.default_catalog">MyDatabaseName</property>

And also I added the hibernate.reveng.xml and used it to control the generation of pojo. I have pasted the hibernate.reveng.xml that I used

<?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=".*" match-name=".*"/>
</hibernate-reverse-engineering>

match-schema=".*" ------> it means select any / all the schema
match-name=".*" ------> it means select any / all the table from the schema

good that you shared this information)


http://coop-group.org/wakka.php?wiki=buycaviar