gistfile1.txt

<?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 -->
		<property name="connection.driver_class">org.gjt.mm.mysql.Driver</property>
		<property name="connection.url">jdbc:mysql://localhost/testdatabase</property>
		<property name="connection.username">user_name</property>
		<property name="connection.password">password</property>
        
        <!-- c3p0 config http://www.hibernate.org/214.html -->
        <property name="connection.provider_class">org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider</property>
        <property name="hibernate.c3p0.min_size">1</property>
        <property name="hibernate.c3p0.max_size">100</property>
        <property name="hibernate.c3p0.max_statements">50</property>
        <property name="hibernate.c3p0.timeout">360</property>
        <property name="hibernate.c3p0.acquire_increment">1</property>
        <property name="hibernate.c3p0.idle_test_period">300</property>
        <property name="hibernate.c3p0.preferredTestQuery">select *;</property>
        <property name="hibernate.c3p0.acquireRetryAttempts">2</property>
        <property name="hibernate.c3p0.acquireRetryDelay">250</property>

		<!-- SQL dialect -->
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        
        <!-- Echo all executed SQL to stdout -->
		<property name="show_sql">false</property>

		<property name="current_session_context_class">thread</property>
		
		<!-- Drop and re-create the database schema on startup -->
        <property name="hibernate.hbm2ddl.auto">update</property>

        <!-- Mapping -->
		<mapping resource="transaction.hbm.xml" />
		<mapping resource="salem_batch_status.hbm.xml" />
        <mapping resource="refunded_items.hbm.xml" />
        <mapping resource="platform_record.hbm.xml" />
        <mapping resource="capture_record.hbm.xml" />
	</session-factory>
</hibernate-configuration>