uk.org.ogsadai.client.dbcreate2
Class CreateTestSQLServerDB

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

public class CreateTestSQLServerDB

extends CreateTestDB

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

The rows 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.CreateTestSQLServerDB [-driverclass MySQLDriverClass] [-host SQLServerHostName] [-database SQLServerDatabaseName] [-username SQLServerUserName] [-password SQLServerPassword] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: SQLServerDriverClass: com.microsoft.jdbc.sqlserver.SQLServerDriver SQLServerHostName: localhost SQLServerDatabaseName: ogsadai SQLServerUserName: ogsadai SQLServerPassword: ogsadai PrefixOfTablesToCreate: example_ NumberOfRowsToCreate: 40000

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

CreateTestSQLServerDB(java.lang.String[] args)
Creates and populates a PostgreSQL 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.
protected java.lang.String	getCreateBookingTableStatement() Constructs the statement for creating the traveller table.
protected java.lang.String	getCreateDestinationTableStatement() Constructs the statement for creating a destination table.
protected java.lang.String	getCreateTravellerTableStatement() Constructs the statement for creating the traveller 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, 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

CreateTestSQLServerDB

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

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

getCreateTravellerTableStatement

protected java.lang.String getCreateTravellerTableStatement()

Description copied from class: CreateTestDB

Constructs the statement for creating the traveller table. Subclasses can override this method if a data resource uses a different statement.

Overrides:

getCreateTravellerTableStatement in class CreateTestDB

Returns:

a create table statement

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

getCreateBookingTableStatement

protected java.lang.String getCreateBookingTableStatement()

Description copied from class: CreateTestDB

Constructs the statement for creating the traveller table. Subclasses can override this method if a data resource uses a different statement.

Overrides:

getCreateBookingTableStatement in class CreateTestDB

Returns:

a create table statement