After creating the four SHRINE databases and loading their schema, you will then proceed to template the connection file that Tomcat uses for these database connections: context.xml. This file should be placed in the /opt/shrine/tomcat/conf directory.
Here's an example of how a context.xml file should look like. Please remember to change the connection url to your Oracle database schema with the right username and password!
The following is for a system running Oracle databases, granted you have already followed the instructions in Chapter 6.1.1. |
Starting with SHRINE 1.25.4, if you are using Oracle, please change the driverClassName to "oracle.jdbc.driver.OracleDriver". |
<?xml version='1.0' encoding='utf-8'?> <!-- The contents of this file will be loaded for each web application --> <Context> <WatchedResource>WEB-INF/web.xml</WatchedResource> <Resource name="jdbc/problemDB" auth="Container" type="javax.sql.DataSource" maxTotal="100" maxIdle="30" maxWaitMillis="10000" username="shrine" password="demouser" driverClassName="com.oracle.jdbc.Driver" url="jdbc:oracle:thin:@db.com:1521:ShrineDB" testOnBorrow="true" validationQuery="SELECT 1 FROM DUAL" /> <Resource name="jdbc/shrineDB" auth="Container" type="javax.sql.DataSource" maxTotal="100" maxIdle="30" maxWaitMillis="10000" username="shrine" password="demouser" driverClassName="com.oracle.jdbc.Driver" url="jdbc:oracle:thin:@db.com:1521:ShrineDB" testOnBorrow="true" validationQuery="SELECT 1 FROM DUAL" /> <Resource name="jdbc/adapterAuditDB" auth="Container" type="javax.sql.DataSource" maxTotal="100" maxIdle="30" maxWaitMillis="10000" username="shrine" password="demouser" driverClassName="com.oracle.jdbc.Driver" url="jdbc:oracle:thin:@db.com:1521:ShrineDB" testOnBorrow="true" validationQuery="SELECT 1 FROM DUAL" /> <Resource name="jdbc/qepAuditDB" auth="Container" type="javax.sql.DataSource" maxTotal="100" maxIdle="30" maxWaitMillis="10000" username="shrine" password="demouser" driverClassName="com.oracle.jdbc.Driver" url="jdbc:oracle:thin:@db.com:1521:ShrineDB" testOnBorrow="true" validationQuery="SELECT 1 FROM DUAL" /> <Resource name="jdbc/stewardDB" auth="Container" type="javax.sql.DataSource" maxTotal="100" maxIdle="30" maxWaitMillis="10000" username="shrine" password="demouser" driverClassName="com.oracle.jdbc.Driver" url="jdbc:oracle:thin:@db.com:1521:ShrineDB" testOnBorrow="true" validationQuery="SELECT 1 FROM DUAL" /> </Context> |