JDBC Tutorial

JDBC derbyDB Tutorial

      derbyDB is an in-memory Relational Database Developed by Apache Software Foundation.With no setup,intilalization, configuraton etc., It runs in 2 different modes,
       1.Embedded
        2. Client/Server mode.
derbyDB written using java programming language. Supports only JDBC protocol.,
Embedded Server, Database Server runs in client Address Space.
Client/Servermode Database Server runs in independent address space.
derbyDB is a Relational Database, supports SQL-92 DataTypes(Numbers,Strings,Dates etc.,) as well as SQL-99 DataTypes(Binary Objects, Character Large Objects etc.,).

Installing DerbyDB

DerbyDB JDBC URL format

		for Embedded Derby Server
	 	
	 	jdbc:derby:myDB, 

		for Network Derby Server

	 	jdbc:derby://localhost:1527/myDB;user=usr;'

	

DML INSERT Operation

DML UPDATE Operation

DML DELETE Operation

DAO Pattern

GENERATED ALWAYS AS IDENTITY (START WITH 1,
INCREMENT BY 1)