public class UpdatableResultSetTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String[] |
allSQLTypes |
private static java.lang.String[] |
allUpdateXXXNames |
private static java.lang.String[] |
ColumnNames |
private static java.lang.String[][] |
SQLData |
static java.lang.String[][] |
updateObjectRulesTableForNetworkClient |
static java.lang.String[][] |
updateXXXRulesTableForEmbedded |
static java.lang.String[][] |
updateXXXRulesTableForNetworkClient |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
UpdatableResultSetTest(java.lang.String name)
Creates a new instance of UpdatableResultSetTest
|
Modifier and Type | Method and Description |
---|---|
private static BaseTestSuite |
baseSuite(java.lang.String name) |
private void |
createAllDatatypesTable() |
private void |
createSelfReferencingTable() |
private void |
createTable0WithTrigger() |
private void |
createTable1WithTrigger() |
private void |
createTableT1() |
private void |
createTableT2() |
private void |
createTableT3() |
private void |
createTableT4() |
private void |
createTableT5() |
private void |
createTableWithPrimaryKey() |
private void |
resetData() |
private void |
runTestUpdateObjectWithAllDatatypes(java.sql.PreparedStatement pstmt,
java.sql.PreparedStatement pstmt1,
int sqlType,
int updateXXXName) |
private void |
runTestUpdateXXXAllDataTypesInsertRow(java.sql.PreparedStatement pstmt,
java.sql.PreparedStatement pstmt1,
int sqlType,
int updateXXXName) |
private void |
runTestUpdateXXXWithAllDatatypes(java.sql.PreparedStatement pstmt,
java.sql.PreparedStatement pstmt1,
int sqlType,
int updateXXXName) |
protected void |
setUp() |
static junit.framework.Test |
suite() |
void |
testCallableStatementWithUpdatableResultSet()
Positive test - use callable statement with concur updatable status
|
void |
testCancelRowUpdatesAndDeleteRow()
Positive test - after updateXXX, try cancelRowUpdates and then
deleteRow
|
void |
testCancelRowUpdatesOnReadOnlyRS()
Positive test - Test cancelRowUpdates method as the first updatable
ResultSet api on a read-only resultset
|
void |
testCancelRowUpdatesWithoutUpdateXXX()
Positive test - issue cancelRowUpdates without any updateXXX
|
void |
testCaseSensitiveTableAndColumnName()
Positive test - case sensitive table and column names
|
void |
testDeleteRowAndRollbackWithTriggers()
Positive test - Do deleteRow within a transaction and then rollback the
transaction
|
void |
testDeleteRowOnTempTable()
Positive test - delete using updatable resultset api from a temporary
table
|
void |
testDeleteRowSelfReferential()
Positive test - make sure self referential delete cascade works when
deleteRow is issued
|
void |
testDeleteRowWithCorrelationForColumnName()
Positive Test9b - using correlation name for updatable columns is not
allowed.
|
void |
testDeleteRowWithCorrelationForTableName()
Positive test - using correlation name for the table in the select sql
|
void |
testDeleteRowWithDeleteTrigger()
Positive test - make sure delete trigger gets fired when deleteRow is
issued
|
void |
testDeleteRowWithPreparedStatement()
Positive test - use prepared statement with concur updatable status to
test deleteRow
|
void |
testDeleteRowWithSetCursorName()
Positive test - change the name of the statement when the resultset is
open and see if deleteRow still works
This test works in embedded mode since Derby can handle the change in the
name of the statement with an open resultset
But it fails under Network Server mode because JCC and Derby Net Client
do not allow statement name change when there an open resultset against
it
|
void |
testDeleteRowWithTriggerChangingRS()
Positive test - Another test case for delete trigger
|
void |
testDropTableWithUpatableResultSet()
Negative test - With autocommit on, attempt to drop a table when there
is an open updatable resultset on it
|
void |
testDropTableWithUpdatableCursorOnIt()
Positive test - With autocommit off, attempt to drop a table when there
is an open updatable resultset on it
|
void |
testForeignKeyConstraintFailureOnDeleteRow()
Negative test - foreign key constraint failure will cause deleteRow
to fail
|
void |
testForeignKeyConstraintFailureOnUpdateRow()
Negative test - foreign key constraint failure will cause updateRow
to fail
|
void |
testInsertRow()
Positive test - moveToInsertRow, insertRow, getXXX and moveToCurrentRow
|
void |
testInsertRowAfterClose()
Negative test - test insertRow on closed resultset
|
void |
testInsertRowFromCurrentRow()
Negative test - Try to insertRow from current row
|
void |
testInsertRowFromDifferentPositions()
Positive test - try insertRow from different positions
|
void |
testInsertRowReadOnlyRS()
Negative test - insertRow and read-only RS
|
void |
testInsertRowWithDefaultValue()
Positive test - try to insert without updating all columns.
|
void |
testInsertRowWithNullColumn()
Positive test - InsertRow leaving a nullable columns = NULL
|
void |
testMultipleUpdateXXXAndUpdateRow()
Positive test - issue multiple updateXXXs and then a updateRow
|
void |
testPositionedDeleteOnUpdatableResultSet()
Positive test - use updatable resultset to do postitioned delete
|
void |
testPositionedUpdateOnUpdatableResultSet()
Positive test - updatable resultset to do positioned update
|
void |
testResultSetNotPositionedAfterDeleteRow()
Positive test - request updatable resultset for forward only type
resultset
|
void |
testResultSetNotPositionedAfterUpdateRow()
Positive test - request updatable resultset for forward only type
resultset
|
void |
testResultSetPositionedBeforeNextAfterDeleteRow()
Positive test - After deleteRow, resultset is positioned before the
next row
|
void |
testRollbackWithAutoCommit()
Positive test - Rollback with AutoCommit on
|
void |
testRowDeleted()
Positive test - For Forward Only resultsets, DatabaseMetaData will
return false for ownDeletesAreVisible and deletesAreDetected
This is because, after deleteRow, we position the ResultSet before the
next row.
|
void |
testRowUpdated()
Positive test - For Forward Only resultsets, DatabaseMetaData will return
false for ownUpdatesAreVisible and updatesAreDetected
This is because, after updateRow, we position the ResultSet before the
next row
|
void |
testScrollSensitiveResultSet()
Negative test - request for scroll sensitive updatable resultset will
give an updatable scroll insensitive resultset
|
void |
testSetFetchSizeOnUpdatableResultSet()
Positive test - setting the fetch size to > 1 will be ignored by
updatable resultset.
|
void |
testTableAndColumnNameWithSpaces()
Positive test - table and column names with spaces in middle and end
|
void |
testTwoResultSetsDeletingSameRow()
Positive test - 2 updatable resultsets going against the same table
|
void |
testUpdatableResultsetNoColumnInColumnList()
Positive Test2 - even if no columns from table specified in the column
list, we should be able to get updatable resultset
|
void |
testUpdatableResultSetOnJoin()
Negative test - attempt to open updatable resultset when there is
join in the select query should fail
|
void |
testUpdatableResultSetOnSysTable()
Negative test - try updatable resultset on system table
|
void |
testUpdatableResultSetOnView()
Negative test - try updatable resultset on a view
|
void |
testUpdatableResultSetWithoutSelectingPrimaryKey()
Positive test - donot have to select primary key to get an updatable
resultset
|
void |
testUpdateDeleteRowNotOnRow()
Negative test - attempt to deleteRow and updateRow on updatable resultset
when the resultset is not positioned on a row
|
void |
testUpdateDeleteRowOnClosedResultSet()
Negative test - attempt deleteRow and updateRow on updatable resultset
after closing the resultset
|
void |
testUpdateDeleteRowOnReadOnlyResultSet()
Negative test - request a read only resultset and attempt deleteRow and
updateRow on it
|
void |
testUpdateDeleteRowOnReadOnlyResultSetWithForUpdate()
Negative Test - request a read only resultset and send a sql with FOR
UPDATE clause and attempt deleteRow/updateRow on it
|
void |
testUpdateDeleteRowOnReadOnlyResultSetWithoutForUpdate()
Negative Test - request resultset with no FOR UPDATE clause and
CONCUR_READ_ONLY
|
void |
testUpdateDeleteRowOnUpdatableResultSetWithForReadOnly()
Negative Test - request updatable resultset for sql with FOR READ ONLY
clause
|
void |
testUpdateObjectWithAllDatatypes()
Positive test - Test updateObject method
|
void |
testUpdateRowAndRollbackWithTriggers()
Positive test - Do updateRow within a transaction and then rollback the
transaction
|
void |
testUpdateRowDeleteRowDoNotCommit()
Positive test - in autocommit mode, check that updateRow and deleteRow
does not commit
|
void |
testUpdateRowDeleteRowFromInsertRow()
Negative test - run updateRow and deleterow when positioned at insertRow
|
void |
testUpdateRowOnReadOnlyRS()
Positive test - Test updateRow method as the first updatable ResultSet
api on a read-only resultset
|
void |
testUpdateRowOnTempTable()
Positive test - update using updatable resultset api from a temporary
table
|
void |
testUpdateRowSelfReferential()
Positive test - make sure self referential update restrict works when
updateRow is issued
|
void |
testUpdateRowWithCorrelationOnTableAndColumn()
Positive test - try to get an updatable resultset using correlation name
for a readonly column
|
void |
testUpdateRowWithoutUpdateXXX()
Positive test - issue updateRow without any updateXXX will not move
the resultset position
|
void |
testUpdateRowWithSetCursorName()
Positive test - change the name of the statement when the resultset is
open and see if updateRow still works
This test works in embedded mode since Derby can handle the change in the
name of the statement with an open resultset
But it fails under Network Server mode because JCC and Derby Net Client
do not allow statement name change when there an open resultset against
it
|
void |
testUpdateRowWithTableAndColumnAlias_d1773()
Tests for DERBY-1773, involving both explicit and implicit
FOR UPDATE clauses, as well as various styles of specifying
correlation names.
|
void |
testUpdateRowWithTriggerChangingRS()
Positive test - Another test case for update trigger
|
void |
testUpdateRowWithUpdateTrigger()
Positive test - make sure that update trigger gets fired when updateRow
is issue
|
void |
testUpdateTableDifferentSchema()
Positive test - try to update a table from another schema
|
void |
testUpdateXXXAllDataTypesInsertRow()
Positive test - Test all updateXXX methods on all the supported sql
datatypes
|
void |
testUpdateXXXAndDeleteRow()
Positive test - issue updateXXX and then deleteRow
|
void |
testUpdateXXXAndMoveNext()
Positive test - issue updateXXXs and then move off the row, the changes
should be ignored
|
void |
testUpdateXXXNotForUpdateColumns()
Positive test - call updateXXX methods on column that is not in for
update columns list
|
void |
testUpdateXXXOnColumnNotFromTable()
Negative test - Can't call updateXXX methods on columns that do not
correspond to a column in the table
|
void |
testUpdateXXXOnOutOfRangeColumn()
Negative test - Call updateXXX method on out of the range column
|
void |
testUpdateXXXOnReadOnlyColumn()
Positive test - try to updateXXX on a readonly column.
|
void |
testUpdateXXXOnReadOnlyColumnWithCorrelationName()
Positive test - try to updateXXX on a readonly column with correlation
name.
|
void |
testUpdateXXXOnReadOnlyRS()
Positive test - Test updateXXX methods as the first updatable ResultSet
api on a read-only resultset
|
void |
testUpdateXXXOnTableColumn()
Positive test - call updateXXX methods on only columns that correspond
to a column in the table
|
void |
testUpdateXXXWithAllDatatypes()
Positive test - Test all updateXXX(excluding updateObject) methods on
all the supported sql datatypes
|
void |
testUpdateXXXWithCancelRowUpdates()
Positive test - Test cancelRowUpdates after updateXXX methods on all
the supported sql datatypes
|
void |
testUpdateXXXWithPreparedStatement()
Positive test - use prepared statement with concur updatable status to
test updateXXX
|
private void |
verifyData(int sqlType,
int updateXXXName) |
void |
xTestInsertRowAfterCommit()
Positive and negative tests - Commit while on insertRow
|
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, tearDown, 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
private static java.lang.String[] allUpdateXXXNames
private static java.lang.String[] allSQLTypes
private static java.lang.String[] ColumnNames
private static java.lang.String[][] SQLData
public static final java.lang.String[][] updateXXXRulesTableForEmbedded
public static final java.lang.String[][] updateXXXRulesTableForNetworkClient
public static final java.lang.String[][] updateObjectRulesTableForNetworkClient
public UpdatableResultSetTest(java.lang.String name)
public static junit.framework.Test suite()
private static BaseTestSuite baseSuite(java.lang.String name)
protected void setUp() throws java.sql.SQLException
setUp
in class junit.framework.TestCase
java.sql.SQLException
public void testScrollSensitiveResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateDeleteRowOnReadOnlyResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateDeleteRowOnReadOnlyResultSetWithForUpdate() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateDeleteRowOnReadOnlyResultSetWithoutForUpdate() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateDeleteRowOnUpdatableResultSetWithForReadOnly() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateDeleteRowNotOnRow() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateDeleteRowOnClosedResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testUpdatableResultSetOnSysTable() throws java.sql.SQLException
java.sql.SQLException
public void testUpdatableResultSetOnView() throws java.sql.SQLException
java.sql.SQLException
public void testUpdatableResultSetOnJoin() throws java.sql.SQLException
java.sql.SQLException
public void testDropTableWithUpatableResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testForeignKeyConstraintFailureOnDeleteRow() throws java.sql.SQLException
java.sql.SQLException
public void testForeignKeyConstraintFailureOnUpdateRow() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXOnColumnNotFromTable() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXOnOutOfRangeColumn() throws java.sql.SQLException
java.sql.SQLException
public void testResultSetNotPositionedAfterDeleteRow() throws java.sql.SQLException
java.sql.SQLException
public void testResultSetNotPositionedAfterUpdateRow() throws java.sql.SQLException
java.sql.SQLException
public void testPositionedDeleteOnUpdatableResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testPositionedUpdateOnUpdatableResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testUpdatableResultsetNoColumnInColumnList() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowWithPreparedStatement() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXWithPreparedStatement() throws java.sql.SQLException
java.sql.SQLException
public void testCallableStatementWithUpdatableResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testUpdatableResultSetWithoutSelectingPrimaryKey() throws java.sql.SQLException
java.sql.SQLException
public void testRowDeleted() throws java.sql.SQLException
java.sql.SQLException
public void testRowUpdated() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowOnTempTable() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowOnTempTable() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowWithSetCursorName() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowWithSetCursorName() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowWithCorrelationForTableName() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowWithCorrelationForColumnName() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXOnReadOnlyColumn() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowWithCorrelationOnTableAndColumn() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXOnReadOnlyColumnWithCorrelationName() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowWithTableAndColumnAlias_d1773() throws java.sql.SQLException
java.sql.SQLException
public void testTwoResultSetsDeletingSameRow() throws java.sql.SQLException
java.sql.SQLException
public void testSetFetchSizeOnUpdatableResultSet() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowWithDeleteTrigger() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowWithUpdateTrigger() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowWithTriggerChangingRS() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowWithTriggerChangingRS() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowSelfReferential() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowSelfReferential() throws java.sql.SQLException
java.sql.SQLException
public void testDropTableWithUpdatableCursorOnIt() throws java.sql.SQLException
java.sql.SQLException
public void testDeleteRowAndRollbackWithTriggers() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowAndRollbackWithTriggers() throws java.sql.SQLException
java.sql.SQLException
public void testResultSetPositionedBeforeNextAfterDeleteRow() throws java.sql.SQLException
java.sql.SQLException
public void testCancelRowUpdatesOnReadOnlyRS() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowOnReadOnlyRS() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXOnReadOnlyRS() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXWithAllDatatypes() throws java.sql.SQLException, java.lang.IllegalArgumentException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.lang.IllegalArgumentException
java.io.UnsupportedEncodingException
private void runTestUpdateXXXWithAllDatatypes(java.sql.PreparedStatement pstmt, java.sql.PreparedStatement pstmt1, int sqlType, int updateXXXName) throws java.sql.SQLException, java.lang.IllegalArgumentException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.lang.IllegalArgumentException
java.io.UnsupportedEncodingException
public void testUpdateObjectWithAllDatatypes() throws java.sql.SQLException, java.lang.IllegalArgumentException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.lang.IllegalArgumentException
java.io.UnsupportedEncodingException
private void runTestUpdateObjectWithAllDatatypes(java.sql.PreparedStatement pstmt, java.sql.PreparedStatement pstmt1, int sqlType, int updateXXXName) throws java.sql.SQLException, java.lang.IllegalArgumentException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.lang.IllegalArgumentException
java.io.UnsupportedEncodingException
public void testUpdateXXXWithCancelRowUpdates() throws java.sql.SQLException
java.sql.SQLException
public void testCancelRowUpdatesAndDeleteRow() throws java.sql.SQLException
java.sql.SQLException
public void testCancelRowUpdatesWithoutUpdateXXX() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowWithoutUpdateXXX() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXAndDeleteRow() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXAndMoveNext() throws java.sql.SQLException
java.sql.SQLException
public void testMultipleUpdateXXXAndUpdateRow() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXOnTableColumn() throws java.sql.SQLException
java.sql.SQLException
public void testCaseSensitiveTableAndColumnName() throws java.sql.SQLException
java.sql.SQLException
public void testTableAndColumnNameWithSpaces() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXNotForUpdateColumns() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateTableDifferentSchema() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowDeleteRowDoNotCommit() throws java.sql.SQLException
java.sql.SQLException
public void testInsertRow() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateRowDeleteRowFromInsertRow() throws java.sql.SQLException
java.sql.SQLException
public void testInsertRowFromCurrentRow() throws java.sql.SQLException
java.sql.SQLException
public void testInsertRowFromDifferentPositions() throws java.sql.SQLException
java.sql.SQLException
public void testInsertRowWithNullColumn() throws java.sql.SQLException
java.sql.SQLException
public void xTestInsertRowAfterCommit() throws java.sql.SQLException
java.sql.SQLException
public void testInsertRowAfterClose() throws java.sql.SQLException
java.sql.SQLException
public void testInsertRowWithDefaultValue() throws java.sql.SQLException
java.sql.SQLException
public void testRollbackWithAutoCommit() throws java.sql.SQLException
java.sql.SQLException
public void testInsertRowReadOnlyRS() throws java.sql.SQLException
java.sql.SQLException
public void testUpdateXXXAllDataTypesInsertRow() throws java.sql.SQLException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.io.UnsupportedEncodingException
private void runTestUpdateXXXAllDataTypesInsertRow(java.sql.PreparedStatement pstmt, java.sql.PreparedStatement pstmt1, int sqlType, int updateXXXName) throws java.sql.SQLException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.io.UnsupportedEncodingException
private void createTableT1() throws java.sql.SQLException
java.sql.SQLException
private void createTableT2() throws java.sql.SQLException
java.sql.SQLException
private void createTableT3() throws java.sql.SQLException
java.sql.SQLException
private void createTableT4() throws java.sql.SQLException
java.sql.SQLException
private void createTableT5() throws java.sql.SQLException
java.sql.SQLException
private void createTableWithPrimaryKey() throws java.sql.SQLException
java.sql.SQLException
private void createTable0WithTrigger() throws java.sql.SQLException
java.sql.SQLException
private void createTable1WithTrigger() throws java.sql.SQLException
java.sql.SQLException
private void createSelfReferencingTable() throws java.sql.SQLException
java.sql.SQLException
private void createAllDatatypesTable() throws java.sql.SQLException
java.sql.SQLException
private void verifyData(int sqlType, int updateXXXName) throws java.sql.SQLException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.io.UnsupportedEncodingException
private void resetData() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.