...
Antes de realizar el procedimiento anteriormente descrito hacer los siguiente paso:
- Copiar el driver de mysql Oracle en <o3>/classes/jdbc/
- Crear directorios /oracle/ojdbc6/main en <o3>/jboss/modules/com/ o <o3>/jboss/modules/system/layers/base
Crear un archivo de nombre module.xml en <o3>/jboss/modules/com/oracle/ojdbc6/main o en <o3>/jboss/modules/system/layers/base/com/oracle/ojdbc6/main, con el siguiente contenido:
Code Block <?xml version="1.0" encoding="UTF-8"?> <!-- ~ JBoss, Home of Professional Open Source. ~ Copyright 2010, Red Hat, Inc., and individual contributors ~ as indicated by the @author tags. See the copyright.txt file in the ~ distribution for a full listing of individual contributors. ~ ~ This is free software; you can redistribute it and/or modify it ~ under the terms of the GNU Lesser General Public License as ~ published by the Free Software Foundation; either version 2.1 of ~ the License, or (at your option) any later version. ~ ~ This software is distributed in the hope that it will be useful, ~ but WITHOUT ANY WARRANTY; without even the implied warranty of ~ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU ~ Lesser General Public License for more details. ~ ~ You should have received a copy of the GNU Lesser General Public ~ License along with this software; if not, write to the Free ~ Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA ~ 02110-1301 USA, or see the FSF site: http://www.fsf.org. --> <module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc6"> <resources> <resource-root path="ojdbc6.jar"/> </resources> <dependencies> <module name="javax.api"/> </dependencies> </module>
- Agregar el driver de oracle (.jar) en <o3>/jboss/modules/com/oracle/ojdbc6/main con el nombre igual al declarado en
<resource-root path="ojdbc6.jar"/>
Editar el archivo <o3>/jboss/standalone/configuration/o3bi.xml, buscar la sección <drivers> y agregarle:
Code Block <driver name="oracle" module="com.oracle.ojdbc6"> <xa-datasource-class> oracleclass>oracle.jdbc.OracleDriver <.xa.client.OracleXADataSource</xa-datasource-class>class </driver>
- Realizar el procedimiento de cambio de base de datos arriba enumerado.
...