Page History

If you want magnolia Magnolia to use an external database, such as, oracleOracle, mysqlMySQL, postgresPostgres, etc. with a JNDI connection then you are going to want to create a module for you your JBDC Driverdriver. I suggest doing this prior to Magnolia installation.

Steps

1. Create a file path structure under the JBOSS_HOME /modules/ directory. For example, for an Oracle JDBC driver, create a directory structure as follows: JBOSS _HOME /modules/oracle/jdbc/main/.
2. Copy the JDBC driver JAR into the main/ subdirectory.

3. In the main/ subdirectory, create a module.xml file:

   Code Block
   <?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.1" name="com.oracle"> <resources> <resource-root path="ojdbc7.jar"/> </resources> <dependencies> <module name="javax.api"/> <module name="javax.transaction.api"/> </dependencies> </module>

   The directory should look like this:
   Image Added

4. Start the Server:  JBOSS_HOME /bin/standalone.sh
5. Start the Management CLI in another command window: JBOSS_HOME/bin/jboss-cli.sh --connect controller=localhost:9999
6. Run the following CLI command to add the JDBC driver module as a driver:

7. Code Block
   language bash
   /subsystem=datasources/jdbc-driver=DRIVER_NAME:add(driver-name=DRIVER_NAME,driver-module-name=MODULE_NAME,driver-xa-datasource-class-name=XA_DATASOURCE_CLASS_NAME)