org.apache.derbyTesting.perf.clients

Class SingleRecordSelectClient

java.lang.Object

org.apache.derbyTesting.perf.clients.SingleRecordSelectClient

All Implemented Interfaces:

Client

public class SingleRecordSelectClient
extends java.lang.Object
implements Client

Client which performs single-record lookups on tables generated by SingleRecordFiller. Each time the client's doWork() method is called, it will pick one of the tables randomly, and select one random record in that table.

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Connection	conn
private int	dataType
private boolean	noIndex
private java.sql.PreparedStatement[]	pss
private java.util.Random	r
private boolean	secondaryIndex
private int	tableSize

Constructor Summary

Constructors

Constructor and Description
SingleRecordSelectClient(int records, int tables) Construct a new single-record select client which fetches VARCHAR data by primary key.
SingleRecordSelectClient(int records, int tables, int type, boolean secIndex, boolean nonIndexed) Construct a new single-record select client.

Method Summary

Modifier and Type	Method and Description
void	doWork() Perform the work for a single iteration of the test (typically a single transaction).
private void	fetchTextColumn(java.sql.ResultSet rs, int column) Make sure the text column is retrieved and read.
void	init(java.sql.Connection c) Initialize this client (typically prepare the statements needed in the doWork() method).
void	printReport(java.io.PrintStream out) Print a report from the test run.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

conn

private java.sql.Connection conn

pss

private final java.sql.PreparedStatement[] pss

r

private final java.util.Random r

tableSize

private final int tableSize

dataType

private final int dataType

secondaryIndex

private final boolean secondaryIndex

noIndex

private final boolean noIndex

Constructor Detail

SingleRecordSelectClient

public SingleRecordSelectClient(int records,
                                int tables)

Construct a new single-record select client which fetches VARCHAR data by primary key.

Parameters:

records - the number of records in each table in the test

tables - the number of tables in the test

SingleRecordSelectClient

public SingleRecordSelectClient(int records,
                                int tables,
                                int type,
                                boolean secIndex,
                                boolean nonIndexed)

Construct a new single-record select client.

Parameters:

records - the number of records in each table in the test

tables - the number of tables in the test

type - the data type of the text column (java.sql.Types.VARCHAR, java.sql.Types.BLOB or java.sql.Types.CLOB)

secIndex - if true, select by secondary index column instead of primary key column

nonIndexed - if true, select by non-indexed column instead of primary key column

Method Detail

init

public void init(java.sql.Connection c)
          throws java.sql.SQLException

Description copied from interface: Client

Initialize this client (typically prepare the statements needed in the doWork() method).

Specified by:

init in interface Client

Parameters:

c - a connection which can be used by this client

Throws:

java.sql.SQLException - if a database error occurs

doWork

public void doWork()
            throws java.sql.SQLException

Description copied from interface: Client

Perform the work for a single iteration of the test (typically a single transaction).

Specified by:

doWork in interface Client

Throws:

java.sql.SQLException - if a database error occurs

printReport

public void printReport(java.io.PrintStream out)

Description copied from interface: Client

Print a report from the test run.

Specified by:

printReport in interface Client

Parameters:

out - stream to print the report to

fetchTextColumn

private void fetchTextColumn(java.sql.ResultSet rs,
                             int column)
                      throws java.sql.SQLException

Make sure the text column is retrieved and read. Different methods are used for the retrieval based on whether the column is a VARCHAR, a BLOB or a CLOB.

Throws:

java.sql.SQLException