Example: Creating a database

This example demonstrates how to create a file system database store in a Java SE Java environment. The Configuration object is used to create the database. Once created, a Connection object is returned. To create tables, the schemaUpdateBegin method is invoked to start changes to the underlying schema and the schemaUpdateComplete method completes changing the schema.

To run the CreateDb.java example

Change to the following directory: samples-dir\UltraLiteJ.

For information about the default location of samples-dir, see Samples directory.
Run the CreateDb example:
rundemo CreateDb

Use the following command to run this example (the command is case sensitive):

rundemo CreateDb

Notes

Tables in UltraLiteJ do not have owners and are identified only by name.
The Domain interface defines constants to denote the various data types supported in a column in an UltraLiteJ table.
The primary index (createPrimaryIndex) is guaranteed to be unique.

// *****************************************************
// Copyright (c) 2006-2010 iAnywhere Solutions, Inc.
// Portions copyright (c) 2006-2010 Sybase, Inc.
// All rights reserved. All unpublished rights reserved.
// *****************************************************
// This sample code is provided AS IS, without warranty or liability
// of any kind.
//
// You may use, reproduce, modify and distribute this sample code
// without limitation, on the condition that you retain the foregoing
// copyright notice and disclaimer as to the original iAnywhere code.
//
// *********************************************************************
package com.ianywhere.ultralitej.demo;

import com.ianywhere.ultralitej12.*;

/**
 * CreateDb: sample program to demonstrate Database creation.
 */
public class CreateDb
{
    /**
     * mainline for program.
     *
     * @param args command-line arguments
     *
     */
     
    public static void main
	( String[] args )
    {
	try {
	    Configuration config = DatabaseManager.createConfigurationFile( "Demo1.ulj" );
	    Connection conn = DatabaseManager.createDatabase( config );

	    executeSql( conn
		      , "CREATE TABLE department\n"
		       +"( dept_no INT NOT NULL PRIMARY KEY\n"
		       +", name VARCHAR(50)\n"
		       +")"
		      );

	    executeSql( conn
		      , "CREATE TABLE Employee\n"
		       +"( number INT NOT NULL PRIMARY KEY\n"
		       +", last_name VARCHAR(32)\n"
		       +", first_name VARCHAR(32)\n"
		       +", age INT\n"
		       +", dept_no INT\n"
		       +", FOREIGN KEY fk_emp_to_dept( dept_no ) REFERENCES department( dept_no )"
		       +")"
		      );

	    Demo.display( "\nCreateDb completed successfully" );

	} catch( ULjException exc ) {
	    Demo.displayException( exc );
	}
    }

    /** Execute a SQL statement.
     * @param conn connection to current database
     * @param stmt SQL statement to be executed
     */
    private static void executeSql( Connection conn, String stmt )
    	throws ULjException
    {
	Demo.display( "\nExecuting:\n", stmt );
	PreparedStatement ps = conn.prepareStatement( stmt );
	ps.execute();
	ps.close();
    }
}

Discuss this page in DocCommentXchange.