General Properties of Connection Pool

Connection Pool is a very important repository object and we should have a good knowledge of that. Moreover, many interview questions are based out of this. Now, lets understand something more about it…

We have 3 tabs:

1)General       2)XML     3)Write Back

In the General tab,

We need to give the Name of the connection pool.

Call Interface specifies that the Siebel Analytics will be making use of this application program interface (API)  to access the Datasource. We have a list of call interfaces available based on the type of DB we are using as the data source. Like for Oracle we have OCI, ODBC etc.

 Maximum Connections tells the maximum number of users that can connect through this connection pool. The default value is 10.

Require fully qualified table names is used to have the tables names with complete details like DB.schema.table_name. When this option is selected, all requests sent from the connection pool use fully qualified names to query the underlying database.

In Data Source Name we need to give the Host String of the DB to which the queries will be routed. We need to give valid logon info for the data source else will fail to connect to the particular Data source.

If Shared Logon option is checked, then all connections to the database that use the connection pool will use the user name and password specified in the connection pool. If this option is not selected, connections through the connection pool use the database user ID and password specified in the DSN or in the Siebel user profile.

In Username & Password and password u need to specify the Username and password of the underlying DB. We can also create a variable for the Username and make changes in that when we intend to change the underlying DB.

The Enable Connection Pooling allows a single DB connection to remain open for specified time so that the future query requests could route through the same connection. It saves the overhead of opening and closing new connections and if this option is unchecked then we for each query the DB need to open a new connection.

Timeout specifies the time for which the connection to data source remains open after the request completes.  During this time the new requests make use of this connection instead of opening a new connection. If timeout value set to 0 then connection pooling is disabled.

Execute queries Asynchronously specifies that whether the data source supports asynchronous queries or not.

Execute on connect allows the Siebel Analytics Admin server to specify a command to the DB each time the connection to the DB is established. It can be any command accepted by the DB.

Parameters Supported when checked tells that that all the DB parameters mentioned in the DB features file are supported by Siebel Analytics server.

Isolation Level controls the transaction locking behavior for all statements issued by a connection.

• Committed Read- Locks are held while the data is read to avoid dirty reads. Data can be changed before the transaction ends with that connection.
• Dirty Read- 0 Locking. Can read uncommitted or dirty data, change values in data during read process in a transaction. Least restrictive of all types.
• Repeatable Read- Places locks on all data used in a query so that nobody can update the data. However new rows can be inserted by other users but will be available in later reads in the current transaction.
• Serialization- Places a range lock on data set preventing other users to insert or update the rows in data set until the transaction is complete. Most restrictive of all.