Content

An application EAR, SimpleServletEar.ear, is provided to obtain a connection from the connection pool and test the connectivity to the database. Sometimes it is desired to test connectivity from an application because the "Test Connection" function in the Admin Console is done using the deployment manager or a nodeagent, rather than an application server, and a JNDI lookup of the data source is not done with "Test Connection". This application is not meant to be used in a Production environment.

SimpleServletEar.ear

Install the application to your application server in the administrative console. Select "Detailed" path. In the step "Map resource references to resources", select the JNDI name of the data source which will be tested under "Target Resource JNDI Name".

After you have successfully installed the application, start it. Use the following URL in a web browser to invoke the servlet which will then connect to the database:

http://<host name>:<port>/SimpleServlet

One of the following two messages will be returned to the browser:

1. "We are in simple servlet - successfully connected to the database" - this message indicates that the connection has been successful.

2. "We are in simple servlet - failed to connect to the database. Error: " - this message indicates that the connection failed. The detailed error message and stack trace is returned to the browser.