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
   1. •  replace termwebdb
    in
   1. •  in url
   with
   1. •  with your database name 
   Replace
   1. • Replace termwebuser
   and
   1. •  and termwebpwd
    in
   1. •  in url
   with
   1. •  with your database user and password.

Notes

...

1. Include Page
   Tomcat Data Source Configuration Properties Tomcat Data Source Configuration Properties

   


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