Question

5
Replies
192
Views
BhushanD2728 Member since 2017 4 posts
Citicorp USA Inc
Posted: October 20, 2017
Last activity: November 22, 2017
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.

<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>
DevOps
Moderation Team has archived post
Share this page LinkedIn