Creating Connections to Java DB (Derby) Network Server

This section describes how to create connections to Java DB (Derby) Network Server.

After I have my Java DB (Derby) started in Network Server mode, I am ready to try to create a connect object to access an existing database on the server. Here is my sample program showing you how to create a connection to access the TestDB:

/* DerbyConnection.java
 - Copyright (c) 2015, HerongYang.com, All Rights Reserved.
 */
import java.sql.*;
public class DerbyConnection {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Connect with a url string
      con = DriverManager.getConnection(
        "jdbc:derby://localhost/TestDB");
      System.out.println("Derby connection ok.");
      con.close();

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

Make sure the Java DB (Derby) server has been started in a command window like this:

C:\local\javadb\databases>
  \Progra~1\java\jdk1.8.0_45\db\bin\startnetworkserver

Security manager installed using the Basic server security policy.
Apache Derby Network Server - 10.11.1.2 - (1629631) started and 
   ready to accept connections on port 1527

Also make sure that "TestDB" database has been created in server as shown in previous tutorials.

Now compile and run the example program, DerbyConnection.java, in another command window:

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

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

   Derby connection ok.

The output confirms that the DriverManager class loaded the driver class and created a connection to the Java DB (Derby) server correctly:

If you have not created the "TestDB" database yet, or you did not start the server from the database folder, you will get an error like "Exception: The connection was refused because the database TestDB was not found."

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

 Java DB (Derby) - Creating New Tables

 Java DB (Derby) - Inserting Data Rows to Existing Tables

 Java DB (Derby) - Running SELECT Queries

 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 - sqljdbc42.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

 Outdated Tutorials

 References

 PDF Printing Version