...
Edit
<tomcat-install>/conf/context.xml
.Within the
Context
tags, insert the DataSourceResource
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"/>
- 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
, replacetermwebdb
in url with your database name - Replace
termwebuser
andtermwebpwd
in url with your database user and password.
- If SQL Server does not run on the same server as Tomcat, replace
Include Page Tomcat Data Source Configuration Properties Tomcat Data Source Configuration Properties
...