Connection Pool XUDML File Replacement
- Karl Henselin
You can either
Save XUDML file during build operation as artifact, or
Use SCM operation to export file and save it as artifacts. Artifacts are available at deployment time.
Extract it from SCM during deploy workflow or
Use SCM operation to export XUDML file prior to running deploy operation.
Use absolute path to location on server. (not recommended as it requires manual setup on server)
Connection Pool XUDML File Details
Connection pool XUDML file can use FlexDeploy variables. See Property Replacement Support. You can use any property available in FlexDeploy or configure user defined property on Workflow Properties section.
It is possible that you may be using variable for ds, user, password inside connection pool, in which case you just need variables replacement in your file.
Generating the Connection Pool XUDML FIle
Example Command
biserverxmlgen -C -NÂ -P <Password>Â -R <RPD File Name> -O <Connection Pool output file name> -8
Adding Values for Replacement in XUDML File
Sample Connection Pool XUDML File
<?xml version="1.0" encoding="UTF-8" ?>
<Repository xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<DECLARE>
<ConnectionPool name="SampleApp_Lite_Xml" parentName=""Sample App Lite Data"" parentId="3023:3" id="3029:196" user="${{OBI_SAL_USER}}" password="${{OBI_SAL_PASSWORD}}"
timeout="4294967295" maxConnDiff="10" maxConn="10" dataSource="${{OBI_SAL_DSN}}" type="NQSXML" reqQualifedTableName="false" isSharedLogin="false" isConcurrentQueriesInConnection="false"
isCloseAfterEveryRequest="true" xmlRefreshInterval="2147483647" outputType="xml" ignoreFirstLine="false" bulkInsertBufferSize="0" transactionBoundary="0" xmlaUseSession="false" multiThreaded="false" supportParams="false" isSiebelJDBSecured="false">
<Description><![CDATA[SampleAppLite connection pool to XML datasource. This connection pool points the database to the location where physical XML files are stored. The location uses the value of an RPD variable : NQ_SESSION.SERVICEINSTANCEROOT.
]]></Description>
</ConnectionPool>
</DECLARE>
</Repository>- style