Configure the MySQL Data Source in JBoss AS7

 

AS7 Mo? Recognize? ? Number? Data? Source? Yes? H2, though? Why? H2 party? Right ?, But? Yes? I? ? ? Born? Production? Ring? Environment? All? Yes? MySQL ,? ORACLE ,? SQL Server residence? Many ?, Ben? Text? ? ? Such? What? In? AS7? Set? MySQL count? Data? Source ?.?

Root? Data? Jboss club? Zone? ? Text? ?, Configuration? Set? I? ? New? ? Number? Data? Source? Big? To? Points? Is it? Two? Step ?.? ? ? Such? Lower? :

Jia? Incoming? JDBC drive? Dynamic? Text? ?

 

In? JBOSS_HOME/modules? ? Lower? Jia? Incoming? Such? Lower? Object? ? End? Structure? And? Text? ? :

JBOSS_HOME

+-Modules

+-Com

+-Mysql

+-Main

+-Module. xml

+-Mysql-connector-java-5.1.15.jar (mysql jdbc driver jar file, version depends on their situation)

-Mysql-connector-java-5.1.15.jar.index

Module. xml? Inner? Rong? Such? Lower? :

Example 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>

 

 

The mysql-connector-java-5.1.15.jar.index? Inner? Rong? Such? Lower? :

Example 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

 

 

Tian? Jia? Number of servers? Data? Source? Configuration? Set?

 

AS7 startup? Dynamic? Points? Is it? Two? ? Shape? Formula ?, I? ? Yes? Domain? ? ?, I? ? Yes? Standalone, this? In? Me? ? Select? ? Standalone .?

? Open? JBOSS_HOME \ standalone \ configuration \ standalone. xml? ?, In? <Datasources> bottom? Tian? Jia? Such? Lower? Inner? Rong? :

Example 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>

 

 

Why? After? In? <Drivers> lower? Tian? Jia? Such? Lower? Inner? Rong? :

Example 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>

 

 

OK, this? ? ? ? Cheng? ? MySQL count? Data? Source? ? Configuration? Set ?, Now? In? Use? Standalone? Shape? ? Qi? Dynamic? AS7, yes? Look? To? Lost? Incoming? Medium? Yes? MySQL count? Data? Source? ? ? Inner? Rong ?, Such? Lower? Figure? :