...
- 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.ConnectionPoolDataSourceDataSource" 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.ConnectionPoolDataSourceDataSource" 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.ConnectionPoolDataSource</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.ConnectionPoolDataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
...