Appendix A. Database Configuration
This appendix describes how to set up database pools for data sources other than the default database embedded in JBoss, Hypersonic SQL. It also shows you how to set up your EJBs to use these database pools. For illustration purposes, weâve modified Exercise 6.1 to configure and use an Oracle connection pool with JBoss.
Set Up the Database
To deploy a database connection pool, JBoss requires a datapool configuration file. The configuration file is very simple, yet can be used for almost all standard datapool setups.
Basic Setup
The first step is to download the JDBC driver classes for your
database. Copy your databaseâs
JDBC JAR file to
$JBOSS_HOME/server/default/lib
. For example, the
Oracle JDBC class files are contained in
classes12.zip
.
The JBoss distribution includes example database connection-pool
files, in the directory
$JBOSS_HOME/docs/examples/jca
. The name of each
file ends in -ds.xm
l. For this exercise,
weâve copied the oracle-ds.xml
configuration file to exAppendixA/titandb-ds.xml
and modified it accordingly.
To deploy this connection pool, you must copy
titandb-ds.xml
to the
$JBOSS_HOME/service/default/deploy
directory.
Note that the name of this config file must end with
-ds.xml
, or JBoss will not deploy it.
Tip
Database connection pools are among the many things that can be
hot-deployed in JBoss, simply by plopping the poolâs
XML configuration file into the deploy
directory.
Examine some of the configuration parameters this file ...
Get Enterprise JavaBeans, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.