Execute SQL statements If connection is established properly with the Apache Derby, you can now execute simple sequel statements from your command prompt ij tool as shown below Creating tables using ij tool ij> create table table_name(roll_no int, first_name varchar(10), last_name varchar(10)); Inserting values into the table ij> insert into table_name values (197878,’jack’,'Samurai’); ij> insert into table_name values (197823,’Corsa’,'Neo’); ij> insert ...

Setting Environment for Apache Derby Goto command prompt by keying on cmd from Run application launcher. Goto your java classpath and give the below command > java org.apache.derby.tools.ij Now your command prompt would change as shown below ij> Note: you may get errors if classpath is not set correctly Connecting to the database Connect to the database by giving the below command in ...

Install Derby Install Apache Derby from the below link http://db.apache.org/derby/derby_downloads.html “db-derby-10.5.1.1-bin.zip” Go to Command Prompt by clicking start button and selecting RUN option. Type cmd in the Run window to open the command prompt. SET Derby INSTALL using the below command > set DERBY_INSTALL=D:\Program Files\Java\db-derby-10.5.1.1-bin Configure Apache Derby To configure Apache Derby in embedded mode connect derby jars to the classpath derby.jar: contains the ...