Java DB (Derby) Network Server and JDBC Driver Info

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

JDBC Tutorials - Herong's Tutorial Examples

∟Java DB (Derby) Network Server and JDBC Driver Info

This section describes how to get some basic info about Java DB (Derby) and JDBC driver through the JDBC DatabaseMetaData object.

If you want to know the Java DB database name and version, or the JDBC driver name and version, you can get them through the DatabaseMetaData object as shown in the following sample program:

/* DerbyDatabaseInfo.java
 - Copyright (c) 2015, HerongYang.com, All Rights Reserved.
 */
import java.sql.*;
public class DerbyDatabaseInfo {
  public static void main(String [] args) {
    Connection con = null;
    try {
      con = DriverManager.getConnection(
        "jdbc:derby://localhost/TestDB");

// Database and driver info
      DatabaseMetaData meta = con.getMetaData();
      System.out.println("Server name: " 
        + meta.getDatabaseProductName());
      System.out.println("Server version: "
        + meta.getDatabaseProductVersion());
      System.out.println("Driver name: "
        + meta.getDriverName());
      System.out.println("Driver version: "
        + meta.getDriverVersion());
      System.out.println("JDBC major version: "
        + meta.getJDBCMajorVersion());
      System.out.println("JDBC minor version: "
        + meta.getJDBCMinorVersion());

      con.close();
    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
}

Here is the output of my sample program:

C:\herong>\Progra~1\java\jdk1.8.0_45\bin\javac DerbyDatabaseInfo.java

C:\herong>\Progra~1\java\jdk1.8.0_45\bin\java 
   -cp .;\progra~1\java\jdk1.8.0_45\db\lib\derbyclient.jar 
   DerbyDatabaseInfo

Server name: Apache Derby
Server version: 10.11.1.2 - (1629631)
Driver name: Apache Derby Network Client JDBC Driver
Driver version: 10.11.1.2 - (1629631)
JDBC major version: 4
JDBC minor version: 2

The output confirms that Derby JDBC driver 10.11 supports JDBC 4.2

Last update: 2015.

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Java DB - Derby

►Derby (Java DB) JDBC Driver

Derby (Java DB) Driver Features

Loading Derby JDBC Driver Classes

Creating Connections to Java DB (Derby) Network Server

►Java DB (Derby) Network Server and JDBC Driver Info