-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Projects » Tools

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 
  Previous topic | Next topic 
Author Message
sorin7486
 Post subject: if anybody else has problems with <table> in reveng.xm
PostPosted: Fri Jan 19, 2007 8:39 am 
Beginner
Beginner

Joined: Thu Aug 03, 2006 3:43 am
Posts: 45
this was originally another post but since I can't delete it i'm going to post the answer I found fo my problem:

if you have problems with hibernate tools not seeyng the <table> tags in your reveng.xml file don't forget to specify the schema.. I did :P...

Quote:

(2) schema (Optional): Schema name for table. Has to be specified if you are reverse engineering multiple schemas or if it is not equal to hiberante.default_schema



it is optional but you probably need it ;)

have a nice weekend everybody
Top
 Profile  
 
max
 Post subject:
PostPosted: Fri Jan 19, 2007 2:44 pm 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
did you read and understand that line ? :)

_________________
Max
Don't forget to rate

Top
 Profile  
 
sorin7486
 Post subject:
PostPosted: Tue Jan 23, 2007 9:26 am 
Beginner
Beginner

Joined: Thu Aug 03, 2006 3:43 am
Posts: 45
hello max...

you might be right ... but I have looked into things a bit more and it's like this... I have a firebird database as release platform and we work for developement on hsqldb... if I use hsqldb I have to set the schema explicitly like this:

Code:
<?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>

    <schema-selection match-schema="PUBLIC"/>

    <type-mapping>
        <sql-type jdbc-type="NUMERIC" hibernate-type="java.lang.Long" not-null="true"/>
        <sql-type jdbc-type="NUMERIC" hibernate-type="java.lang.Long" not-null="false"/>
        <sql-type jdbc-type="INTEGER" hibernate-type="java.lang.Long" not-null="true"/>
        <sql-type jdbc-type="INTEGER" hibernate-type="java.lang.Long" not-null="false"/>
        <sql-type jdbc-type="BIGINT" hibernate-type="java.lang.Long" not-null="true"/>
        <sql-type jdbc-type="BIGINT" hibernate-type="java.lang.Long" not-null="false"/>
        <sql-type jdbc-type="SMALLINT" hibernate-type="java.lang.Boolean" not-null="true"/>
        <sql-type jdbc-type="SMALLINT" hibernate-type="java.lang.Boolean" not-null="false"/>
        <sql-type jdbc-type="TINYINT" hibernate-type="java.lang.Boolean" not-null="true"/>
        <sql-type jdbc-type="TINYINT" hibernate-type="java.lang.Boolean" not-null="false"/>
        <sql-type jdbc-type="DECIMAL" hibernate-type="java.lang.Long" not-null="true"/>
        <sql-type jdbc-type="DECIMAL" hibernate-type="java.lang.Long" not-null="false"/>
        <sql-type jdbc-type="VARCHAR" hibernate-type="java.lang.String"/>
        <sql-type jdbc-type="DATE" hibernate-type="java.util.Date"/>
        <sql-type jdbc-type="BINARY" hibernate-type="org.kobit.ofam.service.dao.hibernate.usertype.BinaryBlobType"/>
    </type-mapping>

    <table-filter match-name="BIN$.*" exclude="true"/>
    <table-filter match-name=".*_HLP" exclude="true"/>
    <table-filter match-name="CG_REF_CODES" exclude="true"/>
    <table-filter match-name=".*"/>

    <table name="ABFALL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Abfall_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ABFALL_AW_GRUPPE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Abfall_Aw_Gruppe_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ABFALL_EIGENSCHAFT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Abfall_Eigenschaft_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ABFALL_GRUPPE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Abfall_Gruppe_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ABFALL_GRUPPE_EWC" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Abfall_Gruppe_EWC_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ADRESSE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Adresse_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ADRESSE_AP" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Adresse_AP_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ADRESSE_ZUSATZ" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Adresse_Zusatz_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="BEHAELTER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Behaelter_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="BEHAELTER_SCANNER_TAG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Behaelter_Scanner_Tag_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="BENUTZER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Benutzer_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="BENUTZER_MAD" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Benutzer_MAD_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="BENUTZER_ROLLE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Benutzer_Rolle_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="BERICHTE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Berichte_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="BEWERTUNG_SCANNER_TAG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Bewertung_Scanner_Tag_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="DIENSTLEISTUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Dienstleistung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="DOKUMENTE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Dokumente_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_ABFALL_EINSTUFUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Abfall_Einstufung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_ADRESSE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Adresse_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_ADRESSE_ZUSATZ" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Adresse_Zusatz_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_ANFALLBEREICH" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Anfallbereich_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_BEHAELTER_ART" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Behaelter_Art_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_BEHAELTER_TYP" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Behaelter_Typ_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_BEREICH" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Bereich_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_BERICHTE_GRUPPE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Berichte_Gruppe_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_BEWERTUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Bewertung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_DOKUMENT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Dokument_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_EIGENSCHAFT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Eigenschaft_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_EIGENSCHAFT_TYP" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Eigenschaft_Typ_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_EINHEIT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Einheit_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_FARBE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Farbe_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_FEHLER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Fehler_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_FERTIGUNGSBEREICH" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Fertigungsbereich_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_KOSTEN" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Kosten_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_KOSTEN_GRUPPE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Kosten_Gruppe_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_NACHWEIS" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Nachweis_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_OUTPUT_STATUS" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Output_Status_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_SCANNER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Scanner_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_SCANNER_FORMAT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Scanner_Format_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_STELLPLATZ" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Stellplatz_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_VERFAHREN" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Verfahren_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ERKL_VERFAHREN_TYP" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Erkl_Verfahren_typ_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="EWC" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">EWC_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="EWC_GRUPPE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">EWC_Gruppe_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="EWC_KAPITEL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">EWC_Kapitel_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="FRACHTTABELLE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Frachttabelle_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="GEBAEUDE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Gebaeude_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="HK_KLASSE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">HK_Klasse_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="HK_STAFFELPREISE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">HK_Staffelpreise_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="INPUT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Input_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="INPUT_SCANNER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Input_Scanner_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="INPUT_SCANNER_FEHLER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Input_Scanner_Fehler_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="INPUT_SCANNER_TAG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Input_Scanner_Tag_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="KATASTER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Kataster_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="KATASTER_VERTEILUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Kataster_Verteilung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="KOSTENVERTEILUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Kostenverteilung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="KOSTENVERTEILUNG_DETAIL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Kostenverteilung_Detail_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="KUNDE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Kunde_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="LAND" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Land_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="MANDANT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Mandant_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="NACHWEIS" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Nachweis_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ORGANISATION_EBENE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Organisation_Ebene_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ORGANISATION_EIGENSCHAFT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Organisation_Eigenschaft_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ORGANISATION_EINHEIT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Organisation_Einheit_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="ORGANISATION_STRUKTUR" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Organisation_Struktur_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="OUTPUT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Output_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="OUTPUT_ANTEIL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Output_Anteil_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="OUTPUT_PREISPROFIL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Output_Preisprofil_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="PARAMETER_APP" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Parameter_App_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="PARAMETER_SYS" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Parameter_Sys_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="PREISVORGABE_OUTPUT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Preisvorgabe_Output_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="PREISVORGABE_OUTPUT_DETAIL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Preisvorgabe_Output_Detail_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="PREISVORGABE_RECHNUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Preisvorgabe_Rechnung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="PREISVORGABE_RECHNUNG_DETAIL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Preisvorgabe_Rechnung_Detail_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="RECHNUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Rechnung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="RECHNUNG_PREISPROFIL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Rechnung_Preisprofil_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="RESSOURCE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Ressource_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="RESSOURCECONTROL" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">RessourceControl_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="RESTE_VERTEILUNG" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Reste_Verteilung_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="RESTE_VERTEILUNG_ANT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Reste_Verteilung_ANT_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="SCANNER" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Scanner_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="SPRACHE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Sprache_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="STANDORT" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Standort_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="STELLPLATZ" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Stellplatz_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="UNFALL_MB" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Unfall_MB_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="UNFALL_MB_DOKUMENTE" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Unfall_MB_Dokumente_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>

    <table name="WERK" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Werk_id</param>
            </generator>
            <key-column name="ID"/>
        </primary-key>
    </table>


    <table name="ABFALL_GRUPPE_LIST" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Abfall_Gruppe_id</param>
            </generator>
            <key-column name="ABFALL_GRUPPE_ID"/>
        </primary-key>
    </table>

    <table name="ABFALL_LIST" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Abfall_id</param>
            </generator>
            <key-column name="ABFALL_ID"/>
        </primary-key>
    </table>

    <table name="ADRESSE_LIST" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Adresse_id</param>
            </generator>
            <key-column name="ADRESSE_HLP_ADRESSE_ID"/>
        </primary-key>
    </table>

    <table name="BEHAELTER_LIST" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Behaelter_id</param>
            </generator>
            <key-column name="BEHAELTER_ID"/>
        </primary-key>
    </table>

    <table name="INPUT_LIST" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Input_id</param>
            </generator>
            <key-column name="INPUT_ID"/>
        </primary-key>
    </table>

    <table name="NACHWEIS_LIST" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Nachweis_id</param>
            </generator>
            <key-column name="NACHWEIS_ID"/>
        </primary-key>
    </table>

    <table name="OUTPUT_LIST" schema="PUBLIC">
        <primary-key>
            <generator class="assigned">
                <param name="sequence">Output_id</param>
            </generator>
            <key-column name="OUTPUT_ID"/>
        </primary-key>
    </table>
</hibernate-reverse-engineering>


if I remove schema="PUBLIC" and <schema-selection match-schema="PUBLIC"/> it won't work with hsqldb... and I don't understand why because it should find in all schemas then...
Top
 Profile  
 
max
 Post subject:
PostPosted: Tue Jan 23, 2007 10:01 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 6:10 am
Posts: 8615
Location: Neuchatel, Switzerland (Danish)
no, it should not find all tables/schemas then. It will look for all those tables you listed but they are nowhere to be found since their schema name is null (or not-specified).

So you do as the line says you set hibernate.default_schema (in the properties you use with the tools) to your default schame, in this case PUBLC and hibernate will now be able to match them against your schema.

yes this can be improved (e.g. by assuming that defualt schema is public when all the schemas found are the same ;), but until then you just have to follow that line ;)

_________________
Max
Don't forget to rate

Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 4 posts ] 

Board index » Projects » Tools

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.