Hi all,
i need an ant's scipt for reverse engineering of db with a lot of tables: i wold like generete hbm.xml files or java classes.

Have you something like that?

Regards

Hi, i've made a simple ant script for generete mapping files from tables
but i've the error below.

note that i've put in the classpath all of hibernate libs and jbdc driver for oracle.

<!--
ant script per generare file di mapping e oggetti java
a partire dallo schema
-->

<project name="HBReverse" default="HBReverse" basedir=".">
<property file="./properties/reverse.properties"/>
<property name="lib" value=""/>
<property name="hblib" value=""/>
<property name="hbconf" value=""/>
<property name="package.name" value=""/>
<property name="reverse.file" value=""/>
<property name="reverse.engine.class" value=""/>
<property name="detectemanytomany" value=""/>
<property name="detectoptimisticlock" value=""/>
<property name="hbm.dest.dir" value=""/>

<property name="project.name" value="HBReverse"/>


<path id="toolslib">
<fileset dir="${hblib}">
<include name="**/*.jar" />
<include name="**/*.properties" />
</fileset>
<fileset dir="${lib}">
<include name="**/*.jar" />

</fileset>
</path>

<taskdef name="hibernatetool" classname="org.hibernate.tool.ant.HibernateToolTask" classpathref="toolslib" />


<hibernatetool>

<jdbcconfiguration
propertyfile = "${hbconf}"
packagename = "${package.name}"
revengfile = "${reverse.file}"
detectmanytomany = "${detectemanytomany}"

>
</jdbcconfiguration>
<hbm2hbmxml destdir="${hbm.dest.dir}" />
</hibernatetool>

<target name="reverse" >

</target>


</project>


######################################
# FILE DI PROPERTIES PER LO SCRIPT #
# reverse.xml #
######################################

# dir con le libs comuni (obbligatorio)
lib=p:/arete/libs/

# dir con le libs di hibernate (obbligatorio)
hblib=p:/arete/libs/hibernate/

# file di configurazione hibernate da utilizzare (obbligatorio)
hbconf=../metadata/hibernate.cfg.xml


# nome del package per le classi generate (obbligatorio)
package.name=it.sailing.hb.hbo


# nome del file xml con i parametri per il reverse (opzionale)
reverse.file=

# nome della classe che implementa org.hibernate.cfg.reveng.ReverseEngineeringStrategy
# (da utilizzare per implementare una strategia di reverse custom)
#reverse.engine.class=

# flag per determinare le relazioni many to many (obbligatorio)
detectemanytomany=false

# flat per determinare il lock ottimistico (obbligatorio)
detectoptimisticlock=true

# dir di destinazione per i files di mapping *.hbm.xml
hbm.dest.dir=../metadata/hbm




<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">**</property>
<property name="hibernate.connection.user">**</property>
<property name="hibernate.connection.password">**</property>
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
</session-factory>
</hibernate-configuration>

What was the error?

At an initial glance, you are using an hibernate.cfg.xml for the propertyfile attribute of the jdbcconfiguration. Either use configurationfile =hibernate.cfg.xml or change the cfg.xml to a properties file and use propertyfile=hibernate.properties.