Page Comparison

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

1

...

1. Run bin/shutdown.sh or bin/shutdown.bat to bring Tomcat down while you are making these changes.
2. Make a backup of your server.xml and context.xml files in <tomcat-install>/conf/ so that you can easily revert if you have a problem.

...

. Configuring MySQL

MySQL should allow packet sizes at least the size of maximum file attachment size, by default 15000 KB.

The default max packet size is 1MB, and you can configure this in your MySQL configuration file by setting the property max_allowed_packet. See the MySQL manual for more information.

2. Create 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 -ptermwebpwd termweb < termweb.sql

3. Copy the MySQL JDBC Driver to Tomcat

1. Download the MySQL Connector/J JDBC driver from http://dev.mysql.com/downloads/connector/j/
2. After unpacking the file you have downloaded, you will find a file called something like mysql-connector-java-5.1.22x-bin.jar.
3. If you are running Tomcat 6.x or Tomcat 7.x, copy

   Copy the file into <tomcat-install>/lib

   . On Tomcat 5.5, copy this file into the common/lib directory of your Tomcat installation.

3. Configure Tomcat

1. For Tomcat 6.x and Tomcat 7.x, edit . 

   Warning
   title Please note
   MySQL Connector/J v5.1.36 contains a bug which causes it not to work together with MySQL 5.0.x.

4. Configure a DataSource for TermWeb in Tomcat

• The configuration properties for Tomcat's standard data source resource factory (org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory) are as follows:
  • driverClassName – Fully qualified Java class name of the JDBC driver to be used.
  • maxActive – The maximum number of active instances that can be allocated from this pool at the same time.
  • maxIdle – The maximum number of connections that can sit idle in this pool at the same time.
  • maxWait – The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception.
  • password – Database password to be passed to our JDBC driver.
  • url – Connection URL to be passed to our JDBC driver. (For backwards compatibility, the property driverName is also recognized.)
  • user – Database username to be passed to our JDBC driver.
  • validationQuery – SQL query that can be used by the pool to validate connections before they are returned to the application. If specified, this query MUST be an SQL SELECT statement that returns at least one row.

4. Restart Tomcat

...

1. Edit <tomcat-install>/conf/context.xml.
   If you are running Tomcat 5.5 you edit <tomcat-install>/conf/server.xml.

    

   
   

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

    

   <Resource name="jdbc/TermWebDS"
     auth="Container"
     type="javax.sql.DataSource"
     username="termwebuser"
     password="

   termwebpassword

   termwebpwd"
     driverClassName="com.mysql.jdbc.Driver"
     url="jdbc:mysql://localhost

   :3306

   /termweb?autoReconnect=true&useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true"
     

   maxActive

   maxTotal="20"  
     maxIdle="10"
     minIdle="2"
     testWhileIdle="true" 
     validationQuery="Select 1"/>
   

    

4. Replace the username and password parameters with the correct values for your database.
In the url parameter, replace the word 'termweb' with

If MySQL does not run on the same server as Tomcat, replace localhost in url with the name of the database

your TermWeb data will be stored in.

Notes

...

1. server.
   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.
   
   

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

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