Spec: 数据库连接池（v1.0).txt

        ÊýŸÝ¿âÁ¬œÓ³ØÍÆŒöÅäÖ㺠

        ÈçÎÞÌرð˵Ã÷£¬ÊýŸÝ¿âÅäÖÃÓŠžÃÓ뱟ʟÀýÎĵµÏàËÆ£¬ Õë¶ÔijЩӊÓÃÐèÒªÖƶšÌضš²ÎÊýµÄ£¬Çë×Éѯ¿ª·¢£¬²âÊÔͬÊ£¬Ÿ¡Á¿±£Ö€ÏßÉÏÅäÖÃÓë²âÊÔ»·Ÿ³ÅäÖÃÏàͬ¡£ 


        ž÷žöÊýŸÝ¿âÁ¬œÓ ËùÐèÒªµÄÇý¶¯£¬ÈçÎÞÌØÊâ˵Ã÷£¬ ÓŠŸ¡Á¿±£³ÖÓë²âÊÔ»·Ÿ³Ò»Ö¡£ 


1. mysql:


1£© ÍÆŒöÓ÷š£º 

        <database>
                <jndi-name>jdbc/cosme</jndi-name>
                <driver>
                        <type>com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource</type>
                        <url>jdbc:mysql://192.168.74.10:3306/lady_cosme?useUnicode=true&amp;characterEncoding=GBK</url>
                        <user>lady_cosme</user>
                        <password>lady_cosme</password>
                </driver>
                <prepared-statement-cache-size>10</prepared-statement-cache-size>
                <max-connections>30</max-connections>
                <max-idle-time>120s</max-idle-time>
            </database>



2£©Õë¶ÔŸÉÓŠÓ㬿ÉÄܲ»Ö§³ÖÉÏÃæµÄÐŽ·š£¬¶ÔÓÚÐèÒª²ÉÓßÉÐŽ·šµÄÇé¿öÏÂÇë×ÉѯÏîÄ¿¿ª·¢£¬²âÊÔ£¬Œ°dba ͬÊÂÈ·ÈϺ󷜿ÉʹÓᣠ

   ŸÉÐŽ·š£º 

        <database>
        <jndi-name>jdbc/game</jndi-name>
        <driver type="org.gjt.mm.mysql.Driver">
                <url>jdbc:mysql://192.168.237.25:3306/gamesproduct_app</url>
                <user></user>
                <password></password>
        </driver>
        <max-connections>10</max-connections>
        <max-idle-time>120s</max-idle-time>
    </database>



3£© ¶ÔÓÚÅäÖà ÔÚÓŠÓÃÖеÄÅäÖ㬠xx.properties ÕâÖÖžñÊœµÄÎÄŒþµÄÅäÖõÄÒ»žöÊŸÀý£º  

Èç¹ûÐèÒªÅäÖÃÕâÖÖÐŽ·š£¬Çë×ÉѯÏîÄ¿¿ª·¢ £º


        # pcgames
        db_games_download.url=jdbc:mysql://192.168.238.144/DLcenter?user=user&password=passwd&usingUnicode=true&characterEncoding=gbk

  
2.oracle£º 

1£© ¶ÔÓÚthin ¿Í»§¶ËµÄÐŽ·š£º 


        <database ping='true' ping-table='dual'>
           <jndi-name>jdbc/common2DataSource</jndi-name>
           <driver>
           <type>oracle.jdbc.pool.OracleConnectionPoolDataSource</type>
           <url>jdbc:oracle:thin:@192.168.239.110:1521:v880</url>
             <user></user>
             <password></password>
            </driver>
            <prepared-statement-cache-size>10</prepared-statement-cache-size>
            <max-connections>20</max-connections>
            <max-idle-time>120s</max-idle-time>
         </database>



2£©¶ÔÓÚÅäÖà ÔÚÓŠÓÃÖеÄÅäÖ㬠xx.properties ÕâÖÖžñÊœµÄÎÄŒþµÄÅäÖõÄÒ»žöÊŸÀý£º  

Èç¹ûÐèÒªÅäÖÃÕâÖÖÐŽ·š£¬Çë×ÉѯÏîÄ¿¿ª·¢ Õâ¶ÎΪoci µÄÅäÖ÷œÊœ


        torque.database.default=product

        torque.database.marking.adapter=oracle
        torque.dsfactory.marking.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
        torque.dsfactory.marking.pool.maxActive=5
        torque.dsfactory.marking.connection.driver = oracle.jdbc.OracleDriver
        torque.dsfactory.marking.connection.url = jdbc:oracle:oci8:@product
        torque.dsfactory.marking.connection.user = product_app
        torque.dsfactory.marking.connection.password = product_app




ʹÓÃthin ÊÝ¿Í»§¶ËµÄÅäÖ÷œÊœÊŸÀýÎıŸ£º
# pcauto
db_auto_bbs.url=jdbc:oracle:thin:bbs4_auto_app/bbs4_auto_app@192.168.10.248:1521:test239


# pcla
3£© ¶ÔÓÚoracle RAC  ÊýŸÝ¿âŒ¯ÈºµÄÁ¬œÓ³ØÐŽ·š£º 

        oracle RAC  ÐèҪʹÓÃÌضšµÄ¿Í»§¶Ë¹€Ÿß£¬Ê¹ÓÃociÇý¶¯£¬Ö§³ÖžºÔØŸùºâ£¬ÔÖ±žÇл»Ä£Êœ¡£ŽËÀàÅäÖÃÐèÒª×Éѯdba£¬¿ª·¢£¬²âÊÔ È·ÈϺ󷜿Éʵʩ¡£  



        
            <database>
            <jndi-name>jdbc/product</jndi-name>
            <driver>
                <type>oracle.jdbc.pool.OracleConnectionPoolDataSource</type>
                  <url>jdbc:oracle:oci8:@product</url>
                <user>product_app</user>
                <password>product_app</password>
            </driver>
            <prepared-statement-cache-size>30</prepared-statement-cache-size>
            <max-connections>30</max-connections>
            <max-idle-time>120s</max-idle-time>
        </database>




        ÕâžöÐŽ·šÐèÒªÅäÖÃÒ»žötnsnames.ora µÄÅäÖÃÎÄŒþ·Åµœ oracle ¿Í»§¶ËµÄÄ¿ÂŒÏÂÃæÊŸÀýÐŽ·šÈçÏ£º 



        racdb=
        (DESCRIPTION=
           (FAILOVER=ON)
           (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.236.46)(PORT=1521))
           (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = racdb.pconline.cn)
              (FAILOVER_MODE= (TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=5))
           )
        )
        product=
        (DESCRIPTION=
           (FAILOVER=ON)
           (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.205)(PORT=1521))
           (CONNECT_DATA =
              (SERVER = DEDICATED)
              (SERVICE_NAME = product.pconline.cn)
              (FAILOVER_MODE= (TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=5))
           )
        )












3.postgresqlÐŽ·š£º 

        

        <database>
         <jndi-name>jdbc/cms5</jndi-name>
                <driver type="org.postgresql.Driver">
                 <url>jdbc:postgresql://192.168.74.10:5432/pcauto?useUnicode=true&amp;characterEncoding=GBK</url>
                <user>pcauto</user>
                <password>pcauto</password>
                 </driver>
                 <prepared-statement-cache-size>10</prepared-statement-cache-size>
                <max-connections>30</max-connections>
                <max-idle-time>120s</max-idle-time>
        </database>
 



4.mongodb £º 



      <env-entry>
        <description>MongoDB Config</description>
        <env-entry-name>mongoConfig4RClient</env-entry-name>
        <env-entry-type>java.lang.String</env-entry-type>
        <env-entry-value>mongodb://price_front_app:mongoprice_front_app@192.168.237.81:5506,192.168.237.92:5506,192.168.237.2
32:5506,192.168.237.243:5506,192.168.236.98:5506/price_front_cache?replicaSet=itpricelib;slaveOk=true;maxPoolSize=128;w=1</en
v-entry-value>
      </env-entry>