I worked on a POC for Automated Configurations in ant, and struggled in creating multiple datasource and connection pools at a single go. For that I created an XML file containing all configuration settings as attributes and used for multiple tags.
Below is the part of my XML file and ANT targets.
Configuration XML:-
DataSourceName=”TEST_DataSource” User=”user”
Password=”pass” jndiLocation=”jdbc/TEST_DataSource”
JNDIUrl=”jdbc:oracle:thin:@<>:<>:<>”/>
ANT Target: -
description=”Manage the data sources and database connection pools”>
userid=”${admin.user}”
password=”${admin.password}”
name=”${connPool}”
factoryclass=”oracle.jdbc.pool.OracleDataSource”
applicationname=”default”
dbuser=”${conn.user}”
dbpassword=”${conn.pass}”
url=”${conn.jndi}”/>
userid=”${Configuration-Property.Oracle-Config.Admin_User}”
password=”${Configuration-Property.Oracle-Config.Admin_Pass}”
datasourcename=”${dataSrc}”
applicationname=”default”
jndilocation=”${conn.jndi.location}”
connectionpoolname=”${connPool}”/>
path=”/Configuration-Property/CreateDataSource/DatabaseConnectionPool”
