Apache Derby – Introduction Apache Derby is a Relational Database Management System which is fully based on (written/implemented in) Java programming language. It is an open source database developed by Apache Software Foundation. Oracle released the equivalent of Apache Derby with the name JavaDB. Features of Apache Derby Following are the notable features of Derby […]
Category Archives: apache Derby
Apache Derby – Tools Apache Derby provides you tools such as sysinfo, ij and, dblook. sysinfo tool Using this tool, you can get information about Java and Derby environment. Browse through the bin folder of Derby installation directory and execute the sysinfo command as shown below − C:UsersMY_USER>cd %DERBY_HOME%/bin C:Derbybin>sysinfo On executing, it gives you […]
Apache Derby – Create Table The CREATE TABLE statement is used for creating a new table in Derby database. Syntax Following is the syntax of the CREATE statement. CREATE TABLE table_name ( column_name1 column_data_type1 constraint (optional), column_name2 column_data_type2 constraint (optional), column_name3 column_data_type3 constraint (optional) ); Another way to create a table in Apache Derby is […]