7.7.3.1 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.