Pages

Wednesday, September 12, 2012

Hibernate configuration for mysql in hibernate 4.0

this is the normal configuration of a hibernate.cfg.xml in hibernate 4

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

<!-- Database connection settings. hibernatedb is my database name. you can choose anything you want -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/hibernatedb</property>
<property name="connection.username">root</property>
<property name="connection.password">pass</property>

<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>

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



<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>

<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>

<!-- this will create tables each time it runs. you can use update etc... -->
<property name="hbm2ddl.auto">create</property>

<!-- object models -->
<mapping class="mad.hibernatekid.dto.UserDetails"/>

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

No comments:

Post a Comment