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

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.