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, ...