Table of Contents

Search

  1. Preface
  2. RulePoint
  3. RulePoint Concepts
  4. Using RulePoint
  5. RulePoint Objects
  6. Working with Topics
  7. Working with Connections
  8. Working with Sources
  9. Working with Responders
  10. Working with Responses
  11. Working with Watchlists
  12. Working with Analytics
  13. DRQL
  14. Working with Rules
  15. Working with Alerts
  16. Setting Access Controls
  17. Troubleshooting RulePoint Issues
  18. Connecting to an Ultra Messaging Application
  19. Creating an Ultra Messaging JMS Source

User Guide

User Guide

SQL Connection

SQL Connection

When you create a JDBC connection, you enter the name and the configuration details for the connection through the RulePoint user interface.
The following table describes the connection and configuration properties that you need to enter:
Property
Description
Name
Name of the connection. The connection name must be unique.
Description
Optional. Description of the connection.
Type
Type of connection. Select
SQL Connection
.
Driver Class
The name of the JDBC driver class used to establish connections to the specified database. The administrator installs the JDBC driver for the target database on the RulePoint server.
For example, use the following sample driver class based on the database type:
  • DB2.
    com.informatica.jdbc.db2.DB2Driver
  • Oracle.
    com.informatica.jdbc.oracle.OracleDriver
Copy the JDBC drivers of the target database to the following directories:
  • RulePoint_6\lib
    , so that the run-time environment can use the drivers.
  • RulePoint_6\design\webapps\rulepoint\WEB-INF\lib
    , so that the design-time environment can use the drivers.
Connection URL
The JDBC connection string that you can use to connect to the target database.
For example, use the following sample connection string based on the database type:
  • DB2.
    jdbc:informatica:db2://hostname:portnumber;databaseName=dbname
  • Oracle.
    jdbc:informatica:oracle://hostname:portnumber;databaseName=dbname
User Name
User name to log in to the target database.
Password
Password to log in to the target database.
Initial Pool Size
Optional. Initial Pool Size. The default value is 1.
Minimum Pool Size
Optional. Minimum number of connections to hold in the connection pool. The default value is 1.
Maximum Pool Size
Optional. Maximum number of connections to hold in the connection pool. The default value is 5.
Acquire Increment
Optional. Number of connections to inquire at once when increasing the pool size. The default value is 1.
Login Timeout
Optional. Log in timeout, in seconds. The default value is 3.
Retry Count
Number of connection retry attempts that RulePoint should make. The default value is 3. Setting this field to zero indicates that RulePoint should not retry the connection attempt.
Retry Delay
The amount of time, in milliseconds, to wait between connection attempts. The default value is 1000.
Maximum Idle Time
The maximum idle time that a connection can remain pooled but unused before being discarded. The default value is 1200 seconds. Idle connections are tested for validity within half this interval. If the maximum idle time is 0, the connections never expire.
Acquire Retry Attempts
A limit for the number of times that RulePoint attempts to acquire a connection from the database before giving up. If the value is less than or equal to zero, RulePoint makes an indefinite number of attempts to fetch a connection. The default value is 0.
Acquire Retry Delay
A time interval, in milliseconds, for two successive connection acquisition attempts.
Checkout Timeout
The maximum time period, in milliseconds, to wait for a connection to be checked-in or acquired, if the connection pool is exhausted. Zero specifies that the wait time is indefinite. A positive value causes a time-out and an SQLException to occur after the specified time period.

0 COMMENTS

We’d like to hear from you!