User Guide

Adobe LiveCycle Manually Configuring JBoss
Installing and Configuring LiveCycle for JBoss Configuring the SQL Server data source 62
➤ To obtain and copy the JDBC driver for SQL Server:
1. Obtain and install SQL Server 2000 Driver for JDBC SP3 from the Microsoft website at
www.microsoft.com/sql/downloads
.
2. Copy the msbase.jar, mssqlserver.jar, and msutil.jar files from the C:\Program Files\Microsoft SQL Server
2000 Driver for JDBC\lib directory to the [appserver root]/server/all/lib directory.
➤ To create the SQL Server data source file:
1. Open a text editor and create a new text file using the following code:
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>IDP_DS</jndi-name>
<connection-url>jdbc:microsoft:sqlserver://host_name:port;
DatabaseName=database_name;SelectMethod=Cursor</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver
</driver-class>
<user-name>database_username</user-name>
<password>password</password>
<SelectMethod>Cursor</SelectMethod>
<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>
<check-valid-connection-sql>SELECT 1</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
2. Replace the bold text with values that are specific to your LiveCycle database:
● host_name: The name, IP address, or fully-qualified path of the computer that hosts the LiveCycle
database.
● port: The port used to access the LiveCycle database. The default port is 1433.
● database_name: The name of the database you created to use as the LiveCycle database.
● database_username and password: The user name and password that the application server
uses to access the LiveCycle database.
3. Save the file as adobe-ds.xml in the [appserver root]/server/all/deploy directory.
4. Restart JBoss.
Next step
If you are installing and configuring LiveCycle Workflow and you plan to install and configure BAM Server
as well, you must now manually configure JBoss for use with BAM Server. (See “Configuring JBoss for
BAM Server” on page 77.)
If you are not installing LiveCycle Workflow, you must now deploy the products to the application server
database. (See “Deploying to JBoss” on page 64.
)