Page Comparison

These instructions will help you connect TermWeb to a MySQL database.

...

1. Edit <tomcat-install>/conf/context.xml.

2. Within the Context tags, insert the DataSource Resource tag:

   <Resource name="jdbc/TermWebDS"
     auth="Container"
     type="javax.sql.DataSource"
     username="termwebuser"
     password="termwebpwd"
     driverClassName="com.mysql.jdbc.Driver"
     url="jdbc:mysql://localhost/termweb?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf8&amp;rewriteBatchedStatements=true"
     maxTotal="20"  
     maxIdle="10"
     minIdle="2"
     testWhileIdle="true" 
     validationQuery="Select 1"/>

    
3. If MySQL does not run on the same server as Tomcat, replace localhost in url with the name of the database server
4. If you named the database something else than termweb, replace termweb in url with your database name 
Replace termwebuser and termwebpwd in url with your database user and password.

Warning
title Please note
Changes to <tomcat-install>/conf/context.xml can cause Tomcat to restart automatically




Include Page
Tomcat Data Source Configuration Properties Tomcat Data Source Configuration Properties