Jboss,tomcat数据源配置

chunjihong

　　Jboss-Oracle数据源：【参照jboss/docs/examples/jca 目录下oracle-ds.xml文件】

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>DataSourceName</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:bee</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>username</user-name>
<password>password</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>2</min-pool-size>
<max-pool-size>10</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<metadata>
<type-mapping>Oracle</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

　　

然后把该oracle-ds.xml copy到对应的deploy目录下！


同理Jboss-Mysql数据源：【参照jboss/docs/examples/jca 目录下mysql-ds.xml文件】

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>njepg</jndi-name>
<connection-url>jdbc:mysql://localhost:3306/database?useUnicode=true&amp;characterEncoding=UTF8&amp;jdbcCompliantTruncation=false</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>root</user-name>
<password>root</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>   
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<min-pool-size>200</min-pool-size>
<max-pool-size>200</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
 　　然后把该mysql-ds.xml copy到对应的deploy目录下！
　　数据源配置成功之后你可以在http://localhost/jmx-console/ 例如我这里看到的：

jboss.jdbc

• 
  datasource=DefaultDS,service=metadata
  
• 
  datasource=njepg,service=metadata
  
• 
  datasource=smsservice,service=metadata
  
• 
  service=SQLExceptionProcessor
  
• 
  service=metadata
  

　　MySQL数据源配置：【找到tomcat/conf/server.xml中的GlobaNamingResources节点】


<GlobalNamingResources>
<Environment name="simpleValue" type="java.lang.Integer" value="30"/>
<Resource
name="jdbc/mysql"
type="javax.sql.DataSource"
maxActive="200"
maxIdle="2"
username="root"
maxWait="5000"
validationQuery="select 1"
driverClassName="com.mysql.jdbc.Driver"
password="root"
url="jdbc:mysql://localhost:3306/njepg?useUnicode=true&amp;amp;characterEncoding=UTF-8&amp;amp;jdbcCompliantTruncation=false"/>
<Resource
name="jdbc/smsservice"
type="javax.sql.DataSource"
maxActive="5"
maxIdle="2"
username="visiontv"
maxWait="5000"
validationQuery="select * from dual"
driverClassName="oracle.jdbc.OracleDriver"
password="visiontv"
url="jdbc:oracle:thin:@localhost:1521:bee"
/>
</GlobalNamingResources>