Question

3
Replies
1234
Views
Geetha Varna (GeethaV4)
UBS

UBS
US
GeethaV4 Member since 2016 12 posts
UBS
Posted: July 7, 2016
Last activity: July 26, 2017
Posted: 7 Jul 2016 17:17 EDT
Last activity: 26 Jul 2017 15:35 EDT
Closed

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"

Data Integration System Administration Installation and Deployment
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.