Using PointBase with iPlanet
iPlanet^TM Application Server Samples

Updated June 18, 2001

To learn about basic operations with PointBase and iPlanet Application Server, read the following sections:

• Starting PointBase
• Stopping PointBase
• Executing SQL Statements with PointBase
  

Starting PointBase

To start the PointBase server and bring up a monitoring GUI from which the database server can be monitored:

Windows:

Start --> Programs--> PointBase Network 3.5 --> PointBase Server

UNIX:

Execute install_dir/pointbase/network/bin/pointbaseServer start

Stopping PointBase

To shut down the PointBase server and to close the monitoring GUI:

Windows:

From the PointBase Server Console, execute Server-->Shutdown

UNIX:

Execute install_dir/pointbase/network/bin/pointbaseServer stop

Executing SQL statements with PointBase

The PointBase database installed with the application server is prepopulated with data for all sample applications. In some of the samples, you may need to remove, recreate and repopulate tables. The easiest means of performing these tasks is to use the PointBase Console GUI to execute SQL statements found in the .sql files withing the src/schema/ directory of each sample application.

To start the Console, follow these instructions:

Windows:

Start-->Programs -->PointBase Network 3.5 -->PointBase Console

UNIX:

Execute install_dir/pointbase/client/examples/batch/unix/startconsole

The Console appears as follows:

To connect to the database, goto DBA --> Connect to Database

Enter the following information for the samples database installed with the application server:

• Driver: use the default value as provided.
• URL: jdbc:pointbase://localhost/iassamples
• User and Password: use values as appropriate for the sample of interest:

Once connected to the database, you can enter SQL statements in the top portion of the window and the results can be viewed in the lower portion. SQL statements can be entered individually or as a sequence of statements from a file.

If a single statement has to be executed, then enter the SQL statement and select the menu option SQL --> Execute to execute the statetment.

If a sequence of statements is to be executed, use the menu option SQL --> Execute all.

To use a .sql file, as provided with the sample applications, select File->Open and open the .sql file of interest. If the.sql file contains an exit; statement, you should remove this statement to avoid exiting from the Console when executing statements read from the .sql file.

Review the PointBase documentation for more information on the PointBase console. The documentation is available at install_dir/pointbase/client/docs

Copyright (c) 2001 Sun Microsystems, Inc. All rights reserved.