Skip to Content
Mobile

How to configure the ASA JDBC for connection pooling in Sybase Unwired Platform (2.x)

How to configure the ASA JDBC for connection pooling in Sybase Unwired Platform (2.x)
This technical document explains how to configure the ASA JDBC driver connection to add pooling options.

Required Software

1.            SUP 2.x.x or higher.
2.            Connection to ASA Database.

Assumption

Ø This document assumes you have a working SUP environment.
Ø You need an ASA JDBC connection to ASA Database.

Step  1 – Adding pooling options in SUP Workspace:

a.    User needs to add Pooling option to the ASA connection object.

Solution

In order to add any Pooling Options, you need to have access to Sybase Control Center and
SUP Workspace.
1.    Open SUP Workspace.
2.    Go to Enterprise Explorer.
3.    Right click on your ASA connection.
4.    Select Properties.
5.    Go to Sybase ASA Connection Properties.
6.    Select TAB Other Properties.
7.    Add the following connection pooling options.
Ø  Min pool =150
Ø  Max pool =250
Ø  Max idle Time =120
Ø  Max Wait Time=120
   Figure 1
8.    Click on Test Connection.
9.    This concludes the setup of pooling in SUP Workspace.

Step 2 – Adding Connection pooling for ASA in SCC:

a.User needs to add connection pooling for ASA in SUP SCC.

Solution

In order to do that, you need to have access to the SCC.
1.    Open SCC via the desktop IE icon.
2.    Navigate to Domains.
3.    Tree Open default.
4.    Tree Open Connections.
5.    Center menu select your ASA Connection.
6.    Place a check in you ASA connection square.
7.    Click on Properties Button.
8.    Click on <ADD NEW PROPERTY>
9.    Repeat the same process for the following options.
Ø  Min pool =150
Ø  Max pool =250
Ø  Max idle Time =120
Ø  Max Wait Time=120
      Figure 2

Step 3 – Dealing with Connection performace:

a.    Slow response when connections are made to SUP Server.

Solution

Add Connection Pooling options to the SUP Server and the SUP Workspace.

1.    Max Pool Size.is the maximum number of connections to the database at any point of time.
2.    Min Pool Size. Specifies the minimum number of connections a pool should hold.
3.    Max Wait Time. Connection to the database could not be acquired in 120 ms.
4.    Min Wait Time. The longest connection reserve wait time in seconds.
Summary
This document explaines in details about the steps needed to enable connection pooling
for the ASA driver. The setup options for connections pooling will offer greater responce
time when connecting to the SUP server. The recomendation is to have 2 connection in
the pool for every one connection to the SUP server. Example if you have 100 user
connection to SUP then you should configure 200 connection in the connection pool.