Question

3
Replies
158
Views
Close popover
Andy Casey (AndyC853)
Quad Graphics Inc

Quad Graphics Inc
US
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 Installation and Deployment Data Integration
Moderation Team has archived post,
Close popover 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.