Question

3
Replies
128
Views
AndyC853 Member since 2017 4 posts
Quad Graphics Inc
Posted: November 1, 2017
Last activity: November 24, 2017
Closed
Solved

Using TNS names Pega 7.2 and Tomcat 8.5.16

Hi,

We're currently in the process of migrating our Pega implementation from the cloud to an on premise server. We currently have Tomcat setup to point to Oracle with the entries like the one below in our context.xml. This works fine but we'd prefer to have Tomcat pull the url info from the TNSNAMES.ORA file that is managed by our database team so we don't have to worry about manually updating the Tomcat config if addresses are added/removed to the address list. Is it possible to reference a server in Tomcat just by the address name in the TNS names file?

<Resource name="jdbc/PegaDATA"
auth="Container"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxx)(PORT = yyyy)))(CONNECT_DATA=(SERVICE_NAME=zzzzz)))"
username="user"
password="pw"
maxTotal="100"
maxIdle="30"
maxWaitMillis="10000"
/>
System Administration Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn