Create Data Source

To create a "data source" for Infrastructure application, navigate to <Tomcat Home>/conf directory and edit the following block of text by replacing the actual values in the server.xml file.

Note:

The User-IDs for configuration/ atomic schemas have the prefix of setup info depending on the value set for PREFIX_SCHEMA_NAME in the <<APP Pack>>_SCHEMA_IN.XML file of the Schema Creator Utility.

For example: If the value set for PREFIX_SCHEMA_NAME is DEV and the schema name is mentioned as ofsaaconf, then the actual schema created in the database is DEV_ofsaaconf.

<Context path ="/<context name>" docBase="<Tomcat Installation
Directory>/webapps/<context name>" debug="0" reloadable="true"
crossContext="true"><Resource auth="Container" name="jdbc/FICMASTER" type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver" username="<user id for the
configuration schema>" password="<password for the above user id>"
url="jdbc:oracle:thin:@<DB engine IP address>:<DB Port>:<SID>"
maxActive="100" maxIdle="30" maxWait="10000"/><Resource auth="Container"
name="jdbc/< INFORMATION DOMAIN NAME >"
type="javax.sql.DataSource"
driverClassName="oracle.jdbc.driver.OracleDriver" username="<user id for the
atomic schema>" password="<password for the above user id>"
url="jdbc:oracle:thin:@<DB engine IP address>:<DB Port>:<SID>"
maxActive="100" maxIdle="30" maxWait="10000"/>
</Context>

Note:

• The <Resource> tag must be repeated for each Information Domain created.
• After the configuration, the "WAR" file must be created and deployed in Tomcat.