Content Comparison

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

...

1. Create the TermWeb database by opening a DOS prompt and enter the following:

   mysql -u root -p < createdb.sql

   This creates an empty database called termweb and a user termwebuser with password termwebpwd. The user name and password can be changed as desired. The user currently needs all permissions (except GRANT) in the database.

2. Import the termweb.sql file to the database, by running the following at the DOS prompt:

   mysql -u termwebuser -p termwebpwdptermwebpwd termweb < termweb.sql

3. Copy the MySQL JDBC Driver to Tomcat

...

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.