利用c3p0配置数据库连接

利用c3p0配置数据库连接

一.连接mysql数据库

< bean  id ="dataSource"
        class ="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method ="close"  abstract ="false"  singleton ="true"
        lazy-init ="default"  autowire ="default"  dependency-check ="default" >
         < property  name ="driverClass" >
             < value > com.mysql.jdbc.Driver </ value >
         </ property >
         < property  name ="jdbcUrl" >
             < value > jdbc:mysql://192.168.0.1/databasename?useUnicode=true &amp; characterEncoding=utf-8 &amp; autoReconnect=true </ value >
         </ property >
         < property  name ="user" >
             < value > username </ value >
         </ property >
         < property  name ="password" >
             < value > password </ value >
         </ property >
         < property  name ="minPoolSize" >
             < value > 10 </ value >
         </ property >
         < property  name ="maxPoolSize" >
             < value > 20 </ value >
         </ property >
         < property  name ="initialPoolSize" >
             < value > 10 </ value >
         </ property >
     </ bean >
     < bean  id ="sessionFactory"
        class ="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
         < property  name ="dataSource" >
             < ref  bean ="dataSource" ></ ref >
         </ property >
         < property  name ="hibernateProperties" >
             < props >
                 < prop  key ="hibernate.dialect" >
                    org.hibernate.dialect.MySQLDialect
                 </ prop >
                 < prop  key ="hibernate.show_sql" >
                    false
                 </ prop >
                 < prop  key ="hibernate.generate_statistics" > true </ prop >
                 < prop  key ="hibernate.cache.use_query_cache" >
                    true
                 </ prop >
                 < prop  key ="hibernate.cache.use_second_level_cache" >
                    true
                 </ prop >
                 < prop  key ="hibernate.cache.provider_class" >
                    net.sf.ehcache.hibernate.EhCacheProvider
                 </ prop >
                 < prop  key ="hibernate.connection.provider_class" >
                    org.hibernate.connection.C3P0ConnectionProvider
                 </ prop >
                 < prop  key ="hibernate.query.substitutions" >
                    true 1, false 0, yes 'Y', no 'N'
                 </ prop >
                 < prop
                     key ="hibernate.bytecode.use_reflection_optimizer" >
                    true
                 </ prop >
                 < prop  key ="hibernate.use_outer_join" > true </ prop >
                 < prop  key ="hibernate.prepare_sql" > true </ prop >
                 < prop  key ="hibernate.query.factory_class" >
                    org.hibernate.hql.ast.ASTQueryTranslatorFactory
                 </ prop >
             </ props >
         </ property >

         < property  name ="mappingResources" >
             < list >
                 < value > xxx/xx/xx.hbm.xml </ value >
                 < value > xxx/xx/xx.hbm.xml </ value >
             </ list >
         </ property >
     </ bean >

二.连接Oracle数据库

< bean  id ="dataSource"
        class ="com.mchange.v2.c3p0.ComboPooledDataSource"
        destroy-method ="close"  abstract ="false"  singleton ="true"
        lazy-init ="default"  autowire ="default"  dependency-check ="default" >
         < property  name ="driverClass" >
             < value > oracle.jdbc.driver.OracleDriver </ value >
         </ property >
         < property  name ="jdbcUrl" >
             < value > jdbc:oracle:thin:@192.168.0.1:1521:orcl </ value >
         </ property >
         < property  name ="user" >
             < value > username </ value >
         </ property >
         < property  name ="password" >
             < value > password </ value >
         </ property >
         < property  name ="minPoolSize" >
             < value > 10 </ value >
         </ property >
         < property  name ="maxPoolSize" >
             < value > 20 </ value >
         </ property >
         < property  name ="initialPoolSize" >
             < value > 10 </ value >
         </ property >
     </ bean >

     < bean  id ="sessionFactory"
        class ="org.springframework.orm.hibernate3.LocalSessionFactoryBean" >
         < property  name ="dataSource" >
             < ref  bean ="dataSource" ></ ref >
         </ property >
         < property  name ="hibernateProperties" >
             < props >
                 < prop  key ="hibernate.dialect" >
                    org.hibernate.dialect.OracleDialect
                 </ prop >
                 < prop  key ="hibernate.show_sql" >
                    false
                 </ prop >
                 < prop  key ="hibernate.generate_statistics" > true </ prop >
                 < prop  key ="hibernate.cache.use_query_cache" >
                    true
                 </ prop >
                 < prop  key ="hibernate.cache.use_second_level_cache" >
                    true
                 </ prop >
                 < prop  key ="hibernate.cache.provider_class" >
                    net.sf.ehcache.hibernate.EhCacheProvider
                 </ prop >
                 < prop  key ="hibernate.connection.provider_class" >
                    org.hibernate.connection.C3P0ConnectionProvider
                 </ prop >
                 < prop  key ="hibernate.query.substitutions" >
                    true 1, false 0, yes 'Y', no 'N'
                 </ prop >
                 < prop
                     key ="hibernate.bytecode.use_reflection_optimizer" >
                    true
                 </ prop >
                 < prop  key ="hibernate.use_outer_join" > true </ prop >
                 < prop  key ="hibernate.prepare_sql" > true </ prop >
                 < prop  key ="hibernate.query.factory_class" >
                    org.hibernate.hql.ast.ASTQueryTranslatorFactory
                 </ prop >
             </ props >
         </ property >

         < property  name ="mappingResources" >
             < list >
                 < value > xxx/xx/xx.hbm.xml </ value >
                 < value > xxx/xx/xx.hbm.xml </ value >
             </ list >
         </ property >
     </ bean >