org.apache.derbyTesting.perf.basic.jdbc

Class ValuesTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.junit.JDBCPerfTestCase

org.apache.derbyTesting.perf.basic.jdbc.ValuesTest

All Implemented Interfaces:

junit.framework.Test

public class ValuesTest
extends JDBCPerfTestCase

Add performance tests that use VALUES statement

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.PreparedStatement	ps

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
ValuesTest(java.lang.String name)
ValuesTest(java.lang.String name, int iterations, int repeats)

Method Summary

Modifier and Type	Method and Description
void	fetchByColumnName() Query is a simple VALUES statement.
void	fetchByColumnNumber() Query is a simple VALUES statement.
void	setUp() Setup for the tests that query the simple VALUES statement.
static junit.framework.Test	suite()
void	tearDown() cleanup resources

Methods inherited from class org.apache.derbyTesting.junit.JDBCPerfTestCase

runBareOverridable, runTest

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runScript, runScript, runSQLCommands, setAutoCommit, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, setName, toString

Methods inherited from class java.lang.Object

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

Field Detail

ps

private java.sql.PreparedStatement ps

Constructor Detail

ValuesTest

public ValuesTest(java.lang.String name,
                  int iterations,
                  int repeats)

ValuesTest

public ValuesTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Returns:

Tests that should be run as part of this class.

setUp

public void setUp()
           throws java.sql.SQLException

Setup for the tests that query the simple VALUES statement. Open a connection to the database, and prepare the query here

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

fetchByColumnName

public void fetchByColumnName()
                       throws java.sql.SQLException

Query is a simple VALUES statement.

"SELECT * FROM TABLE(VALUES (1,1,1), (2,2,2), (3,3,3), (4,4,4), (5,5,5)) AS T(\"cOlumN1\", COLUMN2, \"column3\")", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.CLOSE_CURSORS_AT_COMMIT);

This test fetches data using column name

Throws:

java.sql.SQLException

fetchByColumnNumber

public void fetchByColumnNumber()
                         throws java.sql.SQLException

Query is a simple VALUES statement.

"SELECT * FROM TABLE(VALUES (1,1,1), (2,2,2), (3,3,3), (4,4,4), (5,5,5)) AS T(\"cOlumN1\", COLUMN2, \"column3\")", ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY, ResultSet.CLOSE_CURSORS_AT_COMMIT);

This test fetches data using column number

Throws:

java.sql.SQLException

tearDown

public void tearDown()
              throws java.lang.Exception

cleanup resources

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception