CreateTestSQLServerDB (OGSA-DAI -- (c) International Business Machines Corporation, 2002-2006, The University of Edinburgh, 2002-2006)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

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