Page Comparison

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

...

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

    

   
   
   

2. Within the the Context tags tags, insert the DataSource Resource 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"
     maxActivemaxTotal="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.
   If you named the database something else than termweb, replace termweb in url with your database

   name 

   name.
   Replace termwebuser and termwebpwd in url with your database user and password.
   
   

4. Check Version specific upgrade notes for any actions needed for your TermWeb version.
   
   

 Congratulations, you now have TermWeb connected to your SQL Server MySQL database.