Derby (Java DB) Network Server and JDBC Driver Info

JDBC Tutorials - Herong's Tutorial Examples

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

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

If you want to know the Derby 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) 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());
    }
  }
}

If you are using Java 9 or higher version, you compile and run your Java program in one command:

(on Windows)
herong> java -cp %DERBY_HOME%\lib\derbyclient.jar SomeClass.java

(on Linux or macOS)
herong> java -cp $DERBY_HOME/lib/derbyclient.jar SomeClass.java

So let's try it here to run the sample program using one the commands below depending which computer platform you are using:

herong> java -cp %DERBY_HOME%\lib\derbyclient.jar DerbyDatabaseInfo.java
herong> java -cp $DERBY_HOME/lib/derbyclient.jar DerbyDatabaseInfo.java

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