Hibernate Reveng does nothing

[jethoraz]

Hi,

Hope someone can give me a hint.

I am trying to reverse engineer a fairly simple MySQL database, using Hibernate Tools. I've got the Console Configuration running, and I can see my database schema just fine, and browse the tables in the Hibernate perspective of Eclipse.

I then create a "Hibernate Code Generation Configuration", selecting my newly (and working) console configuration. I check the "Reverse engineer ..." option, and fill in the fields (except reveng strategy, and use custom templates).

I select to export "Domain code", "Hibernate XML Mappings", and "DAO Code". I then click Run...and...nothing happens. Nothing at all. Not a stack trace in the console. Not a line in Eclipse's log. Nothing.

Does anyone have a clue?

this is my hibernate.cfg.xml

<?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.bytecode.use_reflection_optimizer">false</property>

        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

        <property name="hibernate.connection.password">xxx</property>

        <property name="hibernate.connection.url">jdbc:mysql://localhost/ishesteliga</property>

        <property name="hibernate.connection.username">yyy</property>

        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

        <property name="hibernate.search.autoregister_listeners">false</property>

    </session-factory>

</hibernate-configuration>

and this is my hibernate.reveng.xml

<?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="ishesteliga" match-name="authorities"/>

    <table-filter match-schema="ishesteliga" match-name="competition"/>

    <table-filter match-schema="ishesteliga" match-name="horse"/>

    <table-filter match-schema="ishesteliga" match-name="horseandrider"/>

    <table-filter match-schema="ishesteliga" match-name="meeting"/>

    <table-filter match-schema="ishesteliga" match-name="meetingcompetition"/>

    <table-filter match-schema="ishesteliga" match-name="result"/>

    <table-filter match-schema="ishesteliga" match-name="rider"/>

    <table-filter match-schema="ishesteliga" match-name="roles"/>

    <table-filter match-schema="ishesteliga" match-name="season"/>

    <table-filter match-schema="ishesteliga" match-name="seasonhorseandrider"/>

    <table-filter match-schema="ishesteliga" match-name="seasonmeeting"/>

    <table-filter match-schema="ishesteliga" match-name="users"/>

  </hibernate-reverse-engineering>

Regards Martin

[dgeraskov]

Hi, Martin,

the problem with catalog/schema name in MySQL.

Look here http://community.jboss.org/message/602330#602330

[jethoraz]

Hi Dmitry,

Thanks for your reply.

I'm not sure if it is the same issue. I'm not using JPA, but "HIbernate configured connection", and nothing is generated, I get no POJO's, nor DAO's, nor HBM's, so theres no annotation to check. All I have right now is my hibernate.cfg.xml and hibernate.reveng.xml

I did, however, try your alternative jdbc URL's and then my hibernate configured connection stopped working.

Regards Martin

[dgeraskov]

No, try to change reveng.xml file.

Try match-catalog instead of match-schema

[jethoraz]

Hi Dmitry,

You're my hero

That did indeed do the trick. Thanks a lot.

Regards Martin

[rjanuzi]

Oh Dmitry, you're my hero to! : )

Tks guys!

[pippodev]

I had the same output (I.E. nothing, either in the console)!!

the problem was I didn't selected correctly catalog and schema..

Look at datasource explorer and select catalog and schema (when you create hibernate.cfg.xml)

then you must see something like this