¿Cómo cambiar a MySQL como gestor de BD en Jboss?

1. Eliminar el archivo hsqldb-persistence-service.xml ubicado en el directorio /usr/local/jboss/server/default/deploy/messaging/
2. Copiar el archivo mysql-persistence-service.xml ubicado en el directorio /usr/local/jboss/docs/examples/jms/examples/config/ al directorio /usr/local/jboss/server/default/deploy/messaging/
3. En el archivo mysql-persistence-service.xml cambiar <depends optional-attribute-name=”ChannelFactoryName”>jboss.jgroups:service=ChannelFactory</depends> por <attribute name=”ChannelFactoryName”>jboss.jgroups:service=ChannelFactory</attribute>
4. Eliminar el archivo hsqldb-ds.xml localizado en el directorio /usr/local/jboss/server/default/deploy/
5. En el directorio /usr/local/jboss/server/default/deploy/ crear el archivo mysql-ds.xml
6. Copiar las siguientes lineas dentro del archivo mysql-ds.xml

<?xml version="1.0" encoding="UTF-8"?>   <!-- $Id: mysql-ds.xml,v 1.3.2.3 2006/02/07 14:23:00 acoliver Exp $ -->   <!-- Datasource config for MySQL using 3.0.9 available from:   http://www.mysql.com/downloads/api-jdbc-stable.html   -->   <datasources>   <local-tx-datasource>   <jndi-name>DefaultDS</jndi-name>   <connection-url>jdbc:mysql://localhost/jboss</connection-url>   <driver-class>com.mysql.jdbc.Driver</driver-class>   <user-name>jboss</user-name>   <password>tucontrasegnia</password>   <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>   <!-- should only be used on drivers after 3.22.1 with "ping" support -->   <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>   <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>   <min-pool-size>5</min-pool-size>   <max-pool-size>20</max-pool-size>   <idle-timeout-minutes>0</idle-timeout-minutes>   <!-- sql to call when connection is created   <new-connection-sql>select 1 as uno</new-connection-sql>   -->   <!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers   <check-valid-connection-sql>select 1 as uno</check-valid-connection-sql>   -->   <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->   <metadata>   <type-mapping>mySQL</type-mapping>   </metadata>   </local-tx-datasource>   </datasources>

&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;!-- $Id: mysql-ds.xml,v 1.3.2.3 2006/02/07 14:23:00 acoliver Exp $ --&gt; &lt;!-- Datasource config for MySQL using 3.0.9 available from: http://www.mysql.com/downloads/api-jdbc-stable.html --&gt; &lt;datasources&gt; &lt;local-tx-datasource&gt; &lt;jndi-name&gt;DefaultDS&lt;/jndi-name&gt; &lt;connection-url&gt;jdbc:mysql://localhost/jboss&lt;/connection-url&gt; &lt;driver-class&gt;com.mysql.jdbc.Driver&lt;/driver-class&gt; &lt;user-name&gt;jboss&lt;/user-name&gt; &lt;password&gt;tucontrasegnia&lt;/password&gt; &lt;exception-sorter-class-name&gt;org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter&lt;/exception-sorter-class-name&gt; &lt;!-- should only be used on drivers after 3.22.1 with "ping" support --&gt; &lt;valid-connection-checker-class-name&gt;org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker&lt;/valid-connection-checker-class-name&gt; &lt;transaction-isolation&gt;TRANSACTION_READ_COMMITTED&lt;/transaction-isolation&gt; &lt;min-pool-size&gt;5&lt;/min-pool-size&gt; &lt;max-pool-size&gt;20&lt;/max-pool-size&gt; &lt;idle-timeout-minutes&gt;0&lt;/idle-timeout-minutes&gt; &lt;!-- sql to call when connection is created &lt;new-connection-sql&gt;select 1 as uno&lt;/new-connection-sql&gt; --&gt; &lt;!-- sql to call on an existing pooled connection when it is obtained from pool - MySQLValidConnectionChecker is preferred for newer drivers &lt;check-valid-connection-sql&gt;select 1 as uno&lt;/check-valid-connection-sql&gt; --&gt; &lt;!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --&gt; &lt;metadata&gt; &lt;type-mapping&gt;mySQL&lt;/type-mapping&gt; &lt;/metadata&gt; &lt;/local-tx-datasource&gt; &lt;/datasources&gt;

7. Dentro de la linea de comandos de MySQL ejecutar estas dos lineas de comando:
   • CREATE DATABASE jboss;
   • GRANT ALL PRIVILEGES ON jboss.* TO jboss@localhost IDENTIFIED BY ‘tucontrasegnia’;
8. Correr jboss y listo.

Twiter @QBit_Mike