Hibernate Tools / Oracle create Sequence in Mapping Ressource file

[Michael Li]

Hello,

i hope somebody can help me.

I want to create *.hbm.xml Files with reverse reverse engineering (<jdbcconfiguration>).

The build script is:
build.xml

	
<hibernatetool destdir="${src.dir}">

		<jdbcconfiguration configurationfile="hibernate.cfg.xml" packagename="${package}" revengfile="hibernate.reveng.xml" />
   
		<hbm2java jdk5="true" />
		<hbm2cfgxml ejb3="false" />

		<hbm2hbmxml destdir="${src.hbm}" />

</hibernatetool>

revengfile:

<hibernate-reverse-engineering>
	<table > 
 	 <primary-key>
 	  <generator class="sequence">
 	    <param name="sequence">seq_test</param>
 	  </generator>
 	   <key-column name="ID"/>
 	 </primary-key>
 	</table>
</hibernate-reverse-engineering>

This way works fine, but i have more than one table, so what is the easiest way to get the sequences per table : Pattern tbl_*.

so the result should be:

<hibernate-mapping>
    <class name="framework.Test" table="TEST">
        <id name="id" type="long">
            <column name="ID" />
            <generator class="sequence">
                <param name="sequence">seq_test</param>
            </generator>
        </id>
    </class>
</hibernate-mapping>

Each Table tbl_* have a sequence with name seq_* (tbl_test, seq_test)

thanks

[Paul Sturrock]

ml ml , please check your private messages.