Derby (Java DB) - Creating New Tables

This section describes how to create a new table in Derby (Java DB) database through the JDBC driver.

The next test I did was to add another table in my Derby (Java DB) database. This was done by running the CREATE TABLE statement with the executeUpdate() method. Here is the sample program I used to create a new table called, HY_Address:

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

// Creating a database table
      Statement sta = con.createStatement();
      int count = sta.executeUpdate(
        "CREATE TABLE HY_Address (ID INT, StreetName VARCHAR(20),"
        + " City VARCHAR(20))");
      System.out.println("Table created.");
      sta.close();

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

The Derby JDBC driver allowed me to create tables and there was no execution errors. See the output below:

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

Table created.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Installing and Running Derby (Java DB)

Derby (Java DB) JDBC Driver

 Derby (Java DB) Driver Features

 Loading Derby JDBC Driver Classes

 Creating Connections to Derby (Java DB) Network Server

 Derby (Java DB) Network Server and JDBC Driver Info

Derby (Java DB) - Creating New Tables

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

 Derby (Java DB) - Running SELECT Queries

 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

 Using Connection Pool with JDBC

 Archived Tutorials

 References

 Full Version in PDF/EPUB