Question

5
Replies
195
Views
Bhushan Doshi (BhushanD2728)
Citicorp USA Inc
Manager
Citicorp USA Inc
IN
BhushanD2728 Member since 2017 4 posts
Citicorp USA Inc
Posted: October 20, 2017
Last activity: November 22, 2017
Posted: 20 Oct 2017 11:42 EDT
Last activity: 22 Nov 2017 2:10 EST
Closed

PrpcServiceutils-commonUtilities.xml file configuration

Hi,



How do i configure commonUtilities.xml in prpcserviceutils while running it from command line for split schema. both schema user name and password is different hence not able understand how to configure this.

Show More

Hi,

How do i configure commonUtilities.xml in prpcserviceutils while running it from command line for split schema. both schema user name and password is different hence not able understand how to configure this.

<project name="commonUtilities" xmlns:pega="pega:/pega.com"
xmlns:ac="ac:/antcontrib.org">
<!-- Finds the system name from pr_data_admin and sets the property 'current.system.name' -->
<target name="_findSystemName">
<condition property="schema.name" value="${data.schema}.">
<and>
<isset property="data.schema"/>
<not>
<equals arg1="${data.schema}" arg2="" />
</not>
</and>
</condition>
<!-- Query for a system name with requestors -->
<property name="system.name.sql" value="select max(s.pySystemName) from ${schema.name}pr_data_admin s inner join ${schema.name}pr_data_admin r
on s.pySystemName = r.pySystemName
where s.pxobjclass = 'Data-Admin-System' and r.pxObjClass = 'Data-Admin-Requestor'" />
<echo message="${system.name.sql}" />
<pega:sql
url="${pega.jdbc.url}"
user="${pega.jdbc.username}"
password="${pega.jdbc.password}"
properties="${database.connection.properties}"
drivers="${pega.jdbc.driver.jar}"
driverclass="${pega.jdbc.driver.class}"
query="${system.name.sql}"
result="current.system.name"/>
</target>

Show Less
DevOps
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.