Install and Configure the JDBC driver

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:

1. Download and Install PointBase Server and Client Products

2. To add PointBase Type 4 JDBC Driver to Classpath of the Web Server

Download and Install PointBase Server and Client Products

Download the PointBase evaluation software from:

http://www.pointbase.com/

Install the PointBase Server and Client products on your system. The PointBase Client product includes the PointBase Type 4 JDBC driver.

To add PointBase Type 4 JDBC Driver to Classpath of the Web Server

1. 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.

2. 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:

   1. 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.

   2. Once you have changed the Classpath Suffix field, apply the changes and restart the web server instance.

To start the database server

1. 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:

     Execute: <pointbase_install_dir>/tools/server/startserver.sh

     Once you execute the startup script, the following text will be displayed:

     Server started, listening on port 9092, display level: 0 ...