Adobe LiveCycle
Manually Configuring JBoss
Installing and Configuring LiveCycle Security Products for JBoss
Connecting JBoss to the database 52
Connecting JBoss to the database
This section applies to LiveCycle Policy Server on
ly.
You must configure the data source to connect the instance of JBoss that hosts LiveCycle Policy Server to
the LiveCycle database. For JBoss, you can use a MySQL, SQL Server, Oracle, or DB2 data source.
Configuring a MySQL data source
To enable LiveCycle Policy Server to communicate with a MySQL database that stores LiveCycle data, you
must create a data source file and deploy it to the instance of JBoss that hosts LiveCycle Policy Server.
You need to create the data source file only if you want to manually deploy LiveCycle products. When you
perform a turnkey installation, the application server and product are automatically configured to interact
with the MySQL database, which is also automatically installed.
➤
To create the data source file:
1. Create an XML file using the following code:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>EDC_DS</jndi-name>
<connection-url>jdbc:mysql:
//localhost:3306/adobe
</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>
adobe
</user-name>
<password>
adobe
</password>
<min-pool-size>1</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>10</idle-timeout-minutes>
<prepared-statement-cache-size>50</prepared-statement-cache-size>
<transaction-isolation>TRANSACTION_READ_COMMITTED
</transaction-isolation>
</local-tx-datasource>
</datasources>
2. Replace the bold text for the following elements with values that are specific to your LiveCycle
database:
●
<connection-url>
describes the computer name (localhost, or you can use the computer name,
IP address, or fully-qualified path) and database port number, and the database name. The
application server uses the URL to connect to the database.
●
<user-name>
and
<password>
are the user name and password that the application server uses
to access the database. These values are set when you create the database. (See
“Creating a MySQL
database” on page 36
.)
3. Save the file as adobe-ds.xml in the
[appserver root]
/server/all/deploy directory.
4. Restart JBoss.
