Saturday, December 29, 2012

Java DB (Derby)

Java DB (Derby)
set the environment variables:

1.
 Set the DERBY_HOME environment variable to the location where you extracted the Derby bin distribution.
For example, if you installed Derby in the /opt/Derby_10 directory on UNIX or in the c:\Derby_10 directory on Windows, use the following command to set the DERBY_HOME environment variable:
Operating System
Command
UNIXexport DERBY_HOME=/opt/Derby_10
Windowsset DERBY_HOME=c:\Derby_10

2.
 Be certain that the java.exe file, version 1.4.2 or, higher is in your command execution PATH. Open a command window and run the java -version command.
3.
 Add the DERBY_HOME/bin directory to the PATH environment variable so that you can run the Derby scripts from any directory.
Operating System
Command
UNIXexport PATH="$DERBY_HOME/bin:$PATH"
Windowsset PATH=%DERBY_HOME%\bin;%PATH%. If you use the Control Panel to update your system PATH, add %DERBY_HOME%\bin to the end of the PATH environment variable

Tip: 



CONNECT 'jdbc:derby:firstdb;create=true';

No comments:

Post a Comment