Enterprise J2ME Developing Mobile Java Applications [Electronic resources] نسخه متنی

11.6 HSQL Database Engine

The Open Source HSQL Database Engine project is based on Thomas Mueller's Hypersonic SQL database project. It is completely written in Java and is one of the most widely used Open Source embedded databases. It is included in many J2EE application servers. On mobile devices, HSQL runs on the PersonalJava and CDC/FP platforms.

HSQL (v1.7) provides a JDBC driver that supports 95 percent of the JDBC interface and all JDBC 1 data types. It supports transactions, foreign keys, and even Java stored procedures. Tables in HSQL can reside in-memory or be persisted to disk files. HSQL does all of this with a memory footprint of less than 160KB. HSQL also distributes a database management console for PersonalJava devices (tested on Sharp Zaurus; see Figure 11.1).