public class ResultSetsFromPreparedStatementTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
ashok |
static java.lang.Object[] |
ashok_emp |
static java.lang.String |
bobbie |
static java.lang.Object[] |
bobbie_emp |
private java.sql.Connection |
c2
Secondary connection.
|
private java.sql.Connection |
c3 |
static java.lang.String |
CAS |
static java.lang.Object[] |
cs_dept |
static java.lang.String |
CT |
static java.lang.String |
dan |
static java.lang.Object[] |
dan_emp |
static java.lang.Object[] |
db_dept |
static java.lang.Object[][] |
dept |
private static long |
DERBY_DEFAULT_TIMEOUT |
static java.lang.String |
DNO |
static java.lang.String |
don |
static java.lang.Object[] |
don_emp |
static java.lang.String |
DS |
static java.lang.Object[][] |
emp |
static java.lang.String |
ES |
static java.lang.String |
guy |
static java.lang.Object[] |
guy_emp |
static java.lang.String |
hamid |
static java.lang.Object[] |
hamid_emp |
static java.lang.Integer |
i1 |
static java.lang.Integer |
i10 |
static java.lang.Integer |
i11 |
static java.lang.Integer |
i12 |
static java.lang.Integer |
i13 |
static java.lang.Integer |
i14 |
static java.lang.Integer |
i15 |
static java.lang.Integer |
i16 |
static java.lang.Integer |
i17 |
static java.lang.Integer |
i18 |
static java.lang.Integer |
i19 |
static java.lang.Integer |
i2 |
static java.lang.Integer |
i20 |
static java.lang.Integer |
i3 |
static java.lang.Integer |
i4 |
static java.lang.Integer |
i5 |
static java.lang.Integer |
i6 |
static java.lang.Integer |
i7 |
static java.lang.Integer |
i8 |
static java.lang.Integer |
i9 |
static java.lang.String |
jim |
static java.lang.Object[] |
jim_emp |
static java.lang.String |
joe1 |
static java.lang.Object[] |
joe1_emp |
static java.lang.String |
joe2 |
static java.lang.Object[] |
joe2_emp |
static java.lang.String |
john |
static java.lang.Object[] |
john_emp |
static java.lang.String |
k51 |
static java.lang.String |
k52 |
static java.lang.String |
k55 |
static java.lang.String |
larry1 |
static java.lang.Object[] |
larry1_emp |
static java.lang.String |
larry2 |
static java.lang.Object[] |
larry2_emp |
static java.lang.String |
lily1 |
static java.lang.Object[] |
lily1_emp |
static java.lang.String |
lily2 |
static java.lang.Object[] |
lily2_emp |
private static java.lang.String[] |
mgrs |
static java.lang.String |
monica |
static java.lang.Object[] |
monica_emp |
private static java.lang.String[] |
non_mgrs |
static java.lang.Object[] |
ofc_dept |
static java.lang.String |
robin |
static java.lang.Object[] |
robin_emp |
static java.lang.String |
roger |
static java.lang.Object[] |
roger_emp |
static java.lang.String |
sam1 |
static java.lang.Object[] |
sam1_emp |
static java.lang.String |
sam2 |
static java.lang.Object[] |
sam2_emp |
static java.lang.String |
SCHEMA |
static java.lang.String |
SETN |
private static java.lang.String |
SQLSTATE_NULL_INTO_NON_NULL |
static java.lang.String |
truong |
static java.lang.Object[] |
truong_emp |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
ResultSetsFromPreparedStatementTest(java.lang.String name)
Standard JUnit constructor
|
Modifier and Type | Method and Description |
---|---|
static void |
apply(java.sql.PreparedStatement action,
java.lang.Object[][] table)
Apply a PreparedStatement repeatedly with the set of parameter
vectors.
|
private static void |
assertResultSet(java.lang.String message,
java.lang.Object[][] expected,
java.sql.ResultSet returned)
Iterates over an array of row vectors, comparing each to the
data in the RS using assertRow.
|
private static void |
assertRow(java.lang.String message,
java.lang.Object[] expected,
java.sql.ResultSet returned)
Iterates over a row vector, comparing each to the corrsponding
column in the ResultSet.
|
private void |
createDerby4330_join_tables() |
private void |
createDerby4330_union_tables() |
private void |
createTestTable(java.lang.String name,
java.lang.String signature,
java.lang.String src)
Create table for this fixture.
|
private static void |
dump(java.sql.ResultSet dumpee,
java.io.PrintStream stream)
Prints a ResultSet to a PrintStream.
|
private static void |
dumpDiff(java.lang.Object[][] expected,
int fromRow,
java.sql.ResultSet dumpee,
boolean moreRows,
java.io.PrintStream stream)
Prints a diff between a ResultSet and an expected Object[][]
value to a PrintStream.
|
private static void |
dumpObjectArray(java.sql.ResultSet dumpee,
java.io.PrintStream stream)
Prints a ResultSet to a PrintStream in the form of an
Object[][] constant that can be used as "expected outcome" in
assertions.
|
private boolean |
hasTableXLock(java.lang.String table)
Check whether a table is locked exclusively.
|
private static java.lang.String |
insertFrom(java.lang.String dst,
java.lang.String src) |
static java.lang.String |
insertInto(java.lang.String table,
int params)
Creates a String containing an insert statement for the
specified table containing the specified number of '?'
|
static java.lang.String |
ref(java.lang.String table) |
private void |
setSchema(java.lang.String schema) |
private void |
setTimeout(long t) |
protected void |
setUp() |
static junit.framework.Test |
suite()
Set up a common environment for all fixtures.
|
protected void |
tearDown()
Tear down this fixture, sub-classes should call
super.tearDown().
|
void |
testAnyResultSet()
Test AnyResultSet
|
void |
testBigintGeneratedAlwaysAsIdentity() |
void |
testBigintGeneratedByDefaultAsIdentity() |
void |
testCallStatementResultSet()
Test CallStatementResultSet
|
void |
testCurrentOfResultSet()
Test CurrentOfResultSet
|
void |
testDeleteCascadeUpdateResultSet()
Test DeleteCascadeUpdateResultSet
|
void |
testDeleteResultSet()
Test DeleteResultSet
|
void |
testDerby4330_DistinctGroupedAggregateResultSet() |
void |
testDerby4330_DistinctScalarAggregateResultSet() |
void |
testDerby4330_GroupedAggregateResultSet() |
void |
testDerby4330_JoinResultSet() |
void |
testDerby4330_SetOpResultSet() |
void |
testDerby4330_UnionResultSet() |
void |
testDistinctGroupedAggregateResultSet()
Test DistinctGroupedAggregateResultSet
|
private void |
testDistinctGroupedAggregateResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testDistinctScalarAggregateResultSet()
Test DistinctScalarAggregateResultSet
|
private void |
testDistinctScalarAggregateResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testDistinctScanResultSet()
Test DistinctScanResultSet
|
private void |
testDistinctScanResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
private void |
testGeneratedIdentity(java.lang.String dataType,
java.lang.String generatedType)
Private helper method.
|
void |
testGroupedAggregateResultSet()
Test GroupedAggregateResultSet
|
private void |
testGroupedAggregateResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testHashLeftOuterJoinResultSet()
Test HashLeftOuterJoinResultSet
|
private void |
testHashLeftOuterJoinResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testHashTableResultSet()
Test HashTableResultSet
|
private void |
testHashTableResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testInsertNullIntoNonNullableColumn()
Test case for DERBY-4488, where the third execution of a statement
that attempted to insert a NULL into a non-nullable column failed with
a NullPointerException.
|
void |
testIntGeneratedAlwaysAsIdentity() |
void |
testIntGeneratedByDefaultAsIdentity() |
void |
testLastIndexKeyResultSet()
Test LastIndexKeyResultSet
|
private void |
testLastIndexKeyResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testNestedLoopLeftOuterJoinResultSet()
Test NestedLoopLeftOuterJoinResultSet
|
private void |
testNestedLoopLeftOuterJoinResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testNestedLoopResultSet()
Test NestedLoopResultSet
|
private void |
testNestedLoopResultSet(java.sql.PreparedStatement tst,
java.sql.PreparedStatement del) |
void |
testOnceResultSet()
Test OnceResultSet
|
private void |
testRuntimeStatistics(java.lang.String sql,
java.lang.String schema)
Private helper method that prepares and executes an SQL statement
multiple times and checks that the runtime statistics for the correct
statement is collected.
|
void |
testRuntimeStatisticsForCall()
Test that runtime statistics are collected on re-execution of a
CALL statement.
|
void |
testRuntimeStatisticsForDelete()
Test that runtime statistics are collected on re-execution of a
DELETE statement.
|
void |
testRuntimeStatisticsForInsert()
Test that runtime statistics are collected on re-execution of an
INSERT statement.
|
void |
testRuntimeStatisticsForSelect()
Test that runtime statistics are collected on re-execution of a
SELECT statement.
|
void |
testRuntimeStatisticsForUpdate()
Test that runtime statistics are collected on re-execution of an
UPDATE statement.
|
void |
testRuntimeStatisticsForValues()
Test that runtime statistics are collected on re-execution of a
VALUES statement.
|
void |
testScalarAggregateResultSet()
Test ScalarAggregateResultSet
|
private void |
testScalarAggregateResultSet(java.sql.PreparedStatement ps,
java.sql.PreparedStatement del) |
void |
testSetMaxRowsTable()
Tests that the
maxRows setting takes effect, data is obtained
from a table select. |
void |
testSetMaxRowsValues()
Tests that the
maxRows setting takes effect, data is obtained
from a value clause. |
void |
testSetOpResultSet_except()
Test SetOpResultSet except
|
void |
testSetOpResultSet_intersect()
Test SetOpResultSet intersect
|
void |
testSetTransactionResultSet()
Test SetTransactionResultSet
|
void |
testSmallintGeneratedAlwaysAsIdentity() |
void |
testSmallintGeneratedByDefaultAsIdentity() |
void |
testUnionResultSet()
Test UnionResultSet
|
void |
testUpdateResultSet()
Test UpdateResultSet
|
void |
testUpdateResultSetWithIsolation()
Test that an UpdateResultSet is able to detect changes in isolation
level between executions.
|
void |
testVTIResultSet()
Test VTIResultSet
|
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, usingDB2Client, usingDerbyNetClient, usingEmbedded
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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, runTest, setName, toString
public static final java.lang.Integer i1
public static final java.lang.Integer i2
public static final java.lang.Integer i3
public static final java.lang.Integer i4
public static final java.lang.Integer i5
public static final java.lang.Integer i6
public static final java.lang.Integer i7
public static final java.lang.Integer i8
public static final java.lang.Integer i9
public static final java.lang.Integer i10
public static final java.lang.Integer i11
public static final java.lang.Integer i12
public static final java.lang.Integer i13
public static final java.lang.Integer i14
public static final java.lang.Integer i15
public static final java.lang.Integer i16
public static final java.lang.Integer i17
public static final java.lang.Integer i18
public static final java.lang.Integer i19
public static final java.lang.Integer i20
public static final java.lang.String k55
public static final java.lang.String k52
public static final java.lang.String k51
public static final java.lang.String ashok
public static final java.lang.String john
public static final java.lang.String robin
public static final java.lang.String joe1
public static final java.lang.String joe2
public static final java.lang.String hamid
public static final java.lang.String truong
public static final java.lang.String larry1
public static final java.lang.String larry2
public static final java.lang.String bobbie
public static final java.lang.String roger
public static final java.lang.String jim
public static final java.lang.String dan
public static final java.lang.String sam1
public static final java.lang.String sam2
public static final java.lang.String guy
public static final java.lang.String don
public static final java.lang.String monica
public static final java.lang.String lily1
public static final java.lang.String lily2
public static final java.lang.Object[] db_dept
public static final java.lang.Object[] ofc_dept
public static final java.lang.Object[] cs_dept
public static final java.lang.Object[][] dept
public static final java.lang.Object[] ashok_emp
public static final java.lang.Object[] john_emp
public static final java.lang.Object[] robin_emp
public static final java.lang.Object[] joe1_emp
public static final java.lang.Object[] joe2_emp
public static final java.lang.Object[] hamid_emp
public static final java.lang.Object[] truong_emp
public static final java.lang.Object[] larry1_emp
public static final java.lang.Object[] larry2_emp
public static final java.lang.Object[] bobbie_emp
public static final java.lang.Object[] roger_emp
public static final java.lang.Object[] jim_emp
public static final java.lang.Object[] dan_emp
public static final java.lang.Object[] sam1_emp
public static final java.lang.Object[] sam2_emp
public static final java.lang.Object[] guy_emp
public static final java.lang.Object[] don_emp
public static final java.lang.Object[] monica_emp
public static final java.lang.Object[] lily1_emp
public static final java.lang.Object[] lily2_emp
public static final java.lang.Object[][] emp
private static final java.lang.String[] mgrs
private static final java.lang.String[] non_mgrs
public static final java.lang.String SCHEMA
public static final java.lang.String CT
public static final java.lang.String DS
public static final java.lang.String ES
public static final java.lang.String DNO
public static final java.lang.String CAS
public static final java.lang.String SETN
private java.sql.Connection c2
private java.sql.Connection c3
private static final long DERBY_DEFAULT_TIMEOUT
private static final java.lang.String SQLSTATE_NULL_INTO_NON_NULL
public ResultSetsFromPreparedStatementTest(java.lang.String name)
public static java.lang.String ref(java.lang.String table)
public static java.lang.String insertInto(java.lang.String table, int params)
table
- the name of the tableparams
- the number of params to insertprivate static java.lang.String insertFrom(java.lang.String dst, java.lang.String src)
private void createTestTable(java.lang.String name, java.lang.String signature, java.lang.String src) throws java.sql.SQLException
name
- the table to createsignature
- the signature (columns) of the new tablesrc
- the name of the source table (used to fill the new table)java.sql.SQLException
public static void apply(java.sql.PreparedStatement action, java.lang.Object[][] table) throws java.sql.SQLException
action
- the ps to executetable
- an array of parameter vectors to use for each
execution of the PreparedStatementjava.sql.SQLException
private static void assertResultSet(java.lang.String message, java.lang.Object[][] expected, java.sql.ResultSet returned) throws java.sql.SQLException
message
- a message from the callerexpected
- array of row vectorsreturned
- the resultset to verifyjava.sql.SQLException
private static void assertRow(java.lang.String message, java.lang.Object[] expected, java.sql.ResultSet returned) throws java.sql.SQLException
message
- info from the callerexpected
- the expected row vectorreturned
- the resultset to verifyjava.sql.SQLException
private static void dump(java.sql.ResultSet dumpee, java.io.PrintStream stream) throws java.sql.SQLException
dumpee
- the ResultSet to dumpstream
- the stream to dump the ResultSet tojava.sql.SQLException
private static void dumpDiff(java.lang.Object[][] expected, int fromRow, java.sql.ResultSet dumpee, boolean moreRows, java.io.PrintStream stream) throws java.sql.SQLException
If the expected value does not match the value from the RS, the expected value is printed followed by the actual value in angle brackets. The comparion starts from 'fromRow' (zero-based row index). Unmatched rows are printed with 'null' for the missing values.
dumpee must be positioned on a valid row, or moreRows must be false. Closes the RS when done.
expected
- the expected value of the RSfromRow
- row to start comparison fromdumpee
- the ResultSet to dumpmoreRows
- true if there are more rows in the RSstream
- the stream to dump the ResultSet tojava.sql.SQLException
private static void dumpObjectArray(java.sql.ResultSet dumpee, java.io.PrintStream stream) throws java.sql.SQLException
dumpee
- the ResultSet to dumpstream
- the stream to dump the ResultSet tojava.sql.SQLException
private boolean hasTableXLock(java.lang.String table) throws java.sql.SQLException
table
- name of the tablejava.sql.SQLException
protected void setUp() throws java.lang.Exception
setUp
in class junit.framework.TestCase
java.lang.Exception
protected void tearDown() throws java.lang.Exception
BaseJDBCTestCase
tearDown
in class BaseJDBCTestCase
java.lang.Exception
public static junit.framework.Test suite()
public void testSetTransactionResultSet() throws java.lang.Exception
java.lang.Exception
public void testCallStatementResultSet() throws java.lang.Exception
java.lang.Exception
public void testVTIResultSet() throws java.lang.Exception
java.lang.Exception
public void testScalarAggregateResultSet() throws java.lang.Exception
java.lang.Exception
private void testScalarAggregateResultSet(java.sql.PreparedStatement ps, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testLastIndexKeyResultSet() throws java.lang.Exception
java.lang.Exception
private void testLastIndexKeyResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testDistinctScanResultSet() throws java.lang.Exception
java.lang.Exception
private void testDistinctScanResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testDistinctScalarAggregateResultSet() throws java.lang.Exception
java.lang.Exception
private void testDistinctScalarAggregateResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testDistinctGroupedAggregateResultSet() throws java.lang.Exception
java.lang.Exception
private void testDistinctGroupedAggregateResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testGroupedAggregateResultSet() throws java.lang.Exception
java.lang.Exception
private void testGroupedAggregateResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testNestedLoopResultSet() throws java.lang.Exception
java.lang.Exception
private void testNestedLoopResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testHashTableResultSet() throws java.lang.Exception
java.lang.Exception
private void testHashTableResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testNestedLoopLeftOuterJoinResultSet() throws java.lang.Exception
java.lang.Exception
private void testNestedLoopLeftOuterJoinResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testHashLeftOuterJoinResultSet() throws java.lang.Exception
java.lang.Exception
private void testHashLeftOuterJoinResultSet(java.sql.PreparedStatement tst, java.sql.PreparedStatement del) throws java.sql.SQLException
java.sql.SQLException
public void testUpdateResultSet() throws java.lang.Exception
java.lang.Exception
public void testUpdateResultSetWithIsolation() throws java.sql.SQLException
java.sql.SQLException
public void testCurrentOfResultSet() throws java.lang.Exception
java.lang.Exception
public void testDeleteResultSet() throws java.lang.Exception
java.lang.Exception
public void testDeleteCascadeUpdateResultSet() throws java.lang.Exception
java.lang.Exception
public void testSetOpResultSet_intersect() throws java.lang.Exception
java.lang.Exception
public void testSetOpResultSet_except() throws java.lang.Exception
java.lang.Exception
public void testUnionResultSet() throws java.lang.Exception
java.lang.Exception
public void testOnceResultSet() throws java.lang.Exception
java.lang.Exception
public void testAnyResultSet() throws java.lang.Exception
java.lang.Exception
private void testGeneratedIdentity(java.lang.String dataType, java.lang.String generatedType) throws java.lang.Exception
dataType
- SMALLINT, INT, or BIGINTgeneratedType
- BY DEFAULT or ALWAYSjava.lang.Exception
- all errors passed on to JUnitpublic void testIntGeneratedByDefaultAsIdentity() throws java.lang.Exception
java.lang.Exception
public void testSmallintGeneratedByDefaultAsIdentity() throws java.lang.Exception
java.lang.Exception
public void testBigintGeneratedByDefaultAsIdentity() throws java.lang.Exception
java.lang.Exception
public void testIntGeneratedAlwaysAsIdentity() throws java.lang.Exception
java.lang.Exception
public void testSmallintGeneratedAlwaysAsIdentity() throws java.lang.Exception
java.lang.Exception
public void testBigintGeneratedAlwaysAsIdentity() throws java.lang.Exception
java.lang.Exception
public void testSetMaxRowsTable() throws java.sql.SQLException
maxRows
setting takes effect, data is obtained
from a table select.java.sql.SQLException
public void testSetMaxRowsValues() throws java.sql.SQLException
maxRows
setting takes effect, data is obtained
from a value clause.java.sql.SQLException
private void testRuntimeStatistics(java.lang.String sql, java.lang.String schema) throws java.sql.SQLException
sql
- the SQL text to prepare and executejava.sql.SQLException
public void testRuntimeStatisticsForSelect() throws java.sql.SQLException
java.sql.SQLException
public void testRuntimeStatisticsForUpdate() throws java.sql.SQLException
java.sql.SQLException
public void testRuntimeStatisticsForInsert() throws java.sql.SQLException
java.sql.SQLException
public void testRuntimeStatisticsForDelete() throws java.sql.SQLException
java.sql.SQLException
public void testRuntimeStatisticsForValues() throws java.sql.SQLException
java.sql.SQLException
public void testRuntimeStatisticsForCall() throws java.sql.SQLException
java.sql.SQLException
public void testDerby4330_JoinResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testDerby4330_UnionResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testDerby4330_SetOpResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testDerby4330_GroupedAggregateResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testDerby4330_DistinctGroupedAggregateResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testDerby4330_DistinctScalarAggregateResultSet() throws java.sql.SQLException
java.sql.SQLException
private void setTimeout(long t) throws java.sql.SQLException
java.sql.SQLException
private void createDerby4330_join_tables() throws java.sql.SQLException
java.sql.SQLException
private void createDerby4330_union_tables() throws java.sql.SQLException
java.sql.SQLException
private void setSchema(java.lang.String schema) throws java.sql.SQLException
java.sql.SQLException
public void testInsertNullIntoNonNullableColumn() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.