Apache Derby 简明教程

Apache Derby - Environment Setup

后续章节将说明如何下载和安装 Apache Derby。

Following chapter explains how to download and install Apache Derby.

Downloading Apache Derby

访问 Apache Derby 主页 https://db.apache.org/derby/ 。单击“下载”选项卡。

Visit the home page of Apache Derby home page https://db.apache.org/derby/. Click the Download tab.

选择并单击 Apache Derby 最新版本的链接。

Select and click on the link of the latest version of Apache Derby.

单击所选链接后，您将被重新定向到 Apache Derby 的 Distributions 页面。如果您在此观察，derby 提供了名为 db-derby-bin、db-derbylib.zip、db-derby-lib-debug.zip 和 db-derby-src.zip 的发行版。

On clicking the selected link, you will be redirected to the Distributions page of apache derby. If you observe here, derby provides distributions namely, db-derby-bin, db-derbylib.zip, db-derby-lib-debug.zip, and db-derby-src.zip.

下载 db-derby-bin 文件夹。将其内容复制到您要安装 Apache Derby 的单独文件夹中。（例如， C:\Derby ）

Download the db-derby-bin folder. Copy its contents to a separate folder where you wanted to install Apache Derby. (for example, say C:\Derby)

现在，要使用 Derby，

Now, to work with Derby,

Make sure that you already have set the JAVA_HOME variable by passing the location of bin folder of Java Installation folder, and include the JAVA_HOME/bin in the PATH variable.
Create a new environment variable, DERBY_HOME with value C:\Derby.
The bin folder of db-derby-bin distributions (we changed it as C:\Derby\bin) contains all the required jar files.

如前所述，Apache Derby 可以通过以下两种方式安装/部署 −

As discussed, Apache Derby can be installed/deployed in two ways as follows −

Embedded mode − In this, you need to access the database using Embedded Derby JDBC driver. You can start and stop derby through Java application. Both Database engine and your application will run on the same JVM.
Network Server mode − In this mode, you can access Derby in a typical clientserver fashion, where Derby is embedded in the server system. Then, the client machines running in different JVM’s (that of the Server) will send requests to the server, and the server responds to those requests.

客户端可以是服务器相同系统计算机中的另一个 JVM 或远程系统的 Java 应用程序。

The client can be another JVM in the same system machine of the server or a Java application from a remote system.

Installing Derby in Embedded Mode

要以嵌入式模式安装 Apache Derby，请在您的 CLASSPATH 中包含 jar 文件 derby.jar 。

To install Apache Derby in embedded mode, include the jar file derby.jar in your CLASSPATH.

或者，您可以通过运行 setEmbeddedCP 命令设置必需 jar 文件的类路径。浏览 Apache Derby 的 bin 目录，并如下所示运行此文件：

Or, you can set the classpath for required jar files by running the setEmbeddedCP command. Browse through the bin directory of Apache Derby and run this file as shown below −

C:\Users\MYUSER>cd %DERBY_HOME%/bin
C:\Derby\bin>setEmbeddedCP.bat
C:\Derby\bin>SET DERBY_HOME=C:\Derby
C:\Derby\bin>set
CLASSPATH=C:\Derby\lib\derby.jar;C:\Derby\lib\derbytools.jar;C:\Derby/lib/derby
optionaltools.jar;C:\Users\Tutorialspoint\Google
Drive\Office\Derby\derby_zip\New folder\db-derby-10.12.1.1-
bin\lib;C:\EXAMPLES_\Task\jars\*;C:\EXAMPLES\jars\mysql-connector-java-5.1.40-
bin.jar;C:\Users\Tutorialspoint\Google Drive\Office\37.Junit
Update\jars;C:\Program Files\Apache Software Foundation\Tomcat
8.5\lib\*;C:\Derby\lib\*;

设置 Apache Derby 后，要访问它，请使用嵌入式驱动运行 Java 程序。

After setting up Apache Derby, to access it, run Java programs using the embedded driver.

Verification

您可以使用 ij 工具验证设置，如下所示：

You can verify the setup using the ij tool as shown below −

C:\Derby\bin>ij
ij version 10.14
ij> connect 'jdbc:derby:SampleDB;create=true';
ij>

Installing Derby in Network Server Mode

要在网络服务器模式下安装 Apache Derby，您需要将 derbynet.jar 和 derbytools.jar 文件包含到 CLASSPATH 中。

To install Apache Derby in network server mode, you need to include derbynet.jar and derbytools.jar files to the CLASSPATH.

或者，您可以通过运行 setNetworkServerCP 命令设置必需 jar 文件的类路径。浏览 Apache Derby 的 bin 目录，并如下所示运行此文件：

Or, you can set the class path for required jar files by running the setNetworkServerCP command. Browse through the bin directory of Apache Derby and run this file as shown below −

C:\Users\MYUSER>cd %DERBY_HOME%/bin
C:\Derby\bin>setNetworkServerCP.bat
C:\Derby\bin>SET DERBY_INSTALL=C:\Derby
C:\Derby\bin>set
CLASSPATH=C:\Derby\lib\derbynet.jar;C:\Derby\lib\derbytools.jar;C:\Derby/lib/de
rbyoptionaltools.jar;C:\Users\Tutorialspoint\Google
Drive\Office\Derby\derby_zip\New folder\db-derby-10.12.1.1-
bin\lib;C:\EXAMPLES_\Task\jars\*;C:\EXAMPLES\jars\mysql-connector-java-5.1.40-
bin.jar;C:\Users\Tutorialspoint\Google Drive\Office\37.Junit
Update\jars;C:\Program Files\Apache Software Foundation\Tomcat
8.5\lib\*;C:\Derby\lib\*;

Starting Derby in Server Mode

您可以通过运行命令 startNetworkServer 启动网络服务器。浏览 Apache Derby 的 bin 目录，并如下所示运行此命令：

You can start Network Server by running the command startNetworkServer. Browse through the bin directory of Apache Derby and run this command as shown below −

C:\Derby\bin>startNetworkServer
Fri Jan 04 11:20:30 IST 2019 : Security manager installed using the Basic
server security policy.
Fri Jan 04 11:20:30 IST 2019 : Apache Derby Network Server - 10.14.2.0 -
(1828579) started and ready to accept connections on port 1527

或者，您可以如下所示使用 derbyrun.jar 启动服务器：

Or, you can start the server using derbyrun.jar as shown below −

C:\Users\MYUSER>cd %DERBY_HOME%/lib
C:\Derby\lib>java -jar derbyrun.jar server start
Fri Jan 04 11:27:20 IST 2019: Security manager installed using the Basic server
security policy.
Fri Jan 04 11:27:21 IST 2019: Apache Derby Network Server - 10.14.2.0 -
(1828579) started and ready to accept connections on port 1527

Network Client

在客户端中，将 jar 文件 derbyclient.jar 和 derbytools.jar 添加到 CLASSPATH 中。或者，如下所示运行 setNetworkClientCP 命令：

In client, add the jar files derbyclient.jar and derbytools.jar to the CLASSPATH. Or, run the setNetworkClientCP command as shown below −

C:\Users\MYUSER>cd %DERBY_HOME%/bin
C:\Derby\bin>setNetworkClientCP
C:\Derby\bin>SET DERBY_HOME=C:\Derby
C:\Derby\bin>set
CLASSPATH=C:\Derby\lib\derbyclient.jar;C:\Derby\lib\derbytools.jar;C:\Derby/lib
/derbyoptionaltools.jar;C:\Derby\lib\derby.jar;C:\Derby\lib\derbytools.jar;C:\D
erby/lib/derbyoptionaltools.jar;C:\Users\Tutorialspoint\Google
Drive\Office\Derby\derby_zip\New folder\db-derby-10.12.1.1-
bin\lib;C:\EXAMPLES_\Task\jars\*;C:\EXAMPLES\jars\mysql-connector-java-5.1.40-
bin.jar;C:\Users\Tutorialspoint\Google Drive\Office\37.Junit
Update\jars;C:\Program Files\Apache Software Foundation\Tomcat
8.5\lib\*;C:\Derby\lib\*;

然后，您可以从该客户端向服务器发送请求。

Then from this client, you can send requests to the server.

Verification

您可以使用 ij 工具验证设置，如下所示：

You can verify the setup using the ij tool as shown below −

C:\Derby\bin>ij
ij version 10.14
ij> connect 'jdbc:derby://localhost:1527/SampleDB;create=true';
ij>

Apache Derby Eclipse Environment

在使用 Eclipse 时，您需要为所有必需的 jar 文件设置构建路径。

While working with Eclipse, you need to set the build path for all the required jar files.

Step 1: Create a project and set build path

打开 Eclipse 并创建一个示例项目。右键单击该项目，然后选择选项 Build Path → Configure Build 路径，如下所示 −

Open eclipse and create a sample project. Right click on the project and select the option Build Path → Configure Build Path as shown below −

在 Libraries 选项卡的 Java Build Path 框架中，单击 Add External JARs 。

In the Java Build Path frame in the Libraries tab, click on Add External JARs.

并选择 Derby 安装文件夹的 lib 文件夹中的所需 jar 文件，然后单击 Apply and Close 。

And select the required jar files in the lib folder of the Derby installation folder and click on Apply and Close.