Red Hat Application Server, Manual

Page: 26 / 296

18 Chapter 2. Getting Started with JOnAS
•
Section 2.2.2.1 Configuring Database Access
•
Section 2.2.2.2 Creating the Table in the Database
•
Section 2.2.2.3 Configuring the Classpath
2.2.2.1. Configuring Database Access
In order to be able to access your relational database, JOnAS will create and use a DataSource object
that must be configured according to the database that will be used.
These DataSource objects are configured via properties files.
$JONAS_ROOT/conf
contains templates
for configuring DataSource objects for databases such as Oracle and PostgreSQL:
•
$JONAS_BASE/conf/Oracle1.properties
•
$JONAS_BASE/conf/PostgreSQL1.properties
Depending on your database, you can customize one of these files with values appropriate for your
installation. After doing so, you must update the property
jonas.service.dbm.datasources
in
the
jonas.properties
file.
For example, for the
Oracle1.properties
file.
jonas.service.dbm.datasources Oracle1
Section 3.5.7 Configuring the Database Service provides more details about DataSource objects and
their configuration.
2.2.2.2. Creating the Table in the Database
The
$JONAS_ROOT/examples/src/eb
directory contains an SQL script for Oracle:
Account.sql
($JONAS_ROOT/examples/src/eb/Account.sql). If your Oracle server is running and you are using
CMP 1.1, you can create the table used by the example. If you are using CMP 2.0, do not create the
table.
2.2.2.2.1. Example: Creating the Table in Oracle
sqlplus user/passwd
SQL @Account.sql
SQL quit
2.2.2.3. Configuring the Classpath
The JDBC driver classes must be accessible from the classpath. To enable that, update the
config_env
file (http://jonas.objectweb.org/current/bin/unix/config_env).
In this file, set one of the following variables: IDB_CLASSES, ORACLE_CLASSES, or POST-
GRE_CLASSES with the appropriate value for your database installation.