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

   


...