Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

  1. 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
  2. Wiki MarkupCreate a war, by zipping up the war directory and rename it \ [project name\].war
    1. move libraries if need be, if there linked and not in the library folder
  3. Copy the war file to the webapp folder for Tomcat deployment

...

  • Edit conf/context.xml like below:
    Code Block
    xml
    xml
    <?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://[host_url]/[dbname]"
    	username="[username]"
    	password="[password]"
    	maxActive="8"
    	maxIdle="4"
    />
    
    <Resource name="jdbc/pgsql"
    	auth="Container"
    	type="javax.sql.DataSource"
    	driverClassName="org.postgresql.Driver"
    	url="jdbc:postgresql://[host_url]/[dbname]"
    	username="[username]"
    	password="[password]"
    	maxActive="8"
    	maxIdle="4"
    />
    
        <WatchedResource>WEB-INF/web.xml</WatchedResource>
    </Context>
    
    Wiki Markup
  • Add the following code in <web-app> tag in webapps/\[your_webapps\]/WEB-INF/web.xml:
    Code Block
    xml
    xml
    	<resource-ref>
    		<description>MM DB connection</description>
    		<res-ref-name>jdbc/mmsql</res-ref-name>
    		<res-type>javax.sql.DataSource</res-type>
    		<res-auth>Container</res-auth>
    	</resource-ref>
    
    	<resource-ref>
    		<description>Spaital MM DB connection</description>
    		<res-ref-name>jdbc/pgsql</res-ref-name>
    		<res-type>javax.sql.DataSource</res-type>
    		<res-auth>Container</res-auth>
    	</resource-ref>
    
    

...