In order to successfully use the SQL JSTL tags, we need to create a connection pool
and data source in the application server we are using to deploy our application.
NetBeans comes pre-configured with a sample database, and the integrated
GlassFish application server included with NetBeans comes with a datasource to
access this sample database out of the box. In this section we will be using the sample
database and its corresponding datasource. In Chapter 5 we will explain how to
configure NetBeans and GlassFish to interact with a relational database that hasn't
Before we can interact with a relational database through the JSTL SQL tags, we
need to configure our application to have access to the data source providing access
to the appropriate relational database. We can accomplish this by adding a resource
reference in our application's web.xml deployment descriptor.
Since web.xml is optional in Java EE 6, NetBeans does not generate it by
default. To add a web.xml deployment descriptor to our project, we simply
need to right-click on the project node, select New | Other , then select Standard
Deployment Descriptor (web.xml) file type from the Web category.
After clicking Next> , we can click on OK on the following window to generate the