Date: Thu, 28 Mar 2024 17:56:15 -0400 (EDT) Message-ID: <2033904190.822.1711662975234@prodopencatalystconfluence.catalyst> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_821_2095479882.1711662975232" ------=_Part_821_2095479882.1711662975232 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
After creating the four SHRINE databases and loading their schem= a, you will then proceed to template the connection file that Tomcat uses f= or these database connections: context.xml. This file should be placed in t= he /opt/shrine/tomcat/conf directory.
Here's an example of how a context.xml file should look like:
NOTE: If you are using a different DBMS, you will need to change the dri= verClassName, url, and validationQuery to match the DBMS you are using.
<?xml version= =3D'1.0' encoding=3D'utf-8'?> <!-- The contents of this file will be loaded for each web application -= -> <Context> <WatchedResource>WEB-INF/web.xml</WatchedResource> <Resource name=3D"jdbc/problemDB" auth=3D"Container" type=3D"javax.s= ql.DataSource" maxTotal=3D"100" maxIdle=3D"30" maxWaitMillis=3D"10000" username=3D"shrine" password=3D"demouser" driverClassName=3D"= com.mysql.jdbc.Driver" url=3D"jdbc:mysql://localhost:3306/shrine_query_history" testOnBorrow=3D"true" validationQuery=3D"SELECT 1" /> =20 <Resource name=3D"jdbc/shrineDB" auth=3D"Container" type=3D"javax.sq= l.DataSource" maxTotal=3D"100" maxIdle=3D"30" maxWaitMillis=3D"10000" username=3D"shrine" password=3D"demouser" driverClassName=3D= "com.mysql.jdbc.Driver" url=3D"jdbc:mysql://localhost:3306/shrine_query_history" testOnBorrow=3D"true" validationQuery=3D"SELECT 1" /> =20 <Resource name=3D"jdbc/adapterAuditDB" auth=3D"Container" type=3D"ja= vax.sql.DataSource" maxTotal=3D"100" maxIdle=3D"30" maxWaitMillis=3D"10000" username=3D"shrine" password=3D"demouser" driverClassName=3D"= com.mysql.jdbc.Driver" url=3D"jdbc:mysql://localhost:3306/adapterAuditDB" testOnBorrow=3D"true" validationQuery=3D"SELECT 1" /> =20 <Resource name=3D"jdbc/qepAuditDB" auth=3D"Container" type=3D"javax.= sql.DataSource" maxTotal=3D"100" maxIdle=3D"30" maxWaitMillis=3D"10000" username=3D"shrine" password=3D"demouser" driverClassName=3D"= com.mysql.jdbc.Driver" url=3D"jdbc:mysql://localhost:3306/qepAuditDB" testOnBorrow=3D"true" validationQuery=3D"SELECT 1" /> =20 <Resource name=3D"jdbc/stewardDB" auth=3D"Container" type=3D"javax.s= ql.DataSource" maxTotal=3D"100" maxIdle=3D"30" maxWaitMillis=3D"10000" username=3D"shrine" password=3D"demouser" driverClassName=3D"= com.mysql.jdbc.Driver" url=3D"jdbc:mysql://localhost:3306/stewardDB" testOnBorrow=3D"true" validationQuery=3D"SELECT 1" /> </Context>