UpdateXXXTest (Apache Derby V10.10 Test Javadoc)

java.lang.Object
- junit.framework.Assert
- - junit.framework.TestCase
  - - org.apache.derbyTesting.junit.BaseTestCase
    - - org.apache.derbyTesting.junit.BaseJDBCTestCase
      - org.apache.derbyTesting.functionTests.tests.jdbcapi.UpdateXXXTest

All Implemented Interfaces:

junit.framework.Test
```
public final class UpdateXXXTest
extends BaseJDBCTestCase
```
Tests updateXXX() methods on updatable resultsets. This is done by creating a table which has n columns with different SQL types. Then there is one testcase for each updateXXX method, which calls updateXXX on all columns.

Field Summary

Fields
Modifier and Type Field and Description

private static int COLUMNS

private static java.lang.String SELECT_STMT

private static java.lang.String TABLE_NAME
- Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
  DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Fields
Modifier and Type	Field and Description
`private static int`	`COLUMNS`
`private static java.lang.String`	`SELECT_STMT`
`private static java.lang.String`	`TABLE_NAME`

Constructor Summary

Constructors
Constructor and Description

UpdateXXXTest(java.lang.String name)
Constructor

Constructors
Constructor and Description
`UpdateXXXTest(java.lang.String name)` Constructor

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private static junit.framework.TestSuite`	`baseSuite(java.lang.String name)` Base suite of tests that will run in both embedded and client.
`private void`	`checkColumnsAreNull()` Checks that the columns in the row are all SQL null.
`private void`	`checkColumnsAreUpdated()` Checks that the columns in the row are updated in the database.
`void`	`jdbc2testUpdateBigDecimal()` Tests calling update on all columns of the row.
`void`	`setUp()` The setup creates a Connection to the database, and also creates a table with one row.
`static junit.framework.Test`	`suite()` Run in both embedded and client.
`void`	`testUpdateDouble()` Tests calling updateDouble on all columns of the row.
`void`	`testUpdateFloat()` Tests calling updateFloat on all columns of the row.
`void`	`testUpdateInt()` Tests calling updateInt on all columns of the row.
`void`	`testUpdateLong()` Tests calling updateLong on all columns of the row.
`void`	`testUpdateNull()` Tests calling setNull on all columns
`void`	`testUpdateObjectWithNull()` Tests calling updateObject with a null value on all columns.
`void`	`testUpdateShort()` Tests calling updateShort on all columns of the row.
`void`	`testUpdateString()` Tests calling updateString on all columns of the row.

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, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, 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, runTest, setName, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - TABLE_NAME
```
private static final java.lang.String TABLE_NAME
```
    See Also:
    
    Constant Field Values
  - SELECT_STMT
```
private static final java.lang.String SELECT_STMT
```
    See Also:
    
    Constant Field Values
  - COLUMNS
```
private static final int COLUMNS
```
    See Also:
    
    Constant Field Values
- Constructor Detail
  - UpdateXXXTest
```
public UpdateXXXTest(java.lang.String name)
```
    Constructor
    
    Parameters:
    
    name - name of testcase. Should be the name of test method.
- Method Detail
  - suite
```
public static junit.framework.Test suite()
```
    Run in both embedded and client.
  - baseSuite
```
private static junit.framework.TestSuite baseSuite(java.lang.String name)
```
    Base suite of tests that will run in both embedded and client.
    
    Parameters:
    
    name - Name for the suite.
  - setUp
```
public void setUp()
           throws java.lang.Exception
```
    The setup creates a Connection to the database, and also creates a table with one row. Then it creates an updatable ResultSet which is positioned on the row.
    
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    java.lang.Exception - any exception will cause test to fail with error.
  - testUpdateString
```
public void testUpdateString()
                      throws java.sql.SQLException
```
    Tests calling updateString on all columns of the row.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - testUpdateInt
```
public void testUpdateInt()
                   throws java.sql.SQLException
```
    Tests calling updateInt on all columns of the row.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - testUpdateLong
```
public void testUpdateLong()
                    throws java.sql.SQLException
```
    Tests calling updateLong on all columns of the row.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - testUpdateShort
```
public void testUpdateShort()
                     throws java.sql.SQLException
```
    Tests calling updateShort on all columns of the row.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - testUpdateFloat
```
public void testUpdateFloat()
                     throws java.sql.SQLException
```
    Tests calling updateFloat on all columns of the row.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - testUpdateDouble
```
public void testUpdateDouble()
                      throws java.sql.SQLException
```
    Tests calling updateDouble on all columns of the row.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - jdbc2testUpdateBigDecimal
```
public void jdbc2testUpdateBigDecimal()
                               throws java.sql.SQLException
```
    Tests calling update on all columns of the row.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - testUpdateObjectWithNull
```
public void testUpdateObjectWithNull()
                              throws java.sql.SQLException
```
    Tests calling updateObject with a null value on all columns.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - testUpdateNull
```
public void testUpdateNull()
                    throws java.sql.SQLException
```
    Tests calling setNull on all columns
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - checkColumnsAreNull
```
private void checkColumnsAreNull()
                          throws java.sql.SQLException
```
    Checks that the columns in the row are all SQL null.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.
  - checkColumnsAreUpdated
```
private void checkColumnsAreUpdated()
                             throws java.sql.SQLException
```
    Checks that the columns in the row are updated in the database. Using a new ResultSet to do this check.
    
    Throws:
    
    java.sql.SQLException - database access error. Causes test to fail with an error.

Class UpdateXXXTest

Field Summary

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

Constructor Summary

Method Summary

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

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

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Field Detail

TABLE_NAME

SELECT_STMT

COLUMNS

Constructor Detail

UpdateXXXTest

Method Detail

suite

baseSuite

setUp

testUpdateString

testUpdateInt

testUpdateLong

testUpdateShort

testUpdateFloat

testUpdateDouble

jdbc2testUpdateBigDecimal

testUpdateObjectWithNull

testUpdateNull

checkColumnsAreNull

checkColumnsAreUpdated