Macromedia live cycle 7.2 Manual

Installing and Configuring LiveCycle Security Products for JBoss

 Configuring a SQL Server data source     53

To enable LiveCycle Policy Server to communicate with a SQL Server 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.

For information about using SQL Server, see the SQL Server documentation.

➤

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:microsoft:sqlserver://localhost:1433;
DatabaseName=adobe;SelectMethod=Cursor</connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver
</driver-class>
<user-name>adobe</user-name>
<password>adobe</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 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 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 

3. Save the file as adobe-ds.xml in the [appserver root]/server/all/deploy directory.

4. Restart JBoss.