Apache Derby Tutorial

Apache Derby Tutorial

In this Apache Derby Tutorial, We will learn how to implement and work with Derby into Java programming language in order to operate database operations. This Apache Derby Tutorial has been designed for the absolute beginners and self-learners.

In this course, we will discuss apache derby from a very basic and fundamental concept to advanced concepts. We will also learn how to install derby, how to create a server, how to connect the database, how to work with command-line tools, how to implement with apache TomCat, etc.

So What is Apache Derby?

Apache Derby is an open-source relational database management system fully written in java and also to implement with Java programming language in order to operate a database system in SQL like format and command. Derby was designed and developed by Apache Software Foundation. You can connect or embed the derby server very easily into any of your java-based solutions.

To know more about derby check out Official website of Derby.

With the Derby network server, you can also easily connect with supported java client/server frameworks. In the modern JDK/latest version JDK derby used by default is called Java DB. Java DB and Derby are essentially the same. The Derby size is quite very small. It is about 2-3 MB. Derby can be run into two different modes. (i) Embedded mode (ii) Server/client mode.

Embedded vs. Server Mode

You can run apache derby in two different modes. First one is embedded mode. When you will run derby in embedded mode, the derby will be run in the JVM (Java Virtual Machine) of the system/application. In server/client mode, derby runs on the network server and derby will response data from the database on user request. But in embedded mode, only the software can access the database for data operation.

Apache Derby Features

Derby is a very light-weight database system. Its small footprint is about 2-3MB. There are many other features in the derby that made the database system popular.

  • Embedded with java application.
  • Can be run also on the server network
  • Platform independent
  • Takes fewer spaces

What is Next?

In the next subsequent chapters, we will learn derby from downloading to installation to connecting database, tools and everything about Derby. This guide also might be useful for database professionals and advanced users, because in the later chapters we also discussed the advanced topic of Apache Derby. For now, let’s get started!