WordPress 中文文档

Jboss database setting

From WordPress Chinese

Jump to: navigation, search

== 连接池配置 ==


<datasources> 

<local-tx-datasource> 
  <jndi-name>STATDS</jndi-name> 
  <connection-url>jdbc:oracle:thin:@192.168.0.1:1521:SID</connection-url> 
  <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 
  <user-name>××××</user-name> 
  <password>×××××</password>

<min-pool-size>50</min-pool-size>
  <max-pool-size>200</max-pool-size>
  <blocking-timeout-millis>5000</blocking-timeout-millis>
  <idle-timeout-minutes>2</idle-timeout-minutes>

</local-tx-datasource>

</datasources> </pre>


以上代码是 xml文件的内容的一部分。这里所关注的是有关 pool size 和 timeout 的设置。关于如何写一个完整的连接池配置文件，在网上有一大堆。以后或许会更新到这里。




一个完整的 -ds.xml 文件 ( for oracle)



<?xml version="1.0" encoding="UTF-8"?> <datasources> 

               <local-tx-datasource>
       <jndi-name>/app001/ds/testds1</jndi-name>
               <connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url>
               <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>system</user-name>
       <password>syspass</password>
       <min-pool-size>50</min-pool-size>
       <max-pool-size>200</max-pool-size>
       <blocking-timeout-millis>5000</blocking-timeout-millis>
       <idle-timeout-minutes>2</idle-timeout-minutes>
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
       <metadata>
           <type-mapping>Oracle10g</type-mapping>
       </metadata>
   </local-tx-datasource>
   <xa-datasource>
       <jndi-name>/app001/ds/testds1(XA)</jndi-name>
       <track-connection-by-tx/>
       <isSameRM-override-value>false</isSameRM-override-value>
       <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
               <xa-datasource-property name="URL">jdbc:oracle:thin:@localhost:1521:orcl</xa-datasource-property>		
               <xa-datasource-property name="User">system</xa-datasource-property>
       <xa-datasource-property name="Password">syspass</xa-datasource-property>
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
       <no-tx-separate-pools/>
       <metadata>
           <type-mapping>Oracle10g</type-mapping>
       </metadata>
   </xa-datasource>

</pre>

取自"http://codex.wordpress.org.cn/Jboss_database_setting"
用户