How to run Java DB Derby » History » Revision 2
Revision 1 (Henning Blohm, 21.09.2012 23:55) → Revision 2/28 (Henning Blohm, 21.09.2012 23:59)
h2. Running a Java DB Network Server In samples we use the Java DB, i.e. the SQL database implementation that comes with the Java SE Development Kit (JDK). For general information see here: http://docs.oracle.com/javadb/10.8.2.2/getstart/index.html To run the Java DB in server mode, which is what we want to do, run <pre><code class="ruby"> mkdir derby cd derby java -jar $JAVA_HOME/db/lib/derbyrun.jar server start </code></pre> assuming you want to run it in the folder *derby*. At a second time you can omit the "mkdir" command of course. The environment variable JAVA_HOME is expected to point to your JDK installation folder. On Windows run <pre><code class="ruby"> mkdir derby cd derby java -jar %JAVA_HOME%\db\lib\derbyrun.jar server start </code></pre> In order to interactively query Java DB, we recommand to use the Data "Data Source Explorer Explorer" view in Eclipse. But any SQL client that can make use of JDBC drivers should be fine. The driver for Java DB can be found (at the time of this writing) in *$JAVA_HOME/db/lib/derbyclient.jar* (and similarly on Windows).