Simultaneous deployment of Java servlet and database connection pools

servlet| Data | database | database connection keywords: Servlet connection pool

Author: Jrq

Body:

Test Web Application Environment: Win2K Pro + Tomcat 5.0

Note the order in which the servlet and connection pools are deployed in the Web.xml file in the Web application.

Web.xml files, in <web-app> tags, you need to write <servlet> and <servlet-mapping&gt, and then write <resource-ref>.
Otherwise, the context of this Web application does not start properly when Tomcat starts, and this Web application is not accessed properly.

The Web.xml concise example of a servlet and connection pool deployment at the same time is as follows:
---------------
<web-app>
<servlet>
<servlet-name>query</servlet-name>
<servlet-class>BookQuery</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>query</servlet-name>
<url-pattern>/query</url-pattern>
</servlet-mapping>

<resource-ref>
<description>access DataSource example</description>
<res-ref-name>jdbc/access</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
------------------