Issue configuring second data source in dual-user configuration
We are trying to install Pega7 on Tomcat Application Server. As per the guide, we updated context.xml for dual-user configuration. When we bring up Pega and try to login, it gives an error saying it could not bind/ find second datasource name in data schema. Can anyone advise. Below is the JDBC part in context.xml where we provide JDBC Resource names as PegaRULES and AdminPegaRULES (Second datasource).
1. Should we name resource as schema name or it could be as above?
2. Can we use admin user's username and password for configuring second datasource or Is it mandatory to use Data Schema credentials?
<!--
Creating JDBC resources for dual-user configuration.
-->
<Resource name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//[host]:[port]/[service-name-or-SID]"
username="username"
password="password"
maxActive="100"
maxIdle="30"
maxWait="10000"
<Resource name="jdbc/AdminPegaRULES"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//[host]:[port]/[service-name-or-SID]"
username="username"
password="password"
maxActive="10"
maxIdle="5"
maxWait="5000"
Pegasystems Inc.
US
Besides the PegaRULES and AdminPegaRULES datasources you need the defaultSchema bindings for your rules and data schemas (update the v72rules and v72data values to your schema names)
<Environment name="prconfig/database/databases/PegaRULES/defaultSchema" value="v72rules" type="java.lang.String"/>
<Environment name="prconfig/database/databases/PegaDATA/defaultSchema" value="v72data" type="java.lang.String"/>
You also need to add these 2 entries to your context.xml file exactly as they are below:
<Environment name="prconfig/database/databases/PegaRULES/dataSourceAdmin" value="java:comp/env/jdbc/AdminPegaRULES" type="java.lang.String"/>
<Environment name="prconfig/database/databases/PegaDATA/dataSourceAdmin" value="java:comp/env/jdbc/AdminPegaRULES" type="java.lang.String"/>
The database user that you have defined in the PegaRULES datasource can be the data schema user, since this user was granted all of the privileges needed on the rules schema as part of the installation/upgrade, or you can use a seperate database user who has privileges to select/insert/update/delete/execute everything in both the rules and data schemas.
For the AdminPegaRULES datasource the database user also needs the privileges outlined in the installation guide to make schema changes to the rules and data schemas.
UBS
US
Attached the context.xml here. We used single user configuration to bring up Pega which is working. Can we add a second datasource to context.xml now and bounce tomcat. Do we need to redeploy to add second datasource. Please suggest.