import java.sql.*;
import java.util.*;

public class SetupJavaDB {
    public static void main(String[] args) throws Exception {
        String driver = "jdbc:derby:javadb/db";
        Properties info = new Properties();
        info.setProperty("create", "true");
        info.setProperty("user", "userid");
        info.setProperty("password", "password");
        Connection conn = DriverManager.getConnection(driver, info);
        conn.setAutoCommit(false);
        Statement stat = conn.createStatement();
        stat.executeUpdate("CREATE TABLE NTABLE (ID INT GENERATED ALWAYS AS IDENTITY, TEXT CHAR(10))");
        stat.executeUpdate("INSERT INTO NTABLE (TEXT) VALUES ('One')");
        stat.executeUpdate("INSERT INTO NTABLE (TEXT) VALUES ('Two')");
        stat.executeUpdate("INSERT INTO NTABLE (TEXT) VALUES ('Three')");
        conn.setAutoCommit(true);
    }
}