Changeset 674 for geisa/persistence


Ignore:
Timestamp:
11/30/12 15:18:18 (12 years ago)
Author:
npipsl
Message:

Connexion a MySQL avec C3P0

Location:
geisa/persistence/implementation
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • geisa/persistence/implementation/com/ether/dao/IsotopeG03DAOImpl.java

    r553 r674  
    1515import java.util.List; 
    1616import java.util.Set; 
     17 
    1718 
    1819/** 

  • geisa/persistence/implementation/hibernate.cfg.xml

    r671 r674  
    2020                <!--<prop key="hibernate.connection.username">postgres</prop>--> 
    2121                <!--<prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>--> 
     22                <!--<prop key="hibernate.generate_statistics">true</prop>--> 
     23                <!--<prop key="hibernate.connection.url">jdbc:mysql://localhost/geisa?autoReconnect=true</prop>--> 
     24 
     25 
     26                <!--<prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop> 
     27                <prop key="hibernate.connection.url">jdbc:mysql://localhost/geisa</prop> --> 
     28                <!-- en local--> 
     29               <!--  <prop key="hibernate.connection.username">root</prop>--> 
     30                <!-- sur naboo --> 
     31                <!--<prop key="hibernate.connection.username">geisa</prop>--> 
     32               <!-- <prop key="hibernate.connection.password">geisa11</prop> 
     33                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> 
     34                <prop key="hibernate.show_sql">true</prop> --> 
     35 
     36 
     37                <!-- configuration pool via c3p0--> 
     38               <prop key="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</prop> 
    2239                <prop key="hibernate.connection.driver_class">com.mysql.jdbc.Driver</prop> 
    23                 <!--<prop key="hibernate.connection.url">jdbc:mysql://localhost/geisa?autoReconnect=true</prop>--> 
    24                  <prop key="hibernate.connection.url">jdbc:mysql://localhost/geisa</prop> 
     40                <prop key="hibernate.connection.url">jdbc:mysql://localhost/geisa</prop> 
     41 
    2542                <!-- en local--> 
    2643                <prop key="hibernate.connection.username">root</prop> 
    2744                <!-- sur naboo --> 
    28                  <!--<prop key="hibernate.connection.username">geisa</prop> --> 
     45                <!--<prop key="hibernate.connection.username">geisa</prop>--> 
    2946                <prop key="hibernate.connection.password">geisa11</prop> 
    3047                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> 
    3148                <prop key="hibernate.show_sql">true</prop> 
    32                 <!--<prop key="hibernate.generate_statistics">true</prop>--> 
     49                <prop key="hibernate.c3p0.acquire_increment">1</prop><!-- Determines how many connections at a time c3p0 will try to acquire when the pool is exhausted--> 
     50                <prop key="hibernate.c3p0.idle_test_period">100</prop>  <!--seconds =idle time in seconds before a connection is automatically validated--> 
     51                <prop key="hibernate.c3p0.max_size">100</prop> <!--Taille maximale du pool--> 
     52                <prop key="hibernate.c3p0.min_size">10</prop> <!--Taille minimale du pool --> 
     53                <prop key="hibernate.c3p0.timeout">0</prop><!-- seconds / 0 never expire--> 
     54                <prop key="hibernate.c3p0.max_statements">0</prop><!--  Taille du cache de statements de C3P0. 0 = désactive le cache --> 
    3355 
    34                 <!-- configuration pool via c3p0--> 
    35  
    36  
    37                <!--  <prop key="hibernate.c3p0.acquire_increment">1</prop> 
    38                 <prop key="hibernate.c3p0.idle_test_period">100</prop> seconds --> 
    39                <!--  <prop key="hibernate.c3p0.max_size">100</prop> Taille maximale du pool --> 
    40                <!--  <prop key="hibernate.c3p0.min_size">10</prop> Taille minimale du pool --> 
    41                <!--  <prop key="hibernate.c3p0.timeout">0</prop> seconds / 0 =jamais--> 
    42                <!--  <prop key="hibernate.c3p0.max_statements">0</prop> Taille du cache de statements de C3P0. 0 = désactive le cache --> 
    43                <!--  <prop key="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</prop>--> 
    4456 
    4557            </props> 
    4658        </property> 
     59 
    4760        </bean> 
     61 
    4862 
    4963        <bean id="transactionManager" 
Note: See TracChangeset for help on using the changeset viewer.