Summary

A developer asks: Can I specify multiple database definitions in the pegarules.xml file?

if I do so, do I still need to specify them in the Data-Admin-DB-Name database definition form, and still need to map classes to tables in Process Commander?

Suggested Approach

Process Commander can connect to multiple relational databases. Each requires a Data-Admin-DB-Name instance.

There are three ways of linking a Data-Admin-DB-Name instance with the database:

• Specify in the Database Name form that the details are to be obtained from the pegarules.xml file.   Choose this option when you plan to use a key ring file to encrypt the password.

• Put the JDBC URL connection details right in the Data-Admin-DB-Name form.

• Use a JDBC datasource from your Web application server. (This choice is not available for Apache Tomcat systems.)

The datasource is the preferred method.

In addition, create one or more Data-Admin-DB-Table instances to link Process Commander classes to database tables.