Generator class in mapping file

Jake123 · **Posted:** Tue Jan 23, 2007 5:50 pm

Hi,
When I generate my mapping files using the reverse engineering my files looks something like this:

Code:

<hibernate-mapping>
    <class name="com.myCompany.business.model.Foo" table="Foo">
        <id name="userName" type="string">
            <column name="USER_NAME" length="8" />
            <generator class="assigned" />
        </id>
        ....
    </class>
</hibernate-mapping>

and this is fine for some tables but most of my tables is using a sequence number to get the next value on the primary key. And therefor I want to be able to specify what tables is using "assigned" and what tables are using the sequence...

Code:

<hibernate-mapping>
    <class name="com.myCompany.business.model.Foo" table="Foo">
        <id name="userName" type="string">
            <column name="USER_NAME" length="8" />
            <generator class="sequence"> 
               <param name="sequence">FOO_SEQ</param>
            </generator>
        </id>
        ....
    </class>
</hibernate-mapping>

Is there any way to specify this in the cfg.xml or the reveng.xml?

Cheers
Jacob

max · **Posted:** Wed Jan 24, 2007 12:20 pm

yes in reveng.xml ....look in the tool docs for generator.

Jake123 · **Posted:** Wed Jan 24, 2007 12:39 pm

Hi Max,
I read the documentation and this is the closest I get:

Code:

   <table schema="JACOB" name="APP_USER_ROLE">
      <primary-key>
         <generator class="sequence">
            <param name="table">APP_USER_ROLE_SEQ</param>
         </generator>
         <column name="APP_USER_ROLE_ID"/>
      </primary-key>
   </table>

but now I get an error in the page stating:
"The content of element type 'primary-key' must match '(generator?, key-column)'"

What am I doing wrong?

Cheers,
Jacob

max · **Posted:** Wed Jan 24, 2007 12:45 pm

column should be key-column

where did you read it is column ? (this was in the *old old* days ;)

max · **Posted:** Wed Jan 24, 2007 12:50 pm

doh ...docs have a bug...fixed in svn. thanks ;)

Jake123 · **Posted:** Wed Jan 24, 2007 1:08 pm

Hi again,
I have done the update now and now the error is gone. This is how part of my reveng.xml looks like:

Code:

   <table schema="JACOB" name="APP_USER_ROLE">
      <primary-key>
         <generator class="sequence">
            <param name="table">APP_USER_ROLE_SEQ</param>
         </generator>
         <key-column name="AppUserRoleId"/>
      </primary-key>
      <foreign-key constraint-name="FK_APP_USER_APP_USER_ROLE">
         <many-to-one property="AppUser" exclude="true" />
      </foreign-key>
   </table>

But still my generated file look like this:

Code:

<?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 Jan 24, 2007 12:03:28 PM by Hibernate Tools 3.2.0.beta7 -->
<hibernate-mapping>
    <class name="com.myCompany.business.model.AppUserRole" table="APP_USER_ROLE">
        <id name="appUserRoleId" type="java.lang.Long">
            <column name="APP_USER_ROLE_ID" precision="22" scale="0" />
            <generator class="assigned" />
        </id>
         .....
    </class>
</hibernate-mapping>

Is there anything I am still missing?
BTW: I am running on a Oracle 10 database with Hibernate tools 3.2.0.beta7

Cheers,
Jacob

max · **Posted:** Wed Jan 24, 2007 1:15 pm

is your schema really named JACOB ?

...and why are you usign beta7 when i just released beta9 ? :)

Jake123 · **Posted:** Wed Jan 24, 2007 1:36 pm

Yes, my schema name is JACOB and I have not had time to do the update.... so you think it will work if I use the latest version?

I will start downloading the latest version right now...

Cheers, Jacob

Jake123 · **Posted:** Wed Jan 24, 2007 2:08 pm

Hi Max,
I have done the update and now the result file looks like this:

Code:

<?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 Jan 24, 2007 1:02:58 PM by Hibernate Tools 3.2.0.b9 -->
<hibernate-mapping>
    <class name="com.myCompany.business.model.AppUserRole" table="APP_USER_ROLE">
        <id name="appUserRoleId" type="java.lang.Long">
            <column name="APP_USER_ROLE_ID" precision="22" scale="0" />
            <generator class="assigned" />
        </id>
        .....
    </class>
</hibernate-mapping>

Still no luck with using the settings in the reveng.xml to change the generator to sequence.

Code:

<table schema="JACOB" name="APP_USER_ROLE">
      <primary-key>
         <generator class="sequence">
            <param name="table">APP_USER_ROLE_SEQ</param>
         </generator>
         <key-column name="APP_USER_ROLE_ID"/>
      </primary-key>
      <foreign-key constraint-name="FK_APP_USER_APP_USER_ROLE">
         <many-to-one property="AppUser" exclude="true" />
      </foreign-key>
   </table>

The key-column I tried both <key-column name="APP_USER_ROLE_ID"/> and <key-column name="AppUserRoleId"/>

but the result is still the same as above... any suggestions?

Cheers,
Jacob

max · **Posted:** Wed Jan 24, 2007 2:16 pm

leave schema out and tell me what the result is

Jake123 · **Posted:** Wed Jan 24, 2007 2:32 pm

Thank Max, that fixed it... now the result comes out really nice...

Code:

<?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 Jan 24, 2007 1:29:52 PM by Hibernate Tools 3.2.0.b9 -->
<hibernate-mapping>
    <class name="com.myCompany.business.model.AppUserRole" table="APP_USER_ROLE">
        <id name="appUserRoleId" type="java.lang.Long">
            <column name="APP_USER_ROLE_ID" precision="22" scale="0" />
            <generator class="sequence">
                <param name="sequence">APP_USER_ROLE_SEQ</param>
            </generator>
        </id>
        .....
    </class>
</hibernate-mapping>

max · **Posted:** Wed Jan 24, 2007 2:47 pm

so the schema name was *not* JACOB :)