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