In this section you can define the necessary JDBC-related settings in the web server environment prior to deploying and exercising the sample.
JDBC configuration involves setting up a JDBC driver, defining a JDBC connection pool, and registering the JDBC resources used by your application.
A JDBC driver must be configured in the classpath of the web server before you can exercise applications that use JDBC. In this example, the PointBase JDBC driver is used.
To install and configure PointBase for use with the sample applications, follow these steps:
Download and Install PointBase Server and Client Products
To add PointBase Type 4 JDBC Driver to Classpath of the Web Server
Download the PointBase evaluation software from:
Install the PointBase Server and Client products on your system. The PointBase Client product includes the PointBase Type 4 JDBC driver.
Open the server-instance/config/server.xml file of the web server instance. Add the location of the PointBase driver in the classpathsuffix.
You can find the JDBC driver under < pointbase_install_dir>/lib/.
The driver is named pbclientnn .jar where nn represents the version of PointBase.
Restart the web server to make the server aware of the driver.
Alternatively, you can specify the location of the PointBase driver in the Classpath Suffix field in configuration of the Web Server:
Check Java tab of the Web Server instance -> Java Path Settings page to make this change.
If a PointBase JDBC driver is already configured in the Classpath Suffix field, replace it with the path to the newly installed driver.
Once you have changed the Classpath Suffix field, apply the changes and restart the web server instance.
The database server can be started by performing one of the following actions:
On Windows Platforms:
Execute: < pointbase_install_dir>\tools\server\startserver.bat
On UNIX Platforms:
Once you execute the startup script, the following text will be displayed:
Server started, listening on port 9092, display level: 0 ...
For information about creating and maintaining a database using PointBase, refer to the database documentation. After you have created a database, you need to use the following script to create the table ’Greeting’, which will record application entries:
Before running the sample application, you need to define a suitable JDBC connection pool that maps to the PointBase database server. You also need a JDBC resource that associates the JDBC references made in the sample application to the JDBC connection pool definition.
Through a web browser, access the administration server interface.
You might have to start the administration server if it is not running.
Select the Java tab in the server instance and click on JDBC Connection Pools
Click New, and select the JDBC driver, as shown in Figure 7-2: Selecting the JDBC Driver:
jdbc-simple-pool as the name of the new connection pool.
jdbc:pointbase:server://localhost/sample as database name
PBPUBLIC as the user name
PBPUBLIC as the password
Transaction Isolation set to read-committed
Click OK and then Apply to save and apply your changes.
Now that the JDBC connection pool definition has been created, you are ready to define a JDBC resource and associate it with the connection pool entry.
Under the Java tab of the server instance, click the JDBC Resources link.
Click the New button to define a new resource entry.
Set the fields to the following values and click on the OK button to define the resource:
Click on OK and Apply to save and apply your changes.
After you’ have set up database connectivity, you are ready to deploy the jdbc-simple sample web application that uses these newly created JDBC resources. You can find this sample application at the following location:
To deploy this sample application, follow the steps outlined in Chapter 6, Running Java Web Applications On Your Server.