Deployment Procedure

Contents

Introduction

This deployment procedure applies to the 8.0.301.92 Hot Fix release of Composer, released 09/20/10. It describes how to ensure that connection pools are re-used instead of being destroyed with each query when using the DB Data block with an Oracle database.

Connection Pooling with an Oracle Database Deployment Procedure – Hot Fix [09/20/10]

To ensure that connection pools are re-used instead of being destroyed with each query when using the DB Data block with an Oracle database, do the following:

1. Uninstall the existing version of Composer by following the uninstallation procedure specified in the Composer 8.0 Deployment Guide.
   
   
2. Install the hotfix version of Composer (8.0.301.92) following the installation procedure specified in the Composer 8.0 Deployment Guide.
   
   

1. Run Composer and open the workspace.
   
   
2. Open the Connection Profiles dialog (double click on <project name>/db/connection.properties file).
   
   
3. Click on the connection profile to display its properties. The Connection Profiles screen should display two additional properties that have been added in the hotfix:
   
   
• Connection Pooling (check box)
  
  
• Connection Pool Name (text field)
  
  
4. Check the box for Connection Pooling.
   
   
5. Specify the Connection Pool Name as "jdbc/pooledDataSource" or something similar keeping the “jdbc/” as the prefix.
   
   
6. Save the connection profile.

1. In the configuration directory, locate the file conf/context.xml.
   
   
2. Open the context.xml file in a text editor and add the following XML snippet inside the <Context> element:
   
   
<Resource name="<JDBCPoolName>" auth="Container"
        type="com.mchange.v2.c3p0.ComboPooledDataSource"
        factory="org.apache.naming.factory.BeanFactory"
        driverClass="oracle.jdbc.driver.OracleDriver"
        user="<UserName>"
        password="<Password>"
        jdbcUrl="<JDBCURL>"
        minPoolSize="3"
        maxIdleTime="120" />


Note that minPoolSize and maxIdleTime are optional; the values listed here are sample values only.


3. Replace the placeholders in the copied snippet with the actual values corresponding to the settings specified in the Connection Profiles dialog. Make sure to type the password since copying it will result in only “*” characters being copied.
   
   
• For "<JDBCPoolName>" use the Connection Pool Name entry in the Connection Profiles dialog.
  
  
• For "<UserName>" use the Username entry.
  
  
• For "<Password>" use the Password entry.
  
  
• For "<JDBCURL>" use the Test Connection preview information (used to test the connection profile by pinging the database).
  
  

Top of Page

Additional Information

Additional information on Genesys Telecommunications Laboratories, Inc. is available on our Technical Support website. The following documentation also contains information about this software.

• Composer 8.0 Deployment Guide describes how to deploy Composer, an Integrated Development Environment (IDE) used to develop applications for Genesys Voice Platform and the Genesys Universal Routing Platform.

• Composer 8.0.3 Help (accessible inside Composer's Eclipse Help System) provides integrated help information about using Composer to develop voice and routing applications.

If you encounter any issues with this procedure, please contact Genesys Technical Support.

Top of Page