Hibernate configuration file (.cfg.xml) for mapping multiple MySQL tables in the same database?

Question

I am experimenting with Hibernate for my Java web app. The following is part of my hibernate.cfg.xml, and I wondering how to map multiple database tables in the same configuration file. I use annotations to map my models to mysql database table, and I have multiple model classes (for example: models.Book), how to map the models in hibernate.cfg.xml?

<hibernate-configuration>
    <session-factory>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/test_db</property>
        <property name="connection.username">root</property>
        <property name="connection.password">xxx</property>

        <property name="connection.pool_size">1</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="current_session_context_class">thread</property>
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        <property name="show_sql">true</property>
        <property name="hbm2ddl.auto">validate</property>

        <mapping class ="models.Category" />

    </session-factory>
</hibernate-configuration>

I am also trying to do the same thing. Did you find the solution @TonyGW — want2learn
– want2learn, Commented Mar 28, 2015 at 22:25

dvk317960 · Accepted Answer · 2014-06-06 20:44:23Z

6

We should not specify mappings in cfg.xml file. It has to be done by either annotations or XML. For Annotations: The cfg.xml file that is provided by you looks ok, if we are using the annotations to indicate database mappings with entity classes.

To use XML way of mapping between Entities and Tables, an hbm.xml file needs to be created and in that case, Replace

<mapping class ="models.Category" />

with something like

<mapping resource="models/Book.hbm.xml></mapping>

and hbm.xml file contains the necessary mapping as follows. for example:

   <hibernate-mapping>
    <class name="models.Book" table="Book" catalog="your database name">
        <id name="bookId" type="java.lang.Integer">
            <column name="BOOKID" />
            <generator class="identity" />
        </id>
        <property name="authorName" type="string">
            <column name="AUTHOR_NAME" length="10" not-null="true" unique="true" />
        </property>
    </class>//all the database mappings
</hibernate-mapping>

Sorry, if I understand your question wrongly.

answered Jun 6, 2014 at 20:44

dvk317960

8227 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

TonyW Over a year ago

thanks, but I don't use xml to map my class to database table. Instead I use annotations on my entities such as Book.

Aviro Over a year ago

@TonyGW - Please refer below link to extensively understand the annotations based mapping with detailed examples. link

WesternGun Over a year ago

Well, if I am understanding this right, we have Hibernate annotations and JPA annotations, similar but different. You can always check this link to see more details: doc.

pratap reddy · Accepted Answer · 2015-05-27 18:49:24Z

1

WE can't configure the multiple databases in single configuration file.if we use multiple databases we have to use multiple configuration file. in respective tables we can configure in respective configuration file.

answered May 27, 2015 at 18:49

pratap reddy

111 bronze badge

Collectives™ on Stack Overflow

Hibernate configuration file (.cfg.xml) for mapping multiple MySQL tables in the same database?

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related