12.6.1.1 Install the Oracle 11g database driver
12.6.1.2 Set Oracle as the data source
If you are running LiveCycle with Oracle database, you
must create three datasources
IDP_DS
,
EDC_DS
,
and
DefaultDS
.
-
Open the [JBoss_root]/domain/configuration/domain_oracle.xml
file for editing.
-
Locate the
<datasources>
tag and delete
all the child nodes.
-
To create the IDP_DS datasource, in the <datasources>
node, add the following lines:
<datasource jta="true" jndi-name="java:/IDP_DS" pool-name="IDP_DS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:ORACLE_SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>DB_NAME</user-name>
<password>DB_PASSWORD</password>
</security>
<validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</timeout>
<statement>
<prepared-statement-cache-size>20</prepared-statement-cache-size>
</statement>
</datasource>
-
To create the EDC_DS datasource, after the IDP_DS datasource
nodes, in the <datasources> node, add the following lines:
<datasource jndi-name="java:/EDC_DS" pool-name="EDC_DS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:ORACLE_SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>DB_NAME</user-name>
<password>DB_PASSWORD</password>
</security>
<validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</timeout>
<statement>
<prepared-statement-cache-size>20</prepared-statement-cache-size>
</statement>
</datasource>
-
To create the DefaultDS datasource, after the EDC_DS datasource
nodes, in the <datasources> node, add the following lines:
<datasource jndi-name="java:/DefaultDS" pool-name="DefaultDS" enabled="true" use-java-context="true">
<connection-url>jdbc:oracle:thin:@localhost:1521:ORACLE_SID</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver>oracle</driver>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<pool>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</pool>
<security>
<user-name>DB_NAME</user-name>
<password>DB_PASSWORD</password>
</security>
<validation>
<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
</validation>
<timeout>
<blocking-timeout-millis>20000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
</timeout>
<statement>
<prepared-statement-cache-size>20</prepared-statement-cache-size>
</statement>
</datasource>
-
Set the following database specfic values for datasources
IDP_DS, EDC_DS, and DefaultDS:
-
Localhost
:
The name, IP address, or fully-qualified path of the computer that
hosts the database. The default is localhost
-
1521
: If Oracle does not uses the default port, provide
the appropriate port number.
-
ORACLE_SID
: Replace the ORACLE_SID with your Oracle
System Identifier.�
-
DB_USER
,
DB_PASSWORD
: Provide the credentials
that the application server uses to access your database.
-
Modify the minimum and maximum values for the data source
connections:
Note:
If
your LiveCycle Server handles heavy load, increase the number of maximum
JDBC connections to ensure that all jobs are processed. In such
cases, increase <max-pool-size> to 50 or more for both IDP_DS
and EDC_DS.
-
Add the following lines as child of the <datasource>
tag:
<drivers>
<driver name="oracle" module="com.oracle">
<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
</driver>
</drivers>
-
Save and close the file.
12.6.1.3 Edit the lc_turnkey.xml file
-
Open the
[appserver root]
/standalone/configuration/lc_turnkey.xml
file in a text editor and add the following text within the
<authentication>
element:
<security-domain name="EncryptDBPassword">
<authentication>
<login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">
<module-option name="userName" value="adobe"/>
<module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=DefaultDS,service=LocalTxCM"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="EncryptDBPassword_IDP_DS">
<authentication>
<login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">
<module-option name="userName" value="adobe"/>
<module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=IDP_DS,service=LocalTxCM"/>
</login-module>
</authentication>
</security-domain>
<security-domain name="EncryptDBPassword_EDC_DS">
<authentication>
<login-module code="org.picketbox.datasource.security.SecureIdentityLoginModule" flag="required">
<module-option name="userName" value="adobe"/>
<module-option name="password" value="-3bfaa32dfe43f65b207a6df87216de44"/>
<module-option name="managedConnectionFactoryName" value="jboss.jca:name=EDC_DS,service=LocalTxCM"/>
</login-module>
</authentication>
</security-domain>
-
Replace the bold values with values that are specific to
your database.
-
Save and close the file.
-
Start JBoss.
|
|
|