> Database Administration Guide > Using PointBase

Database Administration Guide

     Previous  Next    Open TOC in new window  Open Index in new window  View as PDF - New Window  Get Adobe Reader - New Window
Content starts here

Using PointBase

The sample data provided with WebLogic Portal uses the PointBase DBMS. PointBase is a demonstration database ships with WebLogic Server to allow you to use sample user accounts and data. PointBase is the default database when you create a domain with the Configuration Wizard.

Note: PointBase is supported only for the design, development, and verification of applications; it is not supported for enterprise-quality deployment. The evaluation license of PointBase has a database size limit of 30 MB.

The PointBase server is started automatically when you start WebLogic Server; it must be running for your applications to access it.

This chapter contains the following sections:

 

PointBase Documentation

PointBase documentation for the version of PointBase supported by WebLogic Server is distributed with WebLogic Server in Adobe PDF form in the WL_HOME\common\eval\pointbase\docs\embedded\pdf directory. The PointBase documentation consists of the following manuals:

 

PointBase JAR Files

Refer to the section titled "PointBase JAR Files" in the "Before You Begin" chapter of the PointBase System Guide for information on the JAR files provided with WebLogic Server in the WL_HOME\common\eval\pointbase\lib directory.

 

PointBase Tools

Scripts for starting the PointBase Server and the PointBase console are distributed with WebLogic Server in the WL_HOME\common\eval\pointbase\tools directory. Scripts are called by start scripts in the sample domains and by start scripts contained in any domain created by the Configuration Wizard. These PointBase start scripts simplify starting the PointBase Server and Console within WebLogic domains.

 

WebLogic Portal PointBase Databases

PointBase stores all data in .dbn files and all log information in .wal files. Database properties are stored in PointBase.ini files. Data files for WebLogic Portal are named weblogic_eval.dbn and log files for WebLogic Portal are named weblogic_eval$1.wal. Pre-built PointBase data, log, and PointBase.ini files for WebLogic Portal samples are included in the following directory: 

WL_HOME\samples\domains\portal

By default domains created using the Configuration Wizard with the Basic WebLogic Portal Domain template cause PointBase data and log files to be created in the following directory: 

BEA_HOME\user_projects\domains\DomainName

 

PointBase Database Size Restriction

The evaluation license of PointBase has a database size limit of 30 MB. You might find that you reach this limit if you use PointBase extensively. If this happens, you can upgrade your PointBase license by contacting sales@pointbase.com, or reduce the amount of data by deleting table rows and running the Database Compress Tool to compress the database to a more compact size. You must shut down the server before running this command line tool; no other process can access the database while the tool runs. For more information, see the PointBase Developer's Guide (WL_HOME\common\eval\pointbase\docs\embedded\pdf\pbdeveloper.pdf).

 

Administering the WebLogic Portal PointBase Database

You can administer PointBase using the PointBase administration console, or any third-party database visualization and management tool that can connect using JDBC.

You can launch the PointBase Console either from the Windows Start Menu or by executing the startPointBaseConsole.cmd/.sh script located in the domain directory.

Prior to launching the PointBase Console, ensure that WebLogic Server for the domain is running. This starts the PointBase Server.

This section contains the following sections:

Launching the PointBase Console from the Windows Start Menu

To launch the PointBase Console from the Windows Start menu:

  1. Go to Start > All Programs > BEA Products > Examples > WebLogic Portal > PointBase Console.

    2. Or, if you added Start menu options for a domain created by the Configuration Wizard, navigate to that domain's PointBase Console menu option.

  2. When the PointBase Console starts, it prompts you to enter connection parameters to properly connect to the database. Enter the following connection information; you also need this information if you use a third-party product to access the PointBase database:
    • Driver: com.pointbase.jdbc.jdbcUniversalDriver
    • URL for a portal domain you create using the Configuration Wizard: jdbc:pointbase:server://localhost:9093/weblogic_eval
    • URL for sample portal domain: jdbc:pointbase:server://localhost:9052/weblogic_eval
    • User: weblogic (or weblogic_groupspace)
    • Password: weblogic (or weblogic_groupspace)

Launching the PointBase Console from the startPointBaseConsole Script

To launch the PointBase Console using the script:

  1. Change directories to WL_HOME\samples\domains\portal\bin.
  2. For a domain created by the Configuration Wizard, navigate to that domain's home directory.
  3. Execute the appropriate start script—startPointBaseConsole.cmd or startPointBaseConsole.sh—to launch the PointBase Console.
  4. When the PointBase Console starts, it prompts you to enter connection parameters to properly connect to the database. Enter the following connection information; you also need this information if you use a third-party product to access the PointBase database:
    • Driver: com.pointbase.jdbc.jdbcUniversalDriver
    • URL for a portal domain you create using the Configuration Wizard: jdbc:pointbase:server://localhost:9093/weblogic_eval
    • URL for sample portal domain: jdbc:pointbase:server://localhost:9052/weblogic_eval
    • User: weblogic (or weblogic_groupspace)
    • Password: weblogic (or weblogic_groupspace)

  Back to Top       Previous  Next