hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>
        <property name="hibernate.bytecode.use_reflection_optimizer">false</property>
        <property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
        <property name="hibernate.jdbc.batch_size">50</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/company_test?allowPublicKeyRetrieval=true</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">password</property>
        <property name="hibernate.connection.verifyServerCertificate">false</property>
        <property name="hibernate.connection.useSSL">false</property>
<!--        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>-->
<!--        <property name="connection.pool_size">50</property>-->
<!--        <property name="hibernate.validationQuery">SELECT 1</property>-->
<!--        <property name="hibernate.validationInterval">60000</property>-->
<!--        <property name="hibernate.testOnBorrow">true</property>-->
<!--                <property name="show_sql">true</property>-->
<!--        <property name="format_sql">true</property>-->
<!--        <property name="use_sql_comments">true</property>-->
<!--        <property name="hibernate.c3p0.min_size">5</property>-->
<!--        <property name="hibernate.c3p0.max_size">30</property>-->
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <property name="use_sql_comments">true</property>
        <property name="hibernate.c3p0.min_size">5</property>
        <property name="hibernate.c3p0.max_size">20</property>
        <property name="hibernate.c3p0.acquire_increment">1</property>
        <property name="hibernate.c3p0.timeout">1800</property>
        <property name="hibernate.c3p0.max_statements">50</property>
        <property name="hibernate.c3p0.idle_test_period">3000</property>
        <property name="hibernate.connection.provider_class">org.hibernate.c3p0.internal.C3P0ConnectionProvider</property>

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

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

<!--        &lt;!&ndash; Echo all executed SQL to stdout &ndash;&gt;-->
<!--        <property name="show_sql">true</property>-->

<!--        &lt;!&ndash; Format the generated Sql &ndash;&gt;-->
<!--        <property name="format_sql">true</property>-->

        <!-- Dont Drop and re-create the database schema on startup,Just update
            it -->
        <property name="hbm2ddl.auto">update</property>

        <mapping class="com.phantom.db.mapping.User"></mapping>
        <mapping class="com.phantom.db.mapping.UserLoginInfo"></mapping>
        <mapping class="com.phantom.db.mapping.CheckInOut"></mapping>
        <mapping class="com.phantom.db.mapping.UserLeaveApplication"></mapping>
        <mapping class="com.phantom.db.mapping.Shift"></mapping>
        <mapping class="com.phantom.db.mapping.UserShiftMapping"></mapping>
        <mapping class="com.phantom.db.mapping.OverTimePolicy"></mapping>
        <mapping class="com.phantom.db.mapping.AttendanceDaily"></mapping>
        <mapping class="com.phantom.db.mapping.AttendanceDailyLegal"></mapping>
        <mapping class="com.phantom.db.mapping.Holiday"></mapping>
        <mapping class="com.phantom.db.mapping.WeeklyOff"></mapping>
        <mapping class="com.phantom.db.mapping.LeavePolicy"></mapping>
        <mapping class="com.phantom.db.mapping.Category"></mapping>
        <mapping class="com.phantom.db.mapping.UserLeave1"></mapping>
        <mapping class="com.phantom.db.mapping.UserPastExperience"></mapping>
        <mapping class="com.phantom.db.mapping.UserQualification"></mapping>
        <mapping class="com.phantom.db.mapping.ShiftDeduction"></mapping>
        <mapping class="com.phantom.db.mapping.Cadre"></mapping>
        <mapping class="com.phantom.db.mapping.Division"></mapping>
        <mapping class="com.phantom.db.mapping.SubDivision"></mapping>
        <mapping class="com.phantom.db.mapping.Department"></mapping>
        <mapping class="com.phantom.db.mapping.SubDepartment"></mapping>
        <mapping class="com.phantom.db.mapping.CostCenter"></mapping>
        <mapping class="com.phantom.db.mapping.Designation"></mapping>
        <mapping class="com.phantom.db.mapping.Location"></mapping>
        <mapping class="com.phantom.db.mapping.Company"></mapping>
        <mapping class="com.phantom.db.mapping.IdentityAction"></mapping>
        <mapping class="com.phantom.db.mapping.IdentityUser"></mapping>
        <mapping class="com.phantom.db.mapping.IdentityResource"></mapping>
        <mapping class="com.phantom.db.mapping.IdentityUserActionMapping"></mapping>
        <mapping class="com.phantom.db.mapping.WeeklyOffPolicy"></mapping>
        <mapping class="com.phantom.db.mapping.UserWeeklyOffOverride"></mapping>
        <mapping class="com.phantom.db.mapping.CheckInOutOverride"></mapping>
        <mapping class="com.phantom.db.mapping.UserLeaveRegister"></mapping>
        <mapping class="com.phantom.db.mapping.UserEL"></mapping>
        <mapping class="com.phantom.db.mapping.UserFamilyDetails"></mapping>
        <mapping class="com.phantom.db.mapping.GeoFencingConfig"></mapping>
        <mapping class="com.phantom.db.mapping.ShiftRotation"></mapping>
        <mapping class="com.phantom.db.mapping.UserGatePass"></mapping>
        <mapping class="com.phantom.db.mapping.UserExtraDuty"></mapping>
        <mapping class="com.phantom.db.mapping.OT1"></mapping>


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