Question

4
Replies
641
Views
MarkH960 Member since 2012 46 posts
Ameriprise Financial
Posted: January 17, 2018
Last activity: February 6, 2018
Closed
Solved

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:

<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***

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn