Hi,
I'm working with hibernate tools to reveng Postgres Tables to create hbm mappings and java classes.

My DB has about 20 tables, some tables has an "_" in the name like: "applicazione_has_domanda"

I noticed that hibernate tools strips "_" from the name of the table to become "applicazioneHasDomanda"

When I reveng the whole db hibernet tools does not reveng tables with "_" inside but when I ask to reveng only tables with "_" hbm files are generated correctly.

Is this a known bug or did I forget something?

Thanks,
fabio

I don't understand your question/problem.

What do you mean by "correctly" as opposed to the whatever you see it actually do ?

And we don't remove anything from tablenames; we do a class name generation *based* on the tablename and that will by default camelcase it (which involves removing '_' and capitalize the next word)

This is my simple revenge.xml for my postgres db:

<table-filter match-name="messaggio" match-schema="public" />
<table-filter match-name="utente" match-schema="public" />
<table-filter match-name="progetto" match-schema="public" />
<table-filter match-name="utente_has_modulotto" match-schema="public" />-->
<table-filter match-name="files" match-schema="public" />-->
<table-filter match-name="applicazione" match-schema="public" />
<table-filter match-name="applicazione_has_files" match-schema="public" />
<table-filter match-name="certificazione" match-schema="public" />
<table-filter match-name="destinazione" match-schema="public" />
<table-filter match-name="domanda" match-schema="public" />
<table-filter match-name="domandaprogetto" match-schema="public" />
<table-filter match-name="fileappoggio_has_domanda" match-schema="public" />
<table-filter match-name="item" match-schema="public" />
<table-filter match-name="lingua" match-schema="public" />
<table-filter match-name="lotto" match-schema="public" />
<table-filter match-name="modulo" match-schema="public" />
<table-filter match-name="moduloprogetto" match-schema="public" />
<table-filter match-name="moduloprogetto_has_fileappoggio" match-schema="public" />
<table-filter match-name="modulotto" match-schema="public" />
<table-filter match-name="passaggiodistato" match-schema="public" />
<table-filter match-name="passaggiodistato_has_ruolo" match-schema="public" />
<table-filter match-name="projectmanager" match-schema="public" />
<table-filter match-name="ruolo" match-schema="public" />
<table-filter match-name="ruolocontrollato" match-schema="public" />
<table-filter match-name="software" match-schema="public" />
<table-filter match-name="software_has_modulo" match-schema="public" />
<table-filter match-name="softwaresuite" match-schema="public" />
<table-filter match-name="stato" match-schema="public" />
<table-filter match-name="syllabus" match-schema="public" />
<table-filter match-name="templatemcq" match-schema="public" />
<table-filter match-name="tipoattivita" match-schema="public" />
<table-filter match-name="tipoutente" match-schema="public" />
<table-filter match-name="transizione" match-schema="public" />
<table-filter match-name="utilizzo" match-schema="public" />
<table-filter match-name="domanda_stato" match-schema="public" />
<table-filter match-name="domanda_syllabus" match-schema="public" />
<table-filter match-name="moduloprogetto_item" match-schema="public" />
<table-filter match-name="progetto_domanda" match-schema="public" />

When I run it hibernate tools skips all tables with "_" in the name, and it does not generate hbm files for them. For example it does not generate hbm for "software_has_modulo", but it correctly generates hbm for Utilizzo.hbm.

To generate hbm for tables which name contains "_" I have to remove from reveng.xml all other tables.

I hope I explained my problem better.

Thanks,
fabio

you snippet contains partial/non-valid comment tags.

Please show *correct* reveng.xml that gives you _ tables and a correct one that does not give it to you. (casing is important)

this is my standard reveng.xml:

<table-filter match-name="messaggio" match-schema="public" />
<table-filter match-name="utente" match-schema="public" />
<table-filter match-name="progetto" match-schema="public" />
<table-filter match-name="utente_has_modulotto" match-schema="public" />
<table-filter match-name="files" match-schema="public" />
<table-filter match-name="applicazione" match-schema="public" />
<table-filter match-name="applicazione_has_files" match-schema="public" />
<table-filter match-name="certificazione" match-schema="public" />
<table-filter match-name="destinazione" match-schema="public" />
<table-filter match-name="domanda" match-schema="public" />
<table-filter match-name="domandaprogetto" match-schema="public" />
<table-filter match-name="fileappoggio_has_domanda" match-schema="public" />
<table-filter match-name="item" match-schema="public" />
<table-filter match-name="lingua" match-schema="public" />
<table-filter match-name="lotto" match-schema="public" />
<table-filter match-name="modulo" match-schema="public" />
<table-filter match-name="moduloprogetto" match-schema="public" />
<table-filter match-name="moduloprogetto_has_fileappoggio" match-schema="public" />
<table-filter match-name="modulotto" match-schema="public" />
<table-filter match-name="passaggiodistato" match-schema="public" />
<table-filter match-name="passaggiodistato_has_ruolo" match-schema="public" />
<table-filter match-name="projectmanager" match-schema="public" />
<table-filter match-name="ruolo" match-schema="public" />
<table-filter match-name="ruolocontrollato" match-schema="public" />
<table-filter match-name="software" match-schema="public" />
<table-filter match-name="software_has_modulo" match-schema="public" />
<table-filter match-name="softwaresuite" match-schema="public" />
<table-filter match-name="stato" match-schema="public" />
<table-filter match-name="syllabus" match-schema="public" />
<table-filter match-name="templatemcq" match-schema="public" />
<table-filter match-name="tipoattivita" match-schema="public" />
<table-filter match-name="tipoutente" match-schema="public" />
<table-filter match-name="transizione" match-schema="public" />
<table-filter match-name="utilizzo" match-schema="public" />
<table-filter match-name="domanda_stato" match-schema="public" />
<table-filter match-name="domanda_syllabus" match-schema="public" />
<table-filter match-name="moduloprogetto_item" match-schema="public" />
<table-filter match-name="progetto_domanda" match-schema="public" />

With this files hibernate tools does not create hbm for:
applicazione_has_files
utente_has_modulotto
fileappoggio_has_domanda
moduloprogetto_has_fileappoggio
software_has_modulo
passaggiodistato_has_ruolo

but it works with:
moduloprogetto_item
domanda_stato
domanda_syllabus

if for example I remove from previous reveng.xml list the line:
<table-filter match-name="files" match-schema="public" />

hibernate tools creates hbm for:
fileappoggio_has_domanda
moduloprogetto_has_fileappoggio

if I use <table-filter> with wildcards hbm for
moduloprogetto_has_fileappoggio and others are not created

I cant understand the reason... do you know a reason why there could be this problem? Do you need a backup of my postgres db?

Thank you,
fabio

it looks weird i must say....if you can give a copy of the schema then it would help.

how can i send you a copy of the db?
thanks,
fabio

doesn't postgressql have some schema structure dumper which generates a file i can import ? you can send the file to the email adress available on the left side under my name (via the email icon)

uhm... maybe I'm asking a stupid thing...
Under your name I cant find your email...

thanks,
fabio

ah emails ain't visible for all ( of course ;)

send to max at hibernate.org

Hi,

I got your schema and there is very simply explanation for those tables not being generated as entities.

They are detected as many-to-many tables and thus mapped as such.

You can disable that in eclipse ui if you do not want that; for ant you can look in the docs to see the attribute to set to control it.

Thank you very much!

fabio