Can someone explain briefly how I can set the generator for a primary key column from a ReverseEngineeringStrategy?

I am extending DelegatingReverseEngineeringStrategy, but cannot see how to manipulate the generator for a primary key column.

e.g. Hibernate is generating hbm like this -

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 22-Jun-2010 17:07:47 by Hibernate Tools 3.2.4.GA -->
<hibernate-mapping>
<class name="uk.co.accountablecare.web.orm.generated.Test" table="test" schema="public">
<id name="id" type="int">
<column name="id" />
<generator class="assigned" />
</id>


But that is not correct for my purposes. I am Using Postgres 8.4.4 and the column is of a "serial" type, which whilst an int, it is also generated by the database. I need to produce hibernate to produce hbm's that set the generator class to sequence. e.g. -

<hibernate-mapping>
<class name="uk.co.accountablecare.web.orm.generated.Test" table="test" schema="public">
<id name="id" type="int">
<column name="id" />
<generator class=""sequence">
<param name="sequence">test_id_seq</param>
</generator>
</id>



So how can I manipulate the generator class and its parameters from the ReverseEngineeringStrategy please?

Thanks Adam.

Thanks, but I am already aware of that! My question was how to do it from the ReverseEngineeringStrategy?

That works nicely, thanks :-)

"This looks interesting", is what I though when coming across this thread. Another person who has the same trouble with the custom reveng strategy. And then, the last post



"Great", I thought... Tried it and oh wonder: It doesn't effing work either! What is it with "features" in this that don't work either way you try them?

Always the same error:

I think your constructor is wrong, probably also the one in the example code in this thread. I may have just done this without thinking or mentioning it. Try this --

public CustomReverseEngineeringStrateg(ReverseEngineeringStrategy delegate) {
super(delegate);
}

Thanks for the reply. But, there's nothing wrong with the constructor. In fact, if there were, the compiler would give you an error:

if you only define a standard constructor like public CustomRevEngStrategy(){}

or


if you don't define any constructor at all

Again, thanks for trying to help, but my code looks exactly like yours does.

Ah right!

So it sounds to me like there is something wrong in how you configure Hibernate to find your Reverse Engineering Strategy. I dont know what mechanism you are using, personally I am using Maven and have this as a step in my build process. For reference, it looks like this -

<plugin id="prepare">
<groupId>org.codehaus.mojo</groupId>
<artifactId>hibernate3-maven-plugin</artifactId>
<version>2.2</version>
<configuration>
<componentProperties>
<reversestrategy>uk.org.adamretter.hibernate.reveng.interfacestratergy.InterfaceReverseEngineeringStrategy</reversestrategy>
<packagename>uk.co.accountablecare.web.orm.generated</packagename>
<propertyfile>src/main/resources/hibernate.properties</propertyfile>
</componentProperties>
</configuration>
<executions>
<execution id="prepare">
<phase>initialize</phase>
<goals>
<goal>hbm2cfgxml</goal>
<goal>hbm2hbmxml</goal>
</goals>
</execution>
</executions>
<dependencies>
<dependency>
<groupId>postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>8.4-702.jdbc4</version>
</dependency>
<dependency>
<groupId>uk.org.adamretter.hibernate.reveng</groupId>
<artifactId>hibernate-interface-strategy</artifactId>
<version>1.0-SNAPSHOT</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>3.3.2.GA</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-tools</artifactId>
<version>3.2.4.GA</version>
</dependency>
</dependencies>
</plugin>

I don't know jack about Maven. Quite frankly, I'm happy that my company rejects it. Don't see what it has to do with Hibernate's ReverseEngineering, anyhow.

I'm using the Hibernate-Tools with the Eclipse plugin. In the "Hibernate Code Generation Configurations..." wizard I set the field "reveng.strategy" to my custom class. I am under the impression that this is the way to do it. (I mean, what else would this be for?)

Turned out, that is the way to do it. But, what you can hardly read anywhere is: This perticular class has to be in the class path of the Hibernate Configuration. And for anyone like me who doesn't know what that is: that is not necessarily the project you're currently working in! It is the project for which you originally created the configuration (That thing you can see using the Hibernate Perspective).

Since you need to browse to an existing project when creating such a new configuration, this project's class path is the same the new hibernate configuration will use... At least that's how it seems to me.

So I copied the file to a package in this project and: it works. Finally!

Thannks for helping

You don't have to choose a project. That is just optional.
http://docs.jboss.org/tools/3.0.0.CR1/e ... nsole_conf explains both project reference and the class path tab.