Adding a New Connection Pool

Create a new connection pool that defines the connection properties needed to connect to a new datasource.

1. In the left pane, click the Unwired Server you are currently logged in to.
2. Below the server name, click Connections.
3. On the Connections tab, click New.
4. Enter a unique Connection pool name.
5. Select the Connection pool type and configure which template to use for that type:
   • JDBC – choose this for most other database connections.
     In Use template, choose a connection template for datasource target. By default, the following templates are installed with Unwired Platform; however, a production version of Unwired Server may have a different template list..

     Template	Description
     Db2_template	For IBM DB2 database connections
     Informix_template	For IBM Informix Dynamic Server connections
     Oracle_template	For Oracle database connections
     SQL_Anywhere_template	For Sybase SQL Anywhere 10 or later connections
     SQL_Server_template	For Microsoft SQL Server database connections
     Sybase_ASA_template	For Sybase Adaptive Server Anywhere 9 or earlier connections
     Sybase_ASE_template	For Sybase Adaptive Server Enterprise connections

   • SAP – choose this if you are connecting to an SAP (JCO) datasource.

     In Use template, an SAP template exists exclusively for this connection type. However, your production version of Unwired Server may include more than this default.

6. Template default properties appear, along with any predefined values. You can customize the template, if required, by performing either of these actions:
   • Editing existing property values – click the corresponding cell and change the value that appears.
   • Adding new properties – click the <ADD_NEW_PROPERTY> cell in the Property column and select the required property name. You can then set values for any new properties you add.
   Note: Properties that appear in red are required. You cannot connect to the datasource without the correct value. You cannot modify property names that appear in gray.
7. Test the values you have configured by clicking Test Connection. If the test fails, either values you have configured are incorrect, or the data source target is unavailable. Evaluate both possibilities and try again.
8. Click OK to register the connection pool.

   The name appears in the available connection pools table on the Connections tab. Administrators can now use the connection pool to deploy packages.