Saturday, December 8, 2007

Java DB / Apache Derby Operating Instructions (Fedora)

ij is an interactive SQL scripting tool that comes with Derby. It can be used with the Derby Embedded JDBC driver or with a client JDBC driver, such as the Derby Network Client.

Upon setup of Java EE SDK (as per my tutorial), do the following

$ export DERBY_INSTALL=/opt/SDK/javadb
$ export CLASSPATH=DERBY_INSTALL/lib/derby.jar:DERBY_INSTALL/lib/derbytools.jar
$ echo $CLASSPATH
/opt/SDK/javadb/lib/derby.jar:/opt/SDK/javadb/lib/derbytools7.jar:
$

Now,
$ java org.apache.derby.tools.ij

This will start IJ, with the IJ prompt ij>

No comments: