利用"c3p0"配置数据库连接的实例脚本

来源：赛迪网    作者：39703

一.连接MySQL数据库

        
            com.mysql.jdbc.Driver
        
        
            jdbc:mysql://192.168.0.1/databasename?

      useUnicode=true&characterEncoding=utf-8&

      autoReconnect=true
        
        
            username
        
        
            password
        
        
            10
        
        
            20
        
        
            10
        
    
    
        
            
        
        
            
                
                    org.hibernate.dialect.MySQLDialect
                
                
                    false
                
                true
                
                    true
                
                
                    true
                
                
                    net.sf.ehcache.hibernate.EhCacheProvider
                
                
                    org.hibernate.connection.C3P0ConnectionProvider
                
                
                    true 1, false 0, yes 'Y', no 'N'
                
                
                    true
                
                true
                true
                
                    org.hibernate.hql.ast.ASTQueryTranslatorFactory
                
            
        

        
            
                xxx/xx/xx.hbm.xml
                xxx/xx/xx.hbm.xml
            
        
    

二.连接Oracle数据库

        
            oracle.jdbc.driver.OracleDriver
        
        
            jdbc:oracle:thin:@192.168.0.1:1521:orcl
        
        
            username
        
        
            password
        
        
            10
        
        
            20
        
        
            10
        
    

    
        
            
        
        
            
                
                    org.hibernate.dialect.OracleDialect
                
                
                    false
                
                true
                
                    true
                
                
                    true
                
                
                    net.sf.ehcache.hibernate.EhCacheProvider
                
                
                    org.hibernate.connection.C3P0ConnectionProvider
                
                
                    true 1, false 0, yes 'Y', no 'N'
                
                
                    true
                
                true
                true
                
                    org.hibernate.hql.ast.ASTQueryTranslatorFactory
                
            
        

        
            
                xxx/xx/xx.hbm.xml
                xxx/xx/xx.hbm.xml