Page Comparison

...

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"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://localhost/termwebdb;user=termwebuser;password=termwebpwd;useLOBs=false"
maxActive="20"
maxIdle="10"
validationQuery="Select 1"/>


   1. • If you named the database something else than termwebdb, replace termwebdb in url with your database name 
      • Replace termwebuser and termwebpwd in url with your database user and password.

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

3. Start TermWeb

You should now have TermWeb and Tomcat configured to connect to your SQL Server database. The next step is to start it up!

• Start Tomcat and watch the log files for any errors

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