How to Install Derby
Derby is a relational database management system developed by Apache. It can be embbedded in Java programs and used for online transaction processing.
Personally, If I have to use RDMS in my personal projects, mostly time I prefer use Derby to other RDMS because it’s incredibly light, extremely practical and has easy installation therefore I want to tell how to install and use in your local environment.
I will tell step by step to this topic because I think that this way will be very useful and if you might be taking error, you can easily fix your problem then can jump to other step.
Step 1: Download JDK
Java Runtime Environment(JRE) is enough to run Derby but I will write some codes that contains JDBC API examples and more in this essay’s last part therefore you must have Java Development Kit (JDK) for run java application.
You can see many Oracle’s various JDK and JRE versions in here. I suggest that you should choose latest version because generally many things is easier than old versions, contains more features and contains more practical things…
Step 2: Install JDK
If you downloaded any JDK, you can easily install it just by click next button
Step 3: Set Environment Variables
Java is installed to the following path. Copy this path
Go to environment variables and click the “New” button and add to JAVA_HOME along with copied path
The other one, your copied path should be added to “Path”.
Well, let’s check everything is ok. Open the Command Line Interface and write in the following command
java --versionif everything is ok, you see like in the following.
Step 4: Download Derby
Please be careful, You must choose correct Derby’s version by have JDK because some Derby versions doesn’t work with some JDK versions.
Step 5: Set Environment Variables for Derby.
In fact, the same steps with JDK. Add DERBY_HOME to System Variables then your add DERBY_HOME along with “bin” folder to inside path
The other one, you should add %DERBY_HOME%\bin to Path inside System Variables like in the following
Step 6: Is Everything Correct
Enter the ij to Command Line Interface. 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.
And let’s create an DB that name is zoo.
connect ‘jdbc:derby:zoo;create=true’;
Let’s Do Some Practices
I want to create a DB that name is coffee and this coffee DB contains one table which name is types and types table contains three any records.
We can use following commands for running our CoffeeInitializer.java class
javac -cp <YOUR_DERBY_HOME_PATH>\lib\derby.jar;. CoffeeInitializer.javajava -cp <YOUR_DERBY_HOME_PATH>\lib\derby.jar;. CoffeeInitializer
We created our db that name is coffee and related table that name is types. Additionally, We added some records with INSERT commands. Now let’s see our created records with following codes.
You can use following commands for run CoffeeFetcher.java class
javac -cp <YOUR_DERBY_HOME_PATH>\lib\derby.jar;. CoffeeFetcher.javajava -cp <YOUR_DERBY_HOME_PATH>\lib\derby.jar;. CoffeeFetcher
I hope everything is clear for you. If you don’t understand any part, please feel free to ask. Additionally, I’ve used various resources for prepare this essay. I indicated in following. You can check out.
