Page Comparison

...

1. Download the SQL Server JDBC driver (v1.3.1) from jTDS.
2. Add the SQL Server JDBC driver jar (jtds-1.3.1.jar) to <Tomcat><tomcat-install>/lib/ directory.

3. Configure a DataSource for TermWeb in Tomcat

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 SQL Server 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 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!

...

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