Database Administration Guide

Introduction to Database Administration for WebLogic Portal

Using PointBase

PointBase Documentation

PointBase JAR Files

PointBase Tools

WebLogic Portal PointBase Databases

Administering the WebLogic Portal PointBase Database

To Launch PointBase Console from the Windows Start menu

To Launch PointBase Console from the startPointBaseConsole script

Using a Database Other Than PointBase with WebLogic Portal

Using a Microsoft SQL Server Database

Understanding Database Configuration for WebLogic Platform

Manually Configuring Databases

Configuring a Microsoft SQL Server Database

Creating Database Objects

Configuring Your Domain's JDBC Driver Settings

Creating a Database for Behavior Tracking Events

Using an Oracle Database

Understanding Database Configuration for WebLogic Platform

Manually Configuring Databases

Configuring an Oracle Database

Creating Database Objects

Configure Your Domain's JDBC Driver Settings

Creating a Database for Behavior Tracking Events

Using a Sybase Database

Understanding Database Configuration for WebLogic Platform

Manually Configuring Databases

Configuring a Sybase Database

Creating Database Objects

Configuring Your Domain's JDBC Driver Settings

Creating a Database for Behavior Tracking Events

Using a DB2 Database

Understanding Database Configuration for WebLogic Platform

Manually Configuring Databases

Configuring a DB2 Database

Creating Database Objects

Configuring Your Domain's JDBC Driver Settings

Creating a Database for Behavior Tracking Events

The Data Dictionary

Information Provided

Portal Database Components Covered

Behavior Tracking Database Objects

The BT_EVENT_TYPE Database Table

The BT_EVENT Database Table

The BT_EVENT_ACTION Database Table

Commerce Services Database Objects

Product Catalog Database Tables

The CATALOG_ENTITY Database Table

The CATALOG_PROPERTY_KEY Database Table

The CATALOG_PROPERTY_VALUE Database Table

The WLCS_CATEGORY Database Table

The WLCS_PRODUCT Database Table

The WLCS_PRODUCT_CATEGORY Database Table

The WLCS_PRODUCT_KEYWORD Database Table

Order and Discount Database Objects

The Order Processing Data Dictionary Tables

The DISCOUNT Database Table

The DISCOUNT_ASSOCIATION Database Table

The ORDER_ADJUSTMENT Database Table

The ORDER_LINE_ADJUSTMENT Database Table

The WLCS_CREDIT_CARD Database Table

The WLCS_CUSTOMER Database Table

The WLCS_ORDER Database Table

The WLCS_ORDER_LINE Database Table

The WLCS_SAVED_ITEM_LIST Database Table

The WLCS_SECURITY Database Table

The WLCS_SHIPPING_ADDRESS Database Table

The WLCS_SHIPPING_METHOD Database Table

The WLCS_TRANSACTION Database Table

The WLCS_TRANSACTION_ENTRY Database Table

Personalization Database Objects

The Portal Personalization Database Tables

The GROUP_HIERARCHY Database Table

The GROUP_SECURITY Database Table

The USER_GROUP_CACHE Database Table

The USER_GROUP_HIERARCHY Database Table

The USER_PROFILE Database Table

The USER_SECURITY Database Table

The ENTITY Database Table

The PROPERTY_KEY Database Table

The PROPERTY_VALUE Database Table

The SEQUENCER Database Table

The WEBLOGIC_IS_ALIVE Database Table

Data Synchronization Database Objects

The DATA_SYNC_APPLICATION Database Table

The DATA_SYNC_ITEM Database Table

The DATA_SYNC_SCHEMA_URI Database Table

The DATA_SYNC_VERSION Database Table

WebLogic Portal Services Database Objects

The Portal Services Database Tables

The AD_BUCKET Database Table

The AD_COUNT Database Table

The PLACEHOLDER_PREVIEW Database Table

The MAIL_ADDRESS Database Table

The MAIL_BATCH Database Table

The MAIL_BATCH_ENTRY Database Table

The MAIL_HEADER Database Table

The MAIL_MESSAGE Database Table

The SCENARIO_END_STATE Database Table

Portal Framework Database Objects

The Portal Framework Database Tables

The PF_BOOK_DEFINITION Database Table

The PF_BOOK_GROUP Database Table

The PF_BOOK_INSTANCE Database Table

The PF_DESKTOP_DEFINITION Database Table

The PF_DESKTOP_INSTANCE Database Table

The PF_LAYOUT_DEFINITION Database Table

The PF_LOOK_AND_FEEL_DEFINITION Database Table

The PF_MARKUP_DEFINITION Database Table

The PF_MENU_DEFINITION Database Table

The PF_PAGE_DEFINITION Database Table

The PF_PAGE_INSTANCE Database Table

The PF_PLACEHOLDER_DEFINITION Database Table

The PF_PLACEMENT Database Table

The PF_PORTAL Database Table

The PF_PORTLET_CATEGORY Database Table

The PF_PORTLET_CATEGORY_DEFINITION Database Table

The PF_PORTLET_DEFINITION Database Table

The PF_PORTLET_INSTANCE Database Table

The PF_PORTLET_PREFERENCE Database Table

The PF_PORTLET_PREFERENCE_VALUE Database Table

The PF_SHELL_DEFINITION Database Table

The PF_THEME_DEFINITION Database Table

Content Management Database Objects

The Content ManagementData Dictionary Tables

The CM_NODE Database Table

The CM_OBJECT_CLASS Database Table

The CM_PROPERTY Database Table

The CM_PROPERTY_CHOICE Database Table

The CM_PROPERTY_DEFINITION Database Table

Localization Database Objects

The Localization Dictionary Tables

The L10N_INTERSECTION Database Table

The L10N_LOCALE Database Table

The L10N_RESOURCE Database Table

Tracked Anonymous User Database Objects

The Tracked Anonymous User Dictionary Tables

The P13N_ANONYMOUS_PROPERTY Database Table

The P13N_ANONYMOUS_USER Database Table

XA Support

About XA

What Makes a Transaction Distributed?

XA-Compliant Code

Using XA versus Non-XA Mode: Programming Applications

Deciding When to Use TxDataSource Instead of DataSource

Using XA

Combining XA and Non-XA Drivers in the Same Application

Mixing XA and Non-XA Transactions

Using TxDataSource on a Non-XA Connection Pool

Configuring XA

Supporting WebLogic Content Management

Examples of XA Configuration

XA for Oracle in Portal Domain

XA for SQL Server in a Portal Domain

XA for Sybase in a Portal Domain

WebLogic Portal DDL Modules