Jboss,tomcat数据源配置

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>