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 CreateTestDerbyDB

java.lang.Object
  |
  +--uk.org.ogsadai.client.dbcreate2.CreateTestDB
        |
        +--uk.org.ogsadai.client.dbcreate2.CreateTestDerbyDB
public class CreateTestDerbyDB
extends CreateTestDB

CreateTestDerbyDB.java This program will populate three tables in a Derby database called example_{traveller,destination,booking} and populate them with a total of 40,000 entries. The mNumberOfEntries 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.CreateTestDerbyDB [-driverclass DerbyDriverClass] [-database DerbyDatabasePath] [-username DerbyUserName] [-password DerbyPassword] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: DerbyDriverClass: org.apache.derby.jdbc.EmbeddedDriver DerbyDatabaseName: C:/Downloads/Derby/ogsadai DerbyUserName: ogsadai DerbyPassword: ogsadai NameOfTableToCreate: littleblackbook NumberOfRowsToCreate: 10000

Author:
The OGSA-DAI 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
CreateTestDerbyDB(java.lang.String[] args)
          Creates and populates a Derby 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.
static void main(java.lang.String[] args)
           
protected  void printUsage()
          Prints the general usage instructions for a CreateTestDerbyDB client.
protected  void printVariables(java.lang.String prefix)
          Displays the settings prefixed by the specified string.
protected  void setDefaultSettings()
          Sets the default settings for the client.
protected  boolean setupArguments(java.lang.String[] args)
          Parses the arguments for CreateTestDerbyDB clients.
 
Methods inherited from class uk.org.ogsadai.client.dbcreate2.CreateTestDB
createBookingTable, createDestinationTable, createTravellerTable, getCreateBookingTableStatement, getCreateDestinationTableStatement, getCreateTravellerTableStatement, loadDriver, populateDatabase
 
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

CreateTestDerbyDB

public CreateTestDerbyDB(java.lang.String[] args)
Creates and populates a Derby 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

setDefaultSettings

protected void setDefaultSettings()
Description copied from class: CreateTestDB
Sets the default settings for the client.

Specified by:
setDefaultSettings in class CreateTestDB

setupArguments

protected boolean setupArguments(java.lang.String[] args)
Parses the arguments for CreateTestDerbyDB clients.

Overrides:
setupArguments in class CreateTestDB
Parameters:
args - the argument string
Returns:
true if the arguments are parsed correctly, otherwise false

printUsage

protected void printUsage()
Prints the general usage instructions for a CreateTestDerbyDB client.

Overrides:
printUsage in class CreateTestDB

printVariables

protected void printVariables(java.lang.String prefix)
Displays the settings prefixed by the specified string.

Overrides:
printVariables in class CreateTestDB
Parameters:
prefix - the displayed settings begin with "prefix Settings:"

main

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

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