Skip to main content

Posts

Showing posts from October, 2019

Getting started with Apache Derby

Derby is free opensource database Install derby and start using bat file startnetwork.bat. C:\Users\AnilBalwani\Downloads\db-derby-10.12.1.1-bin\db-derby-10.12.1.1-bin\lib>java -jar derbyrun.jar ij ij version 10.12 ij> connect 'jdbc:derby:booksdb;create=true'; ij> CREATE TABLE book (book_id int primary key, title varchar(64)); 0 rows inserted/updated/deleted ij> INSERT INTO book VALUES (1, 'New Test'), (2, 'Testing'), (3, 'Correct'); 3 rows inserted/updated/deleted ij> select * from book; 3 rows will get selected