Chapter 7. Using other Databases

Chapter 7. Using other Databases

7.1. DataSource Configuration Files
7.2. Using MySQL as the Default DataSource
7.2.1. Creating a Database and User
7.2.2. Installing the JDBC Driver and Deploying the DataSource
7.2.3. Testing the MySQL DataSource
7.3. Setting up an XADataSource with Oracle 9i
7.3.1. Padding Xid Values for Oracle Compatibility
7.3.2. Installing the JDBC Driver and Deploying the DataSource
7.3.3. Testing the Oracle DataSource

In the previous chapters, we’ve just been using the JBoss default datasource in our applications. This is provided by the embedded HSQL database instance and is bound to the JNDI name java:/DefaultDS. Having a database included with JBoss is very convenient for running examples and HSQL is adequate for many purposes. However, at some stage you will want to use another database, either to replace the default datasource or to access multiple databases from within the server.