Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Replace "freeslick.driverNameHere$" with the name of the driver you are using ("freeslick.OracleProfile$" for Oracle, and "freeslick.MSSQLServerProfile$" for SQL Server).

Tomcat context.xml

Add a context.xml file at /opt/shrine/tomcat/conf/context.xml with contents appropriate for your database:

Code Block
languagexml
titlecontext.xml
<?xml version='1.0' encoding='utf-8'?>
<!-- The contents of this file will be loaded for each web application -->

<Context>
    <!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <Resource name="jdbc/problemDB" auth="Container" type="javax.sql.DataSource"
              maxActive="100" maxIdle="30" maxWait="10000"
              username="yourDbUserName" password="yourDbPassword" driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://yourMysqlDb:3306/shrine_query_history" 
              testOnBorrow="true" validationQuery="SELECT 1"/>
</Context>

 

Start SHRINE

The only thing left to do at this point is start SHRINE back up. Simply do the following:

...