PointBase Demos

PointBase Embedded (and Server Option) Sample Applications:

Available only on our website, the Home Supply demo
The Application Demo showcases how PointBase can be integrated in a Java application. This application uses the PointBase Embedded (Server Option), a 100% Pure Java™ multi-connection relational database management system. To run this application, you will need a Java Virtual Machine (JVM) compliant with the JDK 1.4 specification or higher and PointBase Embedded 5.1.

Database Functionality Sample
The sample provided for PointBase Embedded or the PointBase Embedded - Server Option, contains working sample code for numerous database operations, providing code that can be cut-and-pasted and easily modified for your application. It is a reference for developers who wish to write JDBC applications using the PointBase Embedded database or the PointBase Embedded - Server Option. It contains all the code snippets from the PointBase Database documentation in a runnable context. The topics covered are as follows:

  • Connecting to the PointBase Database
  • Using Basic JDBC Statements
  • Using Non-scrollable JDBC Result Sets
  • Using Dynamic JDBC Statements
  • Using Batch Operations
  • Using Scrollable Result Sets
  • Inserting BLOB & CLOB data
  • Retrieving BLOB & CLOB data
  • Demonstrating Updateable cursor functionality
  • Switching The Database Log File
  • Creating an External Stored Procedure
  • Using a Callable Statement to access an External Stored Procedure
  • Closing the connection to the Database
  • Setting Up An External Function
  • Using An External Function
  • Setting up and Using SQL Triggers
  • Using Basic SQL Statements that return a Result Set
  • Using Basic SQL Statements to demonstrate AutoIncrement
  • Using Basic SQL Statements to demonstrate UNIONs


PointBase Micro Demo & Sample Applications:

ContactManager Demo - using J2SE™
This very simple demo uses just one table in the database, but it uses dynamic SQL queries. This shows that even the most simple applications benefit from the use of dynamic queries. The frame layout was optimized to run on the Compaq iPaq, but it can also run on any computer where J2SE is installed.

HelloWorld Demo - using J2SE
This simple demo uses just one table and one row in the database. It creates a table if it does not yet exist, adds a row of data and updates the row to a new value each time the application is executed. Try executing the application several times. This application runs very quickly, so we recommend that you open a command window to run it and to view the output. This demonstration uses the Lite API described in the PointBase Micro Javadoc.

Using MicroCreateDB Application With MicroConsole
This demo describes how to create a database and how to connect to it using MicroConsole MIDP. Before you explore the functionality of MicroConsole MIDP, you must first connect to a database. PointBase provides you with a MIDLet that can create a new database, complete with data. The following instructions and screen captures guide you through this process.

Prices Demo - using J2ME™ MIDP
This demo describes how to build a Java database application (a demo called Prices in this case) using PointBase Micro.

PricesNet Demo – using J2ME Wireless Toolkit
This simple example demonstrates how to transfer SQL commands and data (DDL and DML) between a J2SE server and a J2ME client. Here the server is a PC and the client is a MIDlet in the J2ME Wireless Toolkit running on the PC. The architecture of the Remote Load and Unload Tools are described in the "Remote Load and Unload Tools" chapter.


Transformation Server for Mobile Demos and Sample Applications:

API Demo
This demo application shows a very basic use of the Transformation Server for Mobile APIs to synchronize two databases. It depicts an Inventory Management Application to synchronize inventory information between the Head Office (headquarters) and a regional office (remote client). Both the Head Office or the Regional Office can insert, update or delete their local data. The regional office can also synchronize information with the Head Office. Each synchronization operation actually sends new information to the head office and retrieves new information from the head office. The goal of this demo is to give you a basic synchronization experience. The source code shows the use of API to do a basic synchronization operation. This application does not use any of the advanced features available in Transformation Server for Mobile.

GUI Demo
This demo application shows a very basic use of the Transformation Server for Mobile APIs to synchronize two databases. It depicts an Inventory Management Application to synchronize inventory information between the Head Office (headquarters) and a regional office (remote client). The Head Office or the Regional Office can insert, update or delete their local data. The regional office can also synchronize information with the Head Office. Each synchronization operation actually sends new information to the head office and retrieves new information from the head office. The goal of this demo is to give you a basic synchronization experience.

ContactManagerSync Demo
This example provides a demonstration of Transformation Server for Mobile using the previously mentioned topology and briefly describes how the sample application code works. The ContactManager demonstration is a simple personal contact organizer that can store images together with contact details. This demonstration combines the simple Contact Manager with synchronization between databases. There are two Contact Manager client applications that store data in separate PointBase Micro databases. There is also a PointBase Embedded database that contains a master copy of the data contained within each client.

Available only on our website, the ContactManagerSync Demo with Three Tiers
This demo uses the PointBase ContactManagerSync demo to explain the architecture of a three-tier Transformation Server for Mobile system. It will "slot into" the standard PointBase installation directory.

This architecture can be used to provide supreme scalability in data movement for a distributed system. The demo consists of a superhub, two relayhubs, and two spokesets. The superhub listens on port 8123 for requests from the two relayhubs that also listen on port 8124 and 8125 for spoke requests. A design, such as this, could allow system integrators to divide the spokes into multiple groups, each handled by a relayhub.

For example, consider a specialty food canning company named CanCo. The company is headquartered on the east coast. It maintains several distribution warehouses across the country, each of which services customer locations within its region. Each customer location (spoke) has an application running on their computer or handheld. The application can query and update its local data, and synchronize it back to its assigned warehouse (relayhub). When the warehouse (relayhub) receives a synchronization request, it coordinates the data back to the central headquarter (superhub).

Available only on our website, the Sharp Zaurus/PointBase Demo
Learn how to synchronize data from your server to a database on your Sharp Zaurus with PointBase utilizing the ContactManagerSync demo.

ContactManagerSync Demo for MIDP
This demonstration extends the ContactManagerSync demonstration by providing two MIDP Contact Manager clients. This enables data to be synchronized between the J2ME MIDP environment and a server database. The clients for MIDP do not use a photograph field in the contact details.

Available only on our website, the ContactManagerSync Demo for RIM BlackBerry® JDE
The previous demo showed how to run two MIDP ContactManagerSync clients on any J2ME CLDC/MIDP device. This document provides additional instructions on running a MIDP client on an emulated BlackBerry device. You will learn how to obtain the Emulator and development environment from the BlackBerry developer website, and how to install and run the PointBase ContactManagerSync demo. When you utilize all the pieces of the ContactManagerSync demo, you are able to synchronize data between a BlackBerry device, another MIDP device, a PocketPC or Sharp Zaurus device and also an Enterprise database.

Available only on our website, the ContactManagerSync Demo for PocketPC
This demonstration extends the ContactManagerSync demonstration by providing a batch file to make a cab file to install Contact Manager client for PocketPC. This enables data to be synchronized between the PocketPC environment and a server database. In this download we have provided a sub-directory that could be plugged into <PointbaseInstall>/samples/unisync path (same level as ContactManagerSync, ContactManagerSync_MIDP, apidemo, etc). It contains a script file called makeCABFile.bat which can be used to re-build or modify the CAB file supplied. For more information please refer to the readme.html file included in the downloaded zip.

Note: -
PointBase does not provide, and cannot directly distribute, the files which comprise the Microsoft CAB file generator Wizard. The CAB file Wizard comprises the files CABWIZ.EXE, CABWIZ.DDF and MAKECAB.EXE. Once you have obtained these files, and moved them to the makeCABFile directory, the makeCABFile.bat script file can be used to process the .inf file and build a new customized CAB file. A good tutorial, and a download of the CAB file wizard files, can be found at http://www.sundialsoft.freeserve.co.uk/sddocs013.htm If this page should become unavailable, the Microsoft web site contains numerous articles on the use of the Wizard, and it can be obtained as an integral part of the Microsoft Embedded Visual Tools 3.0, which is freely downloadable from Microsoft. Always review the generated file contactManagerSync.err after building a new file, to make sure there are no build errors.
Copyright 2007 IBM Corporation.      View our Privacy Policy    Site Map    My Account    Data Integration