uk.org.ogsadai.client.dbcreate2
Class CreateTestDB2DB

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

public class CreateTestDB2DB

extends CreateTestDB

This program will create three tables in a DB2 database called example_{traveller,destination,booking} and populate them with a total of 40,000 entries.

The mRows 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.CreateTestDB2DB [-driverclass DB2DriverClass] [-host DB2HostName] [-port DB2PortNumber] [-database DB2DatabaseName] [-username DB2UserName] [-password DB2Password] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: DB2DriverClass: com.ibm.db2.jcc.DB2Driver DB2HostName: localhost DB2PortNumber: 50000 DB2DatabaseName: ogsadai DB2UserName: ogsadai DB2Password: ogsadai NameOfTableToCreate: littleblackbook NumberOfRowsToCreate: 10000

Author:

The OGSA-DAI Project 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

CreateTestDB2DB(java.lang.String[] args)
Creates and populates a DB2 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 table) Drops the specified table.
protected java.sql.Connection	getConnection() Returns a java.sql.Connection data resource.
protected java.lang.String	getCreateDestinationTableStatement() Constructs the statement for creating a destination table.
static void	main(java.lang.String[] args)
protected void	setDefaultSettings() Sets the default settings for the client.

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

createBookingTable, createDestinationTable, createTravellerTable, getCreateBookingTableStatement, getCreateTravellerTableStatement, loadDriver, populateDatabase, printUsage, printVariables, setupArguments

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

CreateTestDB2DB

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

Creates and populates a DB2 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

main

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

setDefaultSettings

protected void setDefaultSettings()

Description copied from class: CreateTestDB

Sets the default settings for the client.

Specified by:

setDefaultSettings in class CreateTestDB

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 table)
                          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

table - the name of the table to be created

Throws:

java.sql.SQLException

getCreateDestinationTableStatement

protected java.lang.String getCreateDestinationTableStatement()

Description copied from class: CreateTestDB

Constructs the statement for creating a destination table. Subclasses can override this method if the statement differs.

Overrides:

getCreateDestinationTableStatement in class CreateTestDB

Returns:

String a create table statement