- Introduction
- PointBase Embedded/Server
- PointBase Micro
- Summary
PointBase Micro
The PointBase Micro product was designed from the ground up to run on J2ME MID Profile devices. This is quite a feat, considering the memory capabilities of most J2ME devices and the fact that there is no floating-point support in J2ME MIDP! PointBase supplies a subset of JDBC for MIDP (contained in the com.pointbase.me package) as well as a subset of SQL 92 for query capabilities. The com.pointbase.me package (known as the PointBase Lite API) includes the following classes:
- DriverManager
- Connection
- Statement
- PreparedStatement
- DatabaseMetaData
- ResultSet
- ResultSetMetaData
- SQLException
Date, time, and timestamp datatypes make use of the java.util.Date class, while decimal values make use of the pointbase.me.Decimal class. The following SQL statements are supported:
- SELECT
- UPDATE
- INSERT
- DELETE
- CREATE/DROP TABLE/USER/INDEX/FUNCTION
- COMMIT
- ROLLBACK
- SET DATALOG
- SET LOGSIZE
Currently, database synchronization from J2ME is not supported, although PointBase has stated that a UniSync-type release for J2ME is coming soon. Among the target devices given by PointBase:
Windows CE/Pocket PC (assuming a Java VM)
Symbian EPOC platforms
PalmOS
Motorola i85s/i50sx Java-enabled phones