Simple updating for a web page
Ordinarily, you would need to locate your database driver's installation directory and copy the file from the driver's root directory into the library folder of the server you are using.
Fortunately, the IDE's server management is able to detect at deployment whether the JAR file has been added - and if not, it does so automatically.
You could configure the data source directly within the Glass Fish server Admin Console, or, as described below, you can declare the resources that your application needs in a file.
When the application is deployed, the server reads in the resource declarations, and creates the necessary resources.
Also, your database needs to be password-protected to create a data source and work with the Glass Fish server in this tutorial.
If you are using the default My SQL The Glass Fish Server Open Source Edition contains Database Connection Pooling (DBCP) libraries that provide connection pooling functionality in a way that is transparent to you as a developer.
The table data used in that tutorial is contained in and is also required for this tutorial.
Essentially, it is the My SQL Connector/J JDBC Driver that enables communication between the Java code understood by the application server (the Glass Fish server), and any content in SQL, the language understood by the database server (My SQL).
In order to implement the scenario described above, you develop a simple application for a fictitious organization named IFPWAFCAD, The International Former Professional Wrestlers' Association for Counseling and Development. The welcome page implements an HTML form that is used to capture user data.
Both pages implement an HTML table to display data in a structured fashion.
The following steps demonstrate how to declare a connection pool, and a data source that relies on the connection pool.
The Net Beans JDBC Resource wizard allows you to perform both actions.