Substituindo o HSQLDB Por um Banco de Dados de Produção no JBoss EAP 5.1

Inicialmente devemos remover os seguintes arquivos do JBoss EAP 5.1:

hsqldb.jar – jboss-5.1.0./common/lib/hsqldb.jar
hsqldb-plugin.jar -jboss-5.1.0./common/lib/hsqldb-plugin.jar
hsqldb-ds.xml –  jboss-5.1.0./server/all/deploy/hsqldb-ds.xml
hsqldb-persistence-service.xml – jboss-5.1.0./server/all/deploy/messaging/hsqldb-persistence-service.xml

Vamos substituir o HSQLDB pelo MySQL 5, para isso devemos realizar o download do driver JDBC no seguinte endereço: http://www.mysql.com/downloads/connector/j/

Em seguida o driver JDBC deverá ser copiado para o diretório: jboss-5.1.0./server/all/lib/

Agora o arquivo default-ds.xml deve ser criado com o conteúdo abaixo e  copiado para: jboss-5.1.0./server/all/deploy

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>DefaultDS</jndi-name>
 <connection-url>jdbc:mysql://192.168.1.5:3306/authority</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>authority</user-name>
 <password>authsecret</password>
 <security-domain>DefaultDbRealm</security-domain>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

Agora em jboss-5.1.0./server/all/conf/login-config.xml, remover o application policy HsqlDbRealm e inserir:

<application-policy name="DefaultDbRealm">
 <authentication>
  <login-module code="org.jboss.resource.security.ConfiguredIdentityLoginModule" flag="required">
  <module-option name="principal">authority</module-option>
  <module-option name="userName">authority</module-option>
  <module-option name="password">authsecret</module-option>
  <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DefaultDS</module-option>
  </login-module>
 </authentication>
</application-policy>

Copiar o arquivo jboss-5.1.0./docs/examples/jms/mysql-persistence-service.xml  para jboss-5.1.0./server/all/deploy/messaging/

Se tudo estiver correto você deverá visualizar no log algo semelhante ao que está abaixo:

[org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager ‘jboss.jca:service=DataSourceBinding,name=DefaultDS’ to JNDI name ‘java:DefaultDS’
[ServerImpl] JBoss (Microcontainer) [5.1.0 (build: SVNTag=JBPAPP_5_1_0 date=201109021544)] Started in 31s:248m

Abraços!

Fonte: http://community.jboss.org/wiki/RemoveHSQLDB

« JMX com JSON utilizando HTTP

Linux File Descriptors and Too Many Open Files »