<Resource name="jdbc/esup-helpdesk"
                    type="javax.sql.DataSource"
                    username="*********"
                    password="**************"
                    driverClassName="com.mysql.jdbc.Driver"
                    url="jdbc:mysql://**********/********?autoReconnect=true"
                    maxActive="100"
                    maxIdle="10"
                    maxWait="10000"
                    poolPreparedStatements="true"
                    removeAbandoned="true"
                    removeAbandonedTimeout="60"
                    logAbandoned="true"
                    validationQuery="select '1'"
                    validationInterval="30000"
                    timeBetweenEvictionRunsMillis="30000"
                    abandonWhenPercentageFull="50"
                    jdbcInterceptors="ResetAbandonedTimer"/>

<?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>
        <!--
                /properties/dao/hibernate/hibernate.cfg.xml
                The main Hibernate configuration file.
                It is referenced from /properties/dao/dao.xml
                and the database mapping is in folder
                /properties/dao/hibernate/mapping.
        -->
        <session-factory>
                <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
                <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
                <property name="hibernate.connection.datasource">java:/comp/env/jdbc/esup-helpdesk</property>
                <property name="hibernate.connection.autocommit">false</property>
                <property name="hibernate.connection.charSet">UTF-8</property>
                <property name="hibernate.show_sql">false</property>
                <property name="hibernate.bytecode.use_reflection_optimizer">false</property>
                <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
                <property name="connection.autoReconnectForPools">true</property>
                <property name="connection.is-connection-validation-required">true</property>
                <property name="connection.autoReconnect">true</property>
                <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
                <property name="hibernate.jdbc.fetch_size">25</property>
                <property name="hibernate.jdbc.batch_size">25</property>
                <property name="hibernate.jdbc.use_scrollable_resultset">true</property>
                <property name="hibernate.jdbc.use_streams_for_binary">true</property>
                <property name="hibernate.max_fetch_depth">1</property>
                <property name="hibernate.cache.use_query_cache">false</property>
                <property name="hibernate.cache.use_second_level_cache">false</property>
                <property name="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
                <property name="hibernate.current_session_context_class">thread</property>
                <property name="exposeTransactionAwareSessionFactory">false</property>
        <property name="dbcp.validationQuery">select 1</property>
        <property name="dbcp.testOnReturn">true</property>
        <property name="dbcp.testWhileIdle">true</property>
        <property name="dbcp.timeBetweenEvictionRunsMillis">10000</property>
        <property name="dbcp.numTestsPerEvictionRun">10</property>
        </session-factory>
</hibernate-configuration>