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/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.28.jar. It should be installed under /opt/shrine/tomcat/lib.
...
Overview
Content Tools