Page History
...
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="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/shrine_query_history?serverTimezone=UTC"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/shrineDB" auth="Container" type="javax.sql.DataSource"
maxTotal="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/shrine_query_history?serverTimezone=UTC"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/adapterAuditDB" auth="Container" type="javax.sql.DataSource"
maxTotal="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/adapterAuditDB?serverTimezone=UTC"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/qepAuditDB" auth="Container" type="javax.sql.DataSource"
maxTotal="512" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/qepAuditDB?serverTimezone=UTC"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/stewardDB" auth="Container" type="javax.sql.DataSource"
maxTotal="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/stewardDB?serverTimezone=UTC"
testOnBorrow="true" validationQuery="SELECT 1" />
</Context> |
For MariaDB you will need to use an appropriate driver. In our tests, we have had success with the MySQL Connector/J driver from https://mvnrepository.com/artifact/mysql/mysql-connector-java. The jar file we used was mysql-connector-java-8.0.17.jar. It should be installed under /opt/shrine/tomcat/lib.
MS SQL Server
For MS SQL Server, you will need to use an appropriate driver and url for your database. In our tests, we have had success with the JTS driver from https://sourceforge.net/projects/jtds/files/. The jar file we used was jtds-1.3.1.jar. It should be installed under /opt/shrine/tomcat/lib.
...
Code Block | ||||
---|---|---|---|---|
| ||||
url="jdbc:jtds:sqlserver://mssql.abcdefghijkl.us-east-1.rds.amazonaws.com:1433/adapterAuditD |
Oracle
For Oracle, you will need to use an appropriate driver and url for your database. The driver must support JDK 11 and later. We test internally with ojdbc10.jar and recommend using that version. ojdbc8.jar is also certified by Oracle to work with JDK 11.
...