Table of Contents

Connecting to multiple databases with Data-Admin-DB-Name


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.

Suggest Edit
Did you find this content helpful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.