JDBC Tutorials - Herong's Tutorial Examples - v3.14, by Herong Yang
Derby (Java DB) in the JDK 1.8 Package
This section describes how to use Derby (Java DB) 10.11 that included in JDK 1.8 package.
Derby (Java DB) 10.11 free version is now included in the JDK package. If you have already downloaded and installed JDK 1.8, the Derby is available in the %JAVA_HOME%\db folder. There is no need to download and install Derby separately. For example, on my Windows computer, I have JDK 1.8.0_45 installed. The Derby is located at "C:\Program Files\Java\jdk1.8.0_45\db\".
Now set the DERBY_HOME environment variable:
herong> set DERBY_HOME=C:\Program Files\Java\jdk1.8.0_45\db"
If you haven't installed JDK 1.8 yet. Please follow the JDK 1.8 download and installation tutorial presented earlier in this book.
If you have an old version of Derby (Java DB) installed, you should remove the old version and remove related environment variables. For example, I have Derby (Java DB) 10.5.3 installed. So I need to remove the "C:\Program Files\Sun\JavaDB" folder.
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