org.apache.derbyTesting.functionTests.tests.lang

Class UDTTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

org.apache.derbyTesting.functionTests.tests.lang.UDTTest

All Implemented Interfaces:

junit.framework.Test

public class UDTTest
extends GeneratedColumnsHelper

Test user defined types. See DERBY-651.

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	OBJECT_EXISTS
static java.lang.String	SYNTAX_ERROR
static java.lang.String	TRIGGER_DEPENDS_ON_TYPE
static java.lang.String	VIEW_DEPENDS_ON_TYPE

Fields inherited from class org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

BAD_BEFORE_TRIGGER, BAD_CAST, BAD_FOREIGN_KEY_ACTION, CANT_ADD_IDENTITY, CANT_CONTAIN_NULLS, CANT_MODIFY_IDENTITY, CANT_OVERRIDE_GENERATION_CLAUSE, CANT_REFERENCE_GENERATED_COLUMN, CASCADED_COLUMN_DROP_WARNING, COLUMN_OUT_OF_SCOPE, CONSTRAINT_DROPPED_WARNING, CONSTRAINT_VIOLATION, DUPLICATE_CLAUSE, FORBIDDEN_DROP_TRIGGER, FORBIDDEN_ORDERING_OPERATION, FOREIGN_KEY_VIOLATION, GRANT_REVOKE_NOT_ALLOWED, ILLEGAL_ADD_DEFAULT, ILLEGAL_AGG, ILLEGAL_AGGREGATE, ILLEGAL_COMPARISON, ILLEGAL_DUPLICATE, ILLEGAL_RENAME, ILLEGAL_STORAGE, ILLEGAL_UDT_CLASS, JAVA_EXCEPTION, LACK_COLUMN_PRIV, LACK_EXECUTE_PRIV, LACK_TABLE_PRIV, LACK_USAGE_PRIV, LANG_INVALID_USE_OF_DEFAULT, LOCK_TIMEOUT, MISSING_OBJECT, NEED_EXPLICIT_DATATYPE, NON_EMPTY_SCHEMA, NONEXISTENT_OBJECT, NOT_NULL_NEEDS_DATATYPE, NOT_NULL_VIOLATION, OBJECT_DOES_NOT_EXIST, OPERATION_FORBIDDEN, REDUNDANT_CLAUSE, ROUTINE_CANT_ISSUE_SQL, ROUTINE_DEPENDS_ON_TYPE, STRING_TRUNCATION, TABLE_DEPENDS_ON_TYPE, TOO_MUCH_CONTENTION, TRIGGER_DROPPED_WARNING, UNSTABLE_RESULTS, VIEW_DEPENDENCY

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
UDTTest(java.lang.String name) Create a new instance.

Method Summary

Modifier and Type	Method and Description
static void	changeIntArray(int newSize, IntArray[] array)
private void	checkPMD(java.sql.Connection conn, java.lang.String query, java.lang.String expectedClassName, int expectedJDBCType, java.lang.String expectedSQLTypeName, int expectedPrecision, int expectedScale) Check the ParameterMetaData for a statement whose first parameter is a UDT.
private void	checkRSMD(java.sql.Connection conn, java.lang.String query, java.lang.String expectedClassName, int expectedDisplaySize, int expectedJDBCType, java.lang.String expectedSQLTypeName, int expectedPrecision, int expectedScale) Check the ResultSetMetaData for a query whose first column is a UDT.
private int	countTableDependencies(java.sql.Connection conn, java.lang.String tableName) Get the number of dependencies that a table has
private int	getScalarInteger(java.sql.PreparedStatement ps) Get a scalar integer result from a query
static java.sql.ResultSet	hashmapReader()
private void	makeGoodTypes(java.sql.Connection conn)
static java.util.HashMap	makeHashMap()
static java.lang.Number	makeNumber(int arg)
static void	oneArgPriceProc(Price price1)
static java.util.HashMap	putValue(java.util.HashMap map, java.lang.String key, java.lang.String value)
static junit.framework.Test	suite() Construct top level suite in this JUnit test
void	test_01_basicSyntax() Basic syntax.
void	test_02_basicColumnRetvalParam() Basic column, return value, and parameter support.
void	test_03_addDropColumn() Adding and dropping udt columns.
void	test_04_dropTable() Dropping a whole table which has udt columns.
void	test_05_viewDependencies() Dependencies of views on UDTs.
void	test_06_casts() Casting to UDTs.
void	test_07_routineDependencies() Dependencies of routines on UDTs.
void	test_08_triggerDependencies() Dependencies of triggers on UDTs.
void	test_09_resultSetMetaData() Check result set metadata for UDT columns.
void	test_10_parameterMetaData() Check parameter metadata for UDT parameters.
void	test_11_tableFunctionColumns() Verify that table functions can have UDT columns.
void	test_12_largeUDTs() Verify that you can store large objects in UDT columns.
void	test_13_sqlData() Verify that implementing the SQLData interface does not make an object storeable.
void	test_14_systemClasses() Verify that you can't bind UDTs to the classes which back the system types.
void	test_15_ordering() Verify that UDTs have no ordering.
void	test_16_casts() Verify implicit and explicit casts.
void	test_17_outputParameters() Verify that you can use UDTs as output parameters in database procedures.
static void	twoArgPriceProc(Price price1, Price price2)
private void	verifyDropRestrictions(java.sql.Connection conn, java.lang.String createTypeStatement, java.lang.String dropTypeStatement, java.lang.String createObjectStatement, java.lang.String dropObjectStatement, java.lang.String badDropSQLState) Verify that a type can't be dropped if it is used by a schema object.
private int	vetDatatypeCount(java.sql.Connection conn)

Methods inherited from class org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

assertColumnTypes, assertDeterministic, assertResults, assertResults, chattyPrepare, chattyPrepareCall, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, expectExecutionWarning, expectExecutionWarnings, expectInsertRowError, expectUpdateRowError, fill, goodStatement, verifyRestrictedDrop, verifyRevokePrivilege

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, setUp, toString

Methods inherited from class java.lang.Object

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

Field Detail

OBJECT_EXISTS

public static final java.lang.String OBJECT_EXISTS

See Also:

Constant Field Values

SYNTAX_ERROR

public static final java.lang.String SYNTAX_ERROR

See Also:

Constant Field Values

VIEW_DEPENDS_ON_TYPE

public static final java.lang.String VIEW_DEPENDS_ON_TYPE

See Also:

Constant Field Values

TRIGGER_DEPENDS_ON_TYPE

public static final java.lang.String TRIGGER_DEPENDS_ON_TYPE

See Also:

Constant Field Values

Constructor Detail

UDTTest

public UDTTest(java.lang.String name)

Create a new instance.

Method Detail

suite

public static junit.framework.Test suite()

Construct top level suite in this JUnit test

test_01_basicSyntax

public void test_01_basicSyntax()
                         throws java.lang.Exception

Basic syntax.

Throws:

java.lang.Exception

makeGoodTypes

private void makeGoodTypes(java.sql.Connection conn)
                    throws java.lang.Exception

Throws:

java.lang.Exception

test_02_basicColumnRetvalParam

public void test_02_basicColumnRetvalParam()
                                    throws java.lang.Exception

Basic column, return value, and parameter support.

Throws:

java.lang.Exception

test_03_addDropColumn

public void test_03_addDropColumn()
                           throws java.lang.Exception

Adding and dropping udt columns.

Throws:

java.lang.Exception

test_04_dropTable

public void test_04_dropTable()
                       throws java.lang.Exception

Dropping a whole table which has udt columns.

Throws:

java.lang.Exception

test_05_viewDependencies

public void test_05_viewDependencies()
                              throws java.lang.Exception

Dependencies of views on UDTs.

Throws:

java.lang.Exception

test_06_casts

public void test_06_casts()
                   throws java.lang.Exception

Casting to UDTs.

Throws:

java.lang.Exception

test_07_routineDependencies

public void test_07_routineDependencies()
                                 throws java.lang.Exception

Dependencies of routines on UDTs.

Throws:

java.lang.Exception

test_08_triggerDependencies

public void test_08_triggerDependencies()
                                 throws java.lang.Exception

Dependencies of triggers on UDTs.

Throws:

java.lang.Exception

test_09_resultSetMetaData

public void test_09_resultSetMetaData()
                               throws java.lang.Exception

Check result set metadata for UDT columns.

Throws:

java.lang.Exception

test_10_parameterMetaData

public void test_10_parameterMetaData()
                               throws java.lang.Exception

Check parameter metadata for UDT parameters.

Throws:

java.lang.Exception

test_11_tableFunctionColumns

public void test_11_tableFunctionColumns()
                                  throws java.lang.Exception

Verify that table functions can have UDT columns.

Throws:

java.lang.Exception

test_12_largeUDTs

public void test_12_largeUDTs()
                       throws java.lang.Exception

Verify that you can store large objects in UDT columns.

Throws:

java.lang.Exception

test_13_sqlData

public void test_13_sqlData()
                     throws java.lang.Exception

Verify that implementing the SQLData interface does not make an object storeable.

Throws:

java.lang.Exception

test_14_systemClasses

public void test_14_systemClasses()
                           throws java.lang.Exception

Verify that you can't bind UDTs to the classes which back the system types.

Throws:

java.lang.Exception

vetDatatypeCount

private int vetDatatypeCount(java.sql.Connection conn)
                      throws java.lang.Exception

Throws:

java.lang.Exception

test_15_ordering

public void test_15_ordering()
                      throws java.lang.Exception

Verify that UDTs have no ordering.

Throws:

java.lang.Exception

test_16_casts

public void test_16_casts()
                   throws java.lang.Exception

Verify implicit and explicit casts.

Throws:

java.lang.Exception

test_17_outputParameters

public void test_17_outputParameters()
                              throws java.lang.Exception

Verify that you can use UDTs as output parameters in database procedures.

Throws:

java.lang.Exception

oneArgPriceProc

public static void oneArgPriceProc(Price price1)

twoArgPriceProc

public static void twoArgPriceProc(Price price1,
                                   Price price2)

changeIntArray

public static void changeIntArray(int newSize,
                                  IntArray[] array)

makeHashMap

public static java.util.HashMap makeHashMap()

putValue

public static java.util.HashMap putValue(java.util.HashMap map,
                                         java.lang.String key,
                                         java.lang.String value)

hashmapReader

public static java.sql.ResultSet hashmapReader()
                                        throws java.lang.Exception

Throws:

java.lang.Exception

makeNumber

public static java.lang.Number makeNumber(int arg)

verifyDropRestrictions

private void verifyDropRestrictions(java.sql.Connection conn,
                                    java.lang.String createTypeStatement,
                                    java.lang.String dropTypeStatement,
                                    java.lang.String createObjectStatement,
                                    java.lang.String dropObjectStatement,
                                    java.lang.String badDropSQLState)
                             throws java.lang.Exception

Verify that a type can't be dropped if it is used by a schema object.

Throws:

java.lang.Exception

countTableDependencies

private int countTableDependencies(java.sql.Connection conn,
                                   java.lang.String tableName)
                            throws java.lang.Exception

Get the number of dependencies that a table has

Throws:

java.lang.Exception

getScalarInteger

private int getScalarInteger(java.sql.PreparedStatement ps)
                      throws java.lang.Exception

Get a scalar integer result from a query

Throws:

java.lang.Exception

checkRSMD

private void checkRSMD(java.sql.Connection conn,
                       java.lang.String query,
                       java.lang.String expectedClassName,
                       int expectedDisplaySize,
                       int expectedJDBCType,
                       java.lang.String expectedSQLTypeName,
                       int expectedPrecision,
                       int expectedScale)
                throws java.lang.Exception

Check the ResultSetMetaData for a query whose first column is a UDT.

Throws:

java.lang.Exception

checkPMD

private void checkPMD(java.sql.Connection conn,
                      java.lang.String query,
                      java.lang.String expectedClassName,
                      int expectedJDBCType,
                      java.lang.String expectedSQLTypeName,
                      int expectedPrecision,
                      int expectedScale)
               throws java.lang.Exception

Check the ParameterMetaData for a statement whose first parameter is a UDT.

Throws:

java.lang.Exception