View Source

Deployment from Eclipse

The eclipse plugin has the compile feature options built in.

Complile
1. Right click on project > Debug As > Web Application OR
2. Hit the Red"G" Box icon top left, and compile options will appear

Create a war, by zipping up the war directory and rename it \[project name\].war

move libraries if need be, if there linked and not in the library folder

Copy the war file to the webapp folder for Tomcat deployment

Tomcat Setting for Connection Pool (JNDI) for SQL Server 2005

Copy jtds-1.2.5.jar (http://jtds.sourceforge.net/)

Edit conf/context.xml like below:

<?xml version='1.0' encoding='utf-8'?>
<Context>
    <!-- definition of DB connection resource -->
    <Resource name="jdbc/mmsql"
    	auth="Container"
    	type="javax.sql.DataSource"
    	driverClassName="net.sourceforge.jtds.jdbc.Driver"
    	url="jdbc:jtds:sqlserver://[server]/[database]"
    	username="[username]"
    	password="[password]"
    	maxActive="8"
    	maxIdle="4"
    />

    <WatchedResource>WEB-INF/web.xml</WatchedResource>
</Context>

Add the following code in <web-app> tag in webapps/\[your_webapps\]/WEB-INF/web.xml:

	<resource-ref>
		<description>DB connection description</description>
		<res-ref-name>jdbc/mmsql</res-ref-name>
		<res-type>javax.sql.DataSource</res-type>
		<res-auth>Container</res-auth>
	</resource-ref>