9.7.2 Configuring Oracle for manually installed JBoss

Copy the ojdbc6.jar for JDK 1.7 driver file from the [aem-forms root]/lib/db/oracle directory to the [appserver root]/modules/system/layers/base/com/oracle/main directory. You can also download the Oracle 11g driver from the JDBC Driver Downloads site, see Supported Platform Combinations for supported versions of Oracle 11g driver.

1. Copy the database profiles from [DVD root]\third_party\jboss.zip\ [JBoss_root]\standalone\configuration to the [AppServer_root]\standalone\configuration directory.

2. Open the [appserver root]/standalone/configuration/lc_turnkey.xml file in a text editor and locate this line:

   <connection-url>jdbc:oracle:thin:@localhost:1521:adobe</connection-url> 
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> 

3. Replace the following values with values that are specific to your database:

   • localhost : The name, IP address, or fully-qualified path of the computer that hosts the database. The default is localhost .

   • 1521 : The port used to access the database. The default port is 1521 .

   • adobe : Change the default value, adobe , with your database SID.

4. (Only for Oracle RAC) Replace the connection URL mentioned in step 2 with the following connection URL:

   jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=broken) (ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP) (HOST=yourhost1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP) (HOST=yourhost2) (PORT=1521)) (LOAD_BALANCE=on) (FAILOVER=on)) (CONNECT_DATA=(SERVER=dedicated) (SERVICE_NAME=service.yourcompany.com) (FAILOVER_MODE=(TYPE=session) (METHOD=basic) (RETRIES=10) (DELAY=3))))

   Note: Ensure that this entry appears as a single line in the adobe-ds.xml file.

5. (Only for Oracle RAC) Replace the following text from the connection URL in step 5 with values that are specific to your database:

   • yourhost1: The name, IP address, or fully-qualified domain name of the first node in the cluster that hosts the database.

   • yourhost2: The name, IP address, or fully-qualified domain name of the second node in the cluster that hosts the database.

     Note: The cluster hosting the database could have n nodes. yourhost1 and yourhost2 are examples in the case of a two-node cluster.

   • service.yourcompany.com: The service name for the Oracle RAC database.

6. Modify the minimum and maximum values for the data source connections:

   • IDP_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

   • EDC_DS:

     <min-pool-size>1</min-pool-size> 
     <max-pool-size>30</max-pool-size>

     Note: If your forms 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.

7. Save and close the file.

If you are running LiveCycle with Oracle database, you must create three datasources IDP_DS , EDC_DS , and DefaultDS .

1. Copy the database profiles from [DVD root]\third_party\jboss.zip\ [JBoss_root]\standalone\configuration to the [AppServer_root]\standalone\configuration directory.

2. Open the [JBoss_root]/domain/configuration/domain_oracle.xml file for editing.

3. Locate the <datasources> tag and delete all the child nodes.

4. 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>

5. 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>

6. 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>

7. Set the following database specfic values for datasources IDP_DS, EDC_DS, and DefaultDS:

   1. Localhost : The name, IP address, or fully-qualified path of the computer that hosts the database. The default is localhost

   2. 1521 : If Oracle does not uses the default port, provide the appropriate port number.

   3. ORACLE_SID : Replace the ORACLE_SID with your Oracle System Identifier.�

   4. DB_USER , DB_PASSWORD : Provide the credentials that the application server uses to access your database.

   5. Modify the minimum and maximum values for the data source connections:

      • IDP_DS:

        <min-pool-size>1</min-pool-size> 
        <max-pool-size>30</max-pool-size>

      • EDC_DS:

        <min-pool-size>1</min-pool-size> 
        <max-pool-size>30</max-pool-size>

      Note: If your forms 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.

   6. 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>

8. Save and close the file.

1. 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>

2. Replace the bold values with values that are specific to your database.

3. Save and close the file.

4. Start JBoss.