Connecting to multiple databases with Data-Admin-DB-Name
A developer asks: Can I specify multiple database definitions in the
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?
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.xmlfile. 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.