What is myeclipse Derby?

What is myeclipse Derby? Apache Derby is a perfect, open-source, 100%-Java, and easy-to-manage relational database management system that can be delivered with the features of some commercial products.

Apache Derby is a platform-independent database engine that provides external services in the form of Java class libraries. Unlike other databases that are difficult to deploy, installing myeclipse Derby is very simple. You only need to copy the. jar file to the system and add the. jar file to your project.

Although myeclipse Derby is easy to install, it has many features. It supports all enterprise-level features of relational databases, including crash recovery, transaction rollback and commit, row/table locks, views, primary key/foreign key constraints, triggers, and subquery expressions.

You can deploy and run myeclipse derby in two modes:

1. In embedded mode, myeclipse Derby only processes requests from the same JVM as the application uses. When myeclipse Derby is used in Embedded mode, the application automatically starts or stops the relational engine when it is started or disabled. The Derby. jar file (2 MB) of the Derby package contains the myeclipse Derby database engine and the embedded JDBC driver.

2. In network server mode, Derby processes application requests from different JVMs. Alternatively, if you prefer to write programs using Perl, PHP, Python, or C, you can also deploy a derby network server and connect to the server through modules specific to various languages, for example, Perl DBI (Database Interface) and php odbc (Open Database Connectivity ). The derbynet. jar file (0.2 MB) of Derby contains the Derby network server.

Usage process:

1. Start the server myeclipse derby on the servers panel in the myeclipse view.

2. Choose WINDOW> open persipective> myeclipse Database Explorer to open the new database view.

3. Select the myeclipse Derby item under the left-side dB browser panel, right-click and select the menu item open connection in the pop-up menu to open the database connection and display all the databases and tables.

4. Expand the myeclipse Derby node, click connected to myeclipse Derby, right-click and select the menu item new SQL editor in the pop-up menu.

5. type the following table creation statements in the SQL Editor:

Create Table testuser (
Id int not null,
Username varchar (200 ),
Age int,
Primary Key ("ID ")
)

Click the Green run right arrow button on the editor to create a table.

So here is the introduction of myeclipse Derby. Other related information will be covered in other articles.