JDBC Tutorials - Herong's Tutorial Examples - v3.14, by Herong Yang
"sysinfo" - Checking Derby (Java DB) Installation
This section describes how to use 'sysinfo' to verify Derby (Java DB) installation.
Assuming that you have Derby (Java DB) installed on your local Windows, Linux or macOS system, you can use the "sysinfo" tool as suggested in Derby documents to verify the installation:
(on Windows system) herong> %DERBY_HOME%\bin\sysinfo (on Linux or macOS system) herong$ $DERBY_HOME/bin/sysinfo ------------------ Java Information ------------------ Java Version: 21.0.2 Java Vendor: Oracle Corporation Java home: /Library/Java/JavaVirtualMachines/jdk-21.jdk/Contents/Home Java classpath: /Users/herong/local/db-derby-10.17.1.0-bin/lib/derbyshared.jar :/Users/herong/local/db-derby-10.17.1.0-bin/lib/derby.jar :/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbynet.jar :/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbytools.jar :/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbyoptionaltools.jar :/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbyclient.jar OS name: Mac OS X OS architecture: x86_64 OS version: 10.12.6 Java user name: herong Java user home: /Users/herong Java user dir: /Users/herong/local java.specification.name: Java Platform API Specification java.specification.version: 21 java.runtime.version: 21.0.2+13-LTS-58 --------- Derby Information -------- [/Users/herong/local/db-derby-10.17.1.0-bin/lib/derby.jar] 10.17.1.0 - (1913217) [/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbytools.jar] 10.17.1.0 - (1913217) [/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbynet.jar] 10.17.1.0 - (1913217) [/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbyclient.jar] 10.17.1.0 - (1913217) [/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbyshared.jar] 10.17.1.0 - (1913217) [/Users/herong/local/db-derby-10.17.1.0-bin/lib/derbyoptionaltools.jar] 10.17.1.0 - (1913217) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US]] Found support for locale: [cs] version: 10.17.1.0 - (1913217) ... ------------------------------------------------------
The output confirms that my Derby was installed properly. The version is 10.17.1.0
Table of Contents
JDBC (Java Database Connectivity) Introduction
►Installing and Running Derby (Java DB)
Downloading and Installing Derby (Java DB)
Derby (Java DB) in the JDK 1.8 Package
Downloading Derby (Java DB) Documents
►"sysinfo" - Checking Derby (Java DB) Installation
Setting Up Derby (Java DB) in Network Server
"ij" - Client Tool to Create New Databases
Derby (Java DB) JDBC DataSource Objects
Derby (Java DB) - DML Statements
Derby (Java DB) - ResultSet Objects of Queries
Derby (Java DB) - PreparedStatement
Summary of JDBC Drivers and Database Servers