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, ...
Get Building Java Enterprise Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.