RHS Allan WSPJ Notes Installing Java DB

Installing Java DB

As the "Java DB" actually just is a special package from SUN including the open source "Derby" database we will from now on use the name "Derby" - this is also consistent with the documentation in the package.

• Get the installation file for Windows here: javadb_10_3_1_4.msi
• Click on the file to start the installation, click "Next", "Next", "Install" and "Finish"
• To set some environment variables open "Control Panel" -> "Performance and Maintenance" -> "System"

	You should see a window like this one:

• Choose the tab "Advanced" and click the button "Environment variables"
• In the "System Variables" area click "New"
• Enter "DERBY_HOME" as the name
• Enter the path for the program as the value (i.e. "C:\Program Files\Sun\JavaDB")
• Click "OK"
• In the "System Variables" area find the variable named "Path" and click "Edit"
  • TAKE CARE not to delete anything!
  • Remember that all path-values in this variable are separated by semicolon (;)
  • Make sure that the path for your java.exe file is included (normally something like: "C:\Program Files\Java\jre1.6.0_02\bin")
  • Make sure that the path for the Derby files is included ("%DERBY_HOME%\bin"
  • For convenience make sure the "current path" (simply a dot (.) as the path) is included
  • Here is an example of how the value could be (differs significantly according to the System in use): "%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;"C:\Program Files\Java\jre1.6.0_02\bin";%DERBY_HOME%\bin;.;"
    Note the dot at the end!
• Click "Ok" twice and you're done!

To see if things work properly click the "Start" button and chose "Run...", enter "CMD" in the "Open" textbox.
In the command line box enter "java <cr>" (remember that "<cr>" means the enter-key!)
You should get an error-message from the JVM

Now enter "sysinfo <cr>" - you should get a message from Derby

To create and use a database look here: Create a database