Home > Articles > Programming > Java

  • Print
  • + Share This
Like this article? We recommend

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

  • + Share This
  • 🔖 Save To Your Account