uk.org.ogsadai.client.dbcreate2
Class CreateTestDB2DB
java.lang.Object
|
+--uk.org.ogsadai.client.dbcreate2.CreateTestDB
|
+--uk.org.ogsadai.client.dbcreate2.CreateTestDB2DB
- public class CreateTestDB2DB
- extends CreateTestDB
This program will create three tables in a DB2 database called example_{traveller,destination,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.CreateTestDB2DB [-driverclass DB2DriverClass] [-host DB2HostName] [-port DB2PortNumber] [-database DB2DatabaseName] [-username DB2UserName] [-password DB2Password] [-tablename NameOfTableToCreate] [-rows NumberOfRowsToCreate] Default Settings: DB2DriverClass: com.ibm.db2.jcc.DB2Driver DB2HostName: localhost DB2PortNumber: 50000 DB2DatabaseName: ogsadai DB2UserName: ogsadai DB2Password: ogsadai NameOfTableToCreate: littleblackbook NumberOfRowsToCreate: 10000
- Author:
- The OGSA-DAI Project Team
| 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 |
CreateTestDB2DB(java.lang.String[] args)
Creates and populates a DB2 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 table)
Drops the specified table. |
protected java.sql.Connection |
getConnection()
Returns a java.sql.Connection data resource. |
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 java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
COPYRIGHT_NOTICE
private static final java.lang.String COPYRIGHT_NOTICE
-
- See Also:
- Constant Field Values
CreateTestDB2DB
public CreateTestDB2DB(java.lang.String[] args)
-
Creates and populates a DB2 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.
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 table)
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 resourcetable - 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