uk.org.ogsadai.client.dbcreate
Class CreateTestSQLServerDB

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

public class CreateTestSQLServerDB

extends CreateTestDB

This program will create a new table in a SQL Server database called littleblackbook and populate it with 10,000 address entries consisting of a name (First, Surname). Address and telephone number.

The numberOfEntries 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 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.dbcreate.CreateTestDB

mData, mDatabase, mDBMS, mDriver, mHost, mNumberOfEntries, mPassword, mPort, mTable, 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

static void	main(java.lang.String[] args)
protected void	populateDatabase() Populates the test database with the test data.
protected void	setDefaultSettings() Sets the default settings for the client.

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

loadDriver, 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

populateDatabase

protected void populateDatabase()
                         throws CreateTestDatabaseException

Description copied from class: CreateTestDB

Populates the test database with the test data.

Specified by:

populateDatabase in class CreateTestDB

CreateTestDatabaseException