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.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
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD