JDBC Tutorials - Herong's Tutorial Examples - Version 2.21, by Dr. Herong Yang

Downloading and Installing Java DB (Derby)

This section describes how to download and install Java DB (Derby) 10.2.2 - free for evaluation.

Java DB is a relational database management system that is based on the Java programming language and SQL. Java DB is a commercial release of the Apache Software Foundation's (ASF) open source relational database project. But you can still download a copy of Java DB free for evaluation. The Apache project is called Derby.

You can download and install a copy of Java DB 10.2.2 free for evaluation as shown in this tutorial:

  • Go to http://developers.sun.com/javadb/, the Java DB home page.
  • Cick the Downloads tab.
  • Click the Download link next to Java DB 10.2.2.
  • Click the Download link.
  • Register yourself.
  • Check the checkbox to accept the terms
  • Click "Windows self-extracting file" next to English - javadb-10_2_2_0-windows.exe 9.71 MB to start download Java DB.
  • Save the download file, javadb-10_2_2_0-windows.exe to \local
  • Double click \local\javadb-10_2_2_0-windows.exe to start unpacking the Java DB.

Now I have Java DB installed in directory: \local\javadb. No need to run any installation program.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 Downloading and Installing JDK - Java SE

Installing and Running Java DB - Derby

Downloading and Installing Java DB (Derby)

 "sysinfo" - Checking Java DB (Derby) Installation

 Setting Up Java DB (Derby) in Network Server

 "ij" - Client Tool to Create New Databases

 Derby (Java DB) JDBC Driver

 Derby (Java DB) JDBC DataSource Objects

 Java DB (Derby) - DML Statements

 Java DB (Derby) - ResultSet Objects of Queries

 Java DB (Derby) - PreparedStatement

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 Microsoft SQL Server 2005 Express Edition

 Microsoft JDBC Driver for SQL Server - sqljdbc.jar

 Microsoft JDBC Driver - Query Statements and Result Sets

 Microsoft JDBC Driver - DatabaseMetaData Object

 Microsoft JDBC Driver - DDL Statements

 Microsoft JDBC Driver - DML Statements

 SQL Server - PreparedStatement

 SQL Server CLOB (Character Large Object) - TEXT

 SQL Server BLOB (Binary Large Object) - BLOB

 JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

 JDBC-ODBC Bridge Driver - Flat Text Files

 JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC Bridge Driver - MS SQL Server

 Summary of JDBC Drivers and Database Servers

 Additional Tutorial Notes to Be Added

 References

 PDF Printing Version

Downloading and Installing Java DB (Derby) - Updated in 2014, by Dr. Herong Yang