Building Java Enterprise Applications

InstantDB

Once InstantDB has been downloaded and installed (it is available online at http://instantdb.enhydra.org), you need to add the InstantDB libraries to your Java classpath. Because InstantDB is 100% Java, this is literally all it takes to get the database ready for use. The relevant library files are contained within idb.jar and idbf.jar, both located in the classes subdirectory of the InstantDB installation. InstantDB also requires the Java JTA classes, as well as the JDBC standard extensions. These two JAR files, jta-spec1_0_1.jar and jdbc2_0-stdext.jar, can be downloaded from Sun’s web site at http://java.sun.com/products/jta and http://java.sun.com/products/jdbc, respectively. Add these two libraries to your classpath as well. Finally, the various utilities, including the one used to execute SQL scripts, are contained in another InstantDB archive, idbexmpl.jar, which is also in the classes subdirectory of the InstantDB installation. The resulting classpath is shown as follows:

/java/instantdb (bmclaugh)> echo $CLASSPATH
/java/instantdb/classes/idb.jar:/java/instantdb/classes/idbf.jar:
/java/instantdb/classes/idbf.jar:
/java/instantdb/classes/jta-spec1_0_1.jar:
/java/instantdb/classes/jdbc2_0-stdext.jar

The Java class used to execute SQL scripts is org.enhydra.instantdb.ScriptTool. This program takes an SQL script (slightly modified with some InstantDB-specific instructions, as seen in Appendix A) and a properties file, and echoes the results out to the console. First, ...