uk.org.ogsadai.client.dbcreate2
Class CreateTestDerbyDB

java.lang.Object
  |
  +--uk.org.ogsadai.client.dbcreate2.CreateTestDB
        |
        +--uk.org.ogsadai.client.dbcreate2.CreateTestDerbyDB

public class CreateTestDerbyDB

extends CreateTestDB

CreateTestDerbyDB.java This program will populate three tables in a Derby database called example_{traveller,destination,booking} and populate them with a total of 40,000 entries. The mNumberOfEntries field may be modified to generate a table with any desired number of rows. The nth row in each possible database will be identical across each one which has at least n rows (assuming Random is implemented the same on all Java jdks). Usage: java uk.org.ogsadai.client.dbcreate.CreateTestDerbyDB [-driverclass DerbyDriverClass] [-database DerbyDatabasePath] [-username DerbyUserName] [-password DerbyPassword] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: DerbyDriverClass: org.apache.derby.jdbc.EmbeddedDriver DerbyDatabaseName: C:/Downloads/Derby/ogsadai DerbyUserName: ogsadai DerbyPassword: ogsadai NameOfTableToCreate: littleblackbook NumberOfRowsToCreate: 10000

Author:

The OGSA-DAI Team

Field Summary

private static java.lang.String

COPYRIGHT_NOTICE

Fields inherited from class uk.org.ogsadai.client.dbcreate2.CreateTestDB

mBookingTable, mData, mDatabase, mDBMS, mDestinationTable, mDriver, mHost, mNumberOfBookings, mNumberOfDestinations, mNumberOfTravellers, mPassword, mPort, mRows, mSizeOfBlob, mTablePrefix, mTravellerTable, mUsername

Constructor Summary

CreateTestDerbyDB(java.lang.String[] args)
Creates and populates a Derby test database table according to the specified settings or the default settings if no arguments are used.

Method Summary

protected void	dropTableIfExists(java.sql.Connection connection, java.lang.String tablename) Drops the specified table.
protected java.sql.Connection	getConnection() Returns a java.sql.Connection data resource.
static void	main(java.lang.String[] args)
protected void	printUsage() Prints the general usage instructions for a CreateTestDerbyDB client.
protected void	printVariables(java.lang.String prefix) Displays the settings prefixed by the specified string.
protected void	setDefaultSettings() Sets the default settings for the client.
protected boolean	setupArguments(java.lang.String[] args) Parses the arguments for CreateTestDerbyDB clients.

Methods inherited from class uk.org.ogsadai.client.dbcreate2.CreateTestDB

createBookingTable, createDestinationTable, createTravellerTable, getCreateBookingTableStatement, getCreateDestinationTableStatement, getCreateTravellerTableStatement, loadDriver, populateDatabase

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

COPYRIGHT_NOTICE

private static final java.lang.String COPYRIGHT_NOTICE

See Also:

Constant Field Values

Constructor Detail

CreateTestDerbyDB

public CreateTestDerbyDB(java.lang.String[] args)

Creates and populates a Derby test database table according to the specified settings or the default settings if no arguments are used.

Parameters:

args - arguments passed to the main method.

Method Detail

setDefaultSettings

protected void setDefaultSettings()

Description copied from class: CreateTestDB

Sets the default settings for the client.

Specified by:

setDefaultSettings in class CreateTestDB

setupArguments

protected boolean setupArguments(java.lang.String[] args)

Parses the arguments for CreateTestDerbyDB clients.

Overrides:

setupArguments in class CreateTestDB

Parameters:

args - the argument string

Returns:

true if the arguments are parsed correctly, otherwise false

printUsage

protected void printUsage()

Prints the general usage instructions for a CreateTestDerbyDB client.

Overrides:

printUsage in class CreateTestDB

printVariables

protected void printVariables(java.lang.String prefix)

Displays the settings prefixed by the specified string.

Overrides:

printVariables in class CreateTestDB

Parameters:

prefix - the displayed settings begin with "prefix Settings:"

main

public static void main(java.lang.String[] args)

getConnection

protected java.sql.Connection getConnection()
                                     throws java.sql.SQLException

Description copied from class: CreateTestDB

Returns a java.sql.Connection data resource.

Specified by:

getConnection in class CreateTestDB

Returns:

Connection

Throws:

java.sql.SQLException

dropTableIfExists

protected void dropTableIfExists(java.sql.Connection connection,
                                 java.lang.String tablename)
                          throws java.sql.SQLException

Description copied from class: CreateTestDB

Drops the specified table. Note: This method must not throw an error if the table does not exist.

Specified by:

dropTableIfExists in class CreateTestDB

Parameters:

connection - a connection to the data resource

tablename - the name of the table to be created

Throws:

java.sql.SQLException