derby-installing

Derby Installation
Derby Installation

on Unix/Ubuntu
1. Installing Derby on Ubuntu
https://db.apache.org//derby//derby_downloads.html

2. Extract derby to a directory
/home/mmk-prac/mm/softwares/db-derby-10.14.2.0

3. Installation Types
a. Embedded mode - only one session per DB, no seperate process required.
b. Network Mode - allows multiple sessions to the DB.


gedit .bashrc and add below entries
export DERBY_INSTALL=/home/mmk-prac/mm/softwares/db-derby-10.14.2.0
export DERBY_HOME=/home/mmk-prac/mm/softwares/db-derby-10.14.2.0
export CLASSPATH=$DERBY_INSTALL/lib/derby.jar:$DERBY_INSTALL/lib/derbytools.jar:$DERBY_INSTALL/lib/derbyoptionaltools.jar:$DERBY_INSTALL/lib/derbyshared.jar:$DERBY_INSTALL/lib/derbyrun.jar

To Verify Derby installations

terminal
$ java org.apache.derby.tools.sysinfo
we will get below information

------------------ Java Information ------------------
Java Version:    1.8.0_352
Java Vendor:     Private Build
Java home:       /usr/lib/jvm/java-8-openjdk-amd64/jre

------------------------------------------------------

$ java org.apache.derby.tools.ij

ij> connect 'jdbc:derby:empdb;create=true';
ij> connect 'jdbc:derby:empdb';

ij> create table emp (
empid int,
first_name varchar(255),
second_name varchar(255),
address varchar(500),
primary key (empid)
);
0 rows inserted/updated/deleted

ij>insert into emp(empid,first_name,second_name,address) values(1,'ABC','XYZ','SDFF RE');
1 row inserted/updated/deleted
ij>insert into emp(empid,first_name,second_name,address) values(2,'PQR','LMN','DFGRG DF'),(3,'FGH','JKL','DGFDSR THFR');
2 rows inserted/updated/deleted

ij> select * from emp;
EMPID      |FIRST_NAME |SECOND_NAME |ADDRESS
---------------------------------------------
1          |ABC        |XYZ         |SDFF RE
2          |PQR        |LMN         |DFGRG DF
3          |FGH        |JKL         |DGFDSR THFR

3 rows selected


another terminal
$ java org.apache.derby.tools.ij

ij> connect 'jdbc:derby:empdb';
Address Bind Exception will come
as empdb already opened in another session.




.bashrc
export CLASSPATH=$DERBY_INSTALL/lib/derby.jar:$DERBY_INSTALL/lib/derbytools.jar:$DERBY_INSTALL/lib/derbyoptionaltools.jar:$DERBY_INSTALL/lib/derbyrun.jar:.
export PATH=$PATH:$DERBY_INSTALL/bin

Terminal 1
$ startNetworkServer or java -jar derbyrun.jar server start
Sun Jan 15 12:52:57 IST 2023 : Security manager installed using the Basic server security policy.
Sun Jan 15 12:52:58 IST 2023 : Apache Derby Network Server - 10.14.2.0 - (1828579) started and ready to accept connections on port 1527

Terminal 2
$ setNetworkClientCP
$ ij
ij version 10.14
ij> connect 'jdbc:derby://localhost:1527/empdb';
ij> select * from emp;
EMPID|FIRST_NAME |SECOND_NAME |ADDRESS
---------------------------------------------
1    |ABC        |XYZ         |SDFF RE
2    |PQR        |LMN         |DFGRG DF
3    |FGH        |JKL         |DGFDSR THFR

3 rows selected

Terminal 3
$ setNetworkClientCP
$ ij
ij version 10.14
ij> connect 'jdbc:derby://localhost:1527/empdb';
ij> select * from emp;
EMPID|FIRST_NAME |SECOND_NAME |ADDRESS
---------------------------------------------
1    |ABC        |XYZ         |SDFF RE
2    |PQR        |LMN         |DFGRG DF
3    |FGH        |JKL         |DGFDSR THFR

3 rows selected
To Stop Network Server 

$ setNetworkServerCP
$ stopNetworkServer

Comments

Post a Comment

Popular posts from this blog

hadoop-installation-ubuntu

Hadoop Setup Hadoop Setup Hadoop installation & configuration on Ubuntu Prerequisites: 1. Java open-jdk 8 2. SSH Server - open ssh server & client 3. Hadoop dist - 2.9.1 1. Installing JDK8 on Ubuntu $ sudo apt-get update $ sudo apt-get install openjdk-8-jdk $ whereis java or whereis jvm //To get the path of Java General installation directory - /usr/lib/jvm/java-8-openjdk-amd64 Adding Java JDK8 path to environment variables $ sudo gedit /etc/profile or $ gedit .bashrc export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64 export PATH=$PATH:$HOME/bin:$JAVA_HOME/bin Verify the Java installation $ java -version $ javac -version 2. Extract hadoop-2.9.1.tar.gz Search and Download Apache Hadoop 2.9.1 from Apache Hadoop site And extract the file to a directory /home/mm/softwares/ 3. Configuring Hadoop directories on path $ sudo gedit /etc/profile or $ sudo gedit .bashrc export HADOOP_HOME=/h...
Read more

jenv-tool

Jenv Setup Jenv Setup Jenv tool is used to install, manage and switch between different Java versions easily. Automates the manual editing of changing paths and system properties. Homepage: Jenv Setup Jenv 1      1. Jenv project homepage 2      Homepage: https://github.com/jenv/jenv 3      4      2. Installation via scoop: easy way to install on Windows. For Other Operating systems Check here 5      cmd> scoop bucket add extras 6      cmd> scoop install extras/jenv 7      8      Prerequisite: Scoop should be installed and configured. See Config Scoop for more info. 9      10      3. Check the scoop ...
Read more

hive-installation-in-ubuntu

Hive Setup Hive Setup Download Hive Download and extract hive to a directory. Add below values to the .bashrc file export HIVE_HOME=/home/mkm/mm/softwares/hive-3.1.3 export PATH=$PATH:$HIVE_HOME/bin How to Setup Hive on Ubuntu in 3 different ways. Embedded Metastore(Derby) Pre-requisite -  Install Derby DB Local Metastore(Same Machine/JVM) Pre-requisite -  Install MySQL Server Remote Metastore(Remote Machine/JVM) Embedded Metastore(Derby) Will Update soon Local Metastore(Same Machine/JVM) 1. Check MySQL Server Instance is running or not $ ps -e | grep mysql or sudo service mysql status If not, Install MySQL Server by following page in Pre-requisite section 2. Login to the MySQL server $ mysql -u root -p Create Hive Metastore Database mysql> CREATE DATABASE metastore_db; Create new user login for Hive mysql> CREATE USER 'hiveadmin'@'localhost' IDENTIFIED BY ...
Read more