Page History
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 (again, assuming that MySQL is installed):
Code Block | ||||
---|---|---|---|---|
| ||||
<?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.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/shrine_query_history"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/shrineDB" auth="Container" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/shrine_query_history"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/adapterAuditDB" auth="Container" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/adapterAuditDB"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/qepAuditDB" auth="Container" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/qepAuditDB"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/stewardDB" auth="Container" type="javax.sql.DataSource"
maxTotal="100" maxIdle="30" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/stewardDB"
testOnBorrow="true" validationQuery="SELECT 1" />
</Context> |
NOTE: If you are using a different DBMS, you will need to change the driverClassName, url, and validationQuery to match the DBMS you are usingTemplate and explain context.xml here...
Overview
Content Tools