Sunday, July 12, 2015

Apache Derby

Apache Derby:

What is Apache Derby?
  • Relational database management being developed by Apache Software Foundation. 
  • Was initially developed by the Developers of Cloudscape.
  • Informix later acquired Cloudscape. Acquisition continued. IBM acquired Informix and still extended its support for Derby.
  • Time Progressed. IBM later withdrew its support and Apache Software Foundation continued the development of Apache Derby.

Features of Apache Derby:

Max DB Size                      Unlimited

Max Table Size                  Unlimited
Max Row Size                    Unlimited
Max Columns per row      1012
Max Column Name Size   128 bits

When Apache Derby?

  • Apache Derby being written in Java and thus usable only by Java and other scripting languages(Jython, JRuby, Jacl, etc)  that run on JVM.
  • Consumes less Footprint and can be opted when we look for DB that can set quickly.
Installation of Apache Derby:
      In Windows:
                 >> Set the environment variable DERBY_HOME to the Derby installation directory
                 >> Add DERBY_HOME/bin to the "path" environment variable

       In Mac:
               >>Open the Terminal and hit vi ~/.bash_profile 
               >>Now enter the below set of values
                     export DERBY_HOME=/Volumes/D Drive/Softwares/db-derby-
                     export PATH=$PATH:$DERBY_HOME/bin

Check the Installation    

To check if Derby has been successfully installed, run the following command where /User/hspadmin... is the location of derbyrun.jar residing within lib directory

java -jar /Users/hspadmin/Applications/db-derby- sysinfo

Once run, you should get the below output:

------------------ Java Information ------------------
Java Version:    1.7.0_75
Java Vendor:     Oracle Corporation
Java home:       /Library/Java/JavaVirtualMachines/jdk1.7.0_75.jdk/Contents/Home/jre
Java classpath:  /Users/hspadmin/Applications/db-derby-
OS name:         Mac OS X
OS architecture: x86_64
OS version:      10.9.5
Java user name:  hspadmin
Java user home:  /Users/hspadmin
Java user dir:   /Users/hspadmin Java Platform API Specification
java.specification.version: 1.7
java.runtime.version: 1.7.0_75-b13
--------- Derby Information --------
[/Users/hspadmin/Applications/db-derby-] - (1616546)
[/Users/hspadmin/Applications/db-derby-] - (1616546)
[/Users/hspadmin/Applications/db-derby-] - (1616546)
[/Users/hspadmin/Applications/db-derby-] - (1616546)
[/Users/hspadmin/Applications/db-derby-] - (1616546)

Command to Start the Derby Server


Change the Port of Derby Server

     By default Derby Server runs on the port 1527 and we can change the default port by the below command:

           startNetworkServer -p 3301

Accept of Connections from specific host:

   By default Derby accepts connections only from localhost and to make it accept the request from other hosts, run the below command with ip address/ domain name

         startNetworkServer -h

Accept of Connections from all Host:

         startNetworkServer -h

View the Contents of the Database:

Apache Derby doesnot provide any provision for Graphical view of the DB Contents. 
We normally use the Tools IJ / Squirrel SQL Client for this Purpose.

No comments:

Post a Comment