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 CreateTestOracleDB

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

CreateTestOracleDB.java This program will create three tables in an Oracle database called example_{destination,traveller,booking} and populate them with a total of 40,000 entries. The mRows 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.CreateTestOracleDB [-driverclass OracleDriverClass] [-host OracleHostName] [-port OraclePortNumber] [-database OracleDatabaseName] [-username OracleUserName] [-password OraclePassword] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: OracleDriverClass: oracle.jdbc.driver.OracleDriver OracleHostName: localhost OraclePortNumber: 1521 OracleDatabaseName: ogsadai OracleUserName: scott OraclePassword: tiger 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
CreateTestOracleDB(java.lang.String[] args)
          Creates and populates a Oracle 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.
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, getCreateTravellerTableStatement, 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

CreateTestOracleDB

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

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