Saturday, February 5, 2011

Datasource Creation using ant script


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”

No comments:

Post a Comment

B2B Features with OIC

During last couple of months various new features are getting introduced in Oracle Integration Cloud, out of those there is a new feature f...