External Datasource definition PRPC 7.2.1 and Tomcat
We are migrating from WAS to Tomcat.
In WAS, we define external datasources within the WAS console and we have corresponding definitions within PRPC making use of the "use jdbc Connection Pool" as the means to connect. This works great.
In Tomcat, we have left the PRPC definitions as is. I have also defined the external db in the conf/context.xml file. I have also added a "resource-ref" definition to the web.xml file for prweb. However, I get the following message when clicking "Test Connection" in the PRPC database definition:
| Status Value: Unable to obtain DataSource object: code: <none> SQLState: Name [jdbc/EstateSettlement] is not bound in this Context. Unable to find [jdbc]. Message: <none> DatabaseException caused by prior exception: javax.naming.NameNotFoundException: Name [jdbc/EstateSettlement] is not bound in this Context. Unable to find [jdbc]. |
Thoughts on what I am doing wrong? Below are the entries in context.xml and web.xml:
context.xml:
We are migrating from WAS to Tomcat.
In WAS, we define external datasources within the WAS console and we have corresponding definitions within PRPC making use of the "use jdbc Connection Pool" as the means to connect. This works great.
In Tomcat, we have left the PRPC definitions as is. I have also defined the external db in the conf/context.xml file. I have also added a "resource-ref" definition to the web.xml file for prweb. However, I get the following message when clicking "Test Connection" in the PRPC database definition:
| Status Value: Unable to obtain DataSource object: code: <none> SQLState: Name [jdbc/EstateSettlement] is not bound in this Context. Unable to find [jdbc]. Message: <none> DatabaseException caused by prior exception: javax.naming.NameNotFoundException: Name [jdbc/EstateSettlement] is not bound in this Context. Unable to find [jdbc]. |
Thoughts on what I am doing wrong? Below are the entries in context.xml and web.xml:
context.xml:
<Resource name="jdbc/EstateSettlement"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testserver.ampf.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=D1EWESL)))"
username="SPEGAD01"
password="xxxxxxx"
maxActive="100"
maxIdle="30"
maxWait="10000"
/>
Web.xml:
<resource-ref id="ResourceRef_11">
<description>EstateSettlement datasource</description>
<res-ref-name>jdbc/EstateSettlement</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope> <!-- Shareable is default -->
</resource-ref>
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Ameriprise Financial
US
Thanks Sriva. I did open an SR on this topic and was provided with information that the Database definition within PRPC differs between WAS and Tomcat. In WAS, we used jdbc/EstateSettlement. In Tomcat, we need to use java:comp/env/jdbc/EstateSettlement in order to get it to work.
JPMorgan Chase & Company
US
Hi,
Can you please screen shots of the database rule from designer studio, seems to be the changes not reflected properly.
Pegasystems Inc.
IN
Hi, I took help from this post, Please see if it helps you https://stackoverflow.com/questions/14655825/tomcat-6-7-jndi-with-multiple-datasources.
Accepted Solution
Ameriprise Financial
US
Thanks Sriva. I did open an SR on this topic and was provided with information that the Database definition within PRPC differs between WAS and Tomcat. In WAS, we used jdbc/EstateSettlement. In Tomcat, we need to use java:comp/env/jdbc/EstateSettlement in order to get it to work.