Macromedia live cycle 7.2 매뉴얼

Installing and Configuring LiveCycle for JBoss

 Connecting JBoss to the BAM metadata database     78

You must configure a connection to the Business Activity Monitor metadata database on the instance of 
JBoss that runs BAM Server so that it can retrieve information about the process metrics that it monitors. 

The procedure to configure the connection that you use depends on the type of database that you are 
using to store Business Activity Monitor metadata:

●

To enable BAM Server to connect to the SQL Server database that stores Business Activity Monitor 
metadata, you must create a data source file and deploy the file to the instance of JBoss that runs 
BAM Server. You must also modify the default data-type mappings on JBoss. 

➤

1. Open a text editor and create a new text file using the following code:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<no-tx-datasource>
<jndi-name>com.celequest.metadata.metaDatasource</jndi-name>
<connection-url><!--Insert jdbcURL --></connection-url>
<driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<track-statements>false</track-statements>
<application-managed-security/>
</no-tx-datasource>
</datasources>

2. Replace 

<!--Insert jdbcURL -->

 inside the 

connection-url

 element with the following text:

jdbc:microsoft:sqlserver://[host name]:[port];SelectMethod=cursor;
databaseName=[dbname];user=[user_name];password=[dbpassword]

●

[host name]

 is the name of the computer where SQL Server 2000 is running.

●

[port]

 is the port used to access the database. The default port for SQL Server 2000 is 1433.

●

[dbname]

 is the name of the BAM metadata database.

●

 is the name of the database user account that can access the BAM metadata 

database.

●

[dbpassword]

 is the password for the user name specified for 

.

3. Save the file as celequest_metadata-ds.xml in the [jboss bam root]/server/default/deploy directory.