JBoss中怎么配置MySQL数据源,相信很多没有经验的人对此束手无策,为此本文总结了问题出现的原因和解决方法,通过这篇文章希望你能解决这个问题。
JBOSS_HOME
+- modules
+- com
+-
+- main
+- module.xml
+- mysql-connector-java-5.1.15.jar (mysql的jdbc驱动jar文件,版本根据各自情况而定)
+- mysql-connector-java-5.1.15.jar.index
module.xml的?内?容?如?下?:
例1. module.xml
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java-5.1.15.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
</dependencies>
</module>
mysql-connector-java-5.1.15.jar.index的?内?容?如?下?:
例2. mysql-connector-java-5.1.15.jar.index
META-INF
META-INF/services
com
com/mysql
com/mysql/jdbc
com/mysql/jdbc/configs
com/mysql/jdbc/exceptions
com/mysql/jdbc/exceptions/jdbc4
com/mysql/jdbc/interceptors
com/mysql/jdbc/jdbc2
com/mysql/jdbc/jdbc2/optional
com/mysql/jdbc/jmx
com/mysql/jdbc/log
com/mysql/jdbc/profiler
com/mysql/jdbc/util
org
org/gjt
org/gjt/mm
org/gjt/mm/mysql
添?加?Server数?据?源?配?置?
AS7启?动?分?为?两?种?形?式?,一?种?是?domain形?式?的?,一?种?是?standalone,这?里?我?们?选?择?standalone。?
打?开?JBOSS_HOME\standalone\configuration\standalone.xml文?件?,在?<datasources>下?添?加?如?下?内?容?:
例3. mysql-connector-java-5.1.15.jar.index
<datasource jndi-name="java:jboss/datasources/MySqlDS" pool-name="MySqlDS" enabled="true" jta="true" use-java-context="true" use-ccm="true">
<connection-url>
jdbc:mysql://192.168.1.150:3306/hospital?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8
</connection-url>
<driver>
com.mysql
</driver>
<transaction-isolation>
TRANSACTION_READ_COMMITTED
</transaction-isolation>
<pool>
<min-pool-size>
10
</min-pool-size>
<max-pool-size>
100
</max-pool-size>
<prefill>
true
</prefill>
<use-strict-min>
false
</use-strict-min>
<flush-strategy>
FailingConnectionOnly
</flush-strategy>
</pool>
<security>
<user-name>
runes
</user-name>
<password>
runes
</password>
</security>
<statement>
<prepared-statement-cache-size>
32
</prepared-statement-cache-size>
</statement>
</datasource>
例4. mysql-connector-java-5.1.15.jar.index
<driver name="com.mysql" module="com.mysql">
<xa-datasource-class>
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
</xa-datasource-class>
</driver>
看完上述内容,你们掌握JBoss中怎么配置MySQL数据源的方法了吗?如果还想学到更多技能或想了解更多相关内容,欢迎关注亿速云行业资讯频道,感谢各位的阅读!