Scribd
Upload
67 views7 pages

Oracle JDBC URL Configuration Guide

1. Create a database instance by specifying a JDBC URL, username, password and JNDI server. 2. Create an external class mapped to the external database and instances of Data-Admin-DB-Table and Rule-Connect-Sql. 3. Create an instance of Rule-Obj-Activity to perform database operations like retrieving, inserting and deleting records from the table specified in Rule-Connect-Sql.

Uploaded by

mallesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
67 views7 pages

Oracle JDBC URL Configuration Guide

1. Create a database instance by specifying a JDBC URL, username, password and JNDI server. 2. Create an external class mapped to the external database and instances of Data-Admin-DB-Table and Rule-Connect-Sql. 3. Create an instance of Rule-Obj-Activity to perform database operations like retrieving, inserting and deleting records from the table specified in Rule-Connect-Sql.

Uploaded by

mallesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

Rule-Connect-Sql

The different used in the creation of Rule-Connect-Sql are:1. Create a database instance.
2. Create a class (this class is called external class) which has to be
mapped to external database
3. Create an instance of Data-Admin-DB-Table.
4. Create an instance of Rule-Connect-Sql.
5. Create an instance of Rule-Obj-Activity

1. Creation of a database instance.

Use JDBC URL listed below to use a Universal Resource Locator to


find the Java Database Connectivity information.
Username: subbarao
Password: Welcome123
Admin Username
Admin Password

To specify an account that has specific capabilities:Generally primary users does not have the alter table or create table
capabilities. If you want the developers to have alter table and create
table capabilities then we will use admin account.

Enter the name of the JNDI server defining a connection pool.


The procedure for defining a connection pool depends on two factors:

Which application server you use (Apache Tomcat, Oracle, IBM


WebSphere, or BEA WebLogic, for examples)

Which database vendor and version is in use (Oracle, Microsoft


SQL Server, IBM DB2, IBM UDB and others)

Use configuration in preferences to refer to a


database/databases/pegarules element in the [Link] file that
defines the location, TCP/IP port, account name and password of a
relational database.
For example:Connection to a Microsoft SQL Server database can be defined in the
[Link] file as:
<env name="database/drivers"
value="[Link]" />
<env name="database/databases/PegaRULES/url" value="
jdbc:microsoft:sqlserver:// [Link]:1433;
DataBaseName=IncessEmployee;SelectMethod=cursor;" />
<env name="database/databases/PegaRULES/userName"
value="sa" />

<env name="database/databases/PegaRULES/password"
value="Welcome123" />

In this example, the database name is IncessEmployee and the user


name (account) is sa with password Welcome123. The database is
located on the server [Link] using TCP/IP port 1433.

This tab is selected to limit the no of connections to the database.


Here I have mentioned 10 so that 10 connections can be established
with the database.

3. Creation of Database table

Database Tab:Database: Database instance that corresponds to the database


containing the table or view
Catalog Name:
Schema Name: Identify the Schema Name that defines table.
Table Name: Enter the name of the table that you want to connect.

4. Creation of Rule-Connect-Sql

Use open tab to retrieve details of one record.


Use Delete tab to delete a row in the database.
Use Save to insert a record to the database.
Use Browse tab to retrieve multiple records.
Mention the flow name in the Error Handler Flow to be executed if
any connection exception occurs.

5. Create an instance of Rule-Obj-Activity to perform the database


operation.

You might also like