org.apache.derbyTesting.functionTests.tests.jdbc4

Class TestDbMetaData

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.jdbc4.TestDbMetaData

All Implemented Interfaces:

junit.framework.Test

public class TestDbMetaData
extends BaseJDBCTestCase

Test of database metadata for new methods in JDBC 40.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.Object[][]	ALL_FUNCTIONS Expected rows from getFunctions() when all functions match.
private static java.lang.Integer	FUNCTION_NO_TABLE_VALUE
private static JDBC.GeneratedId	GENERIC_NAME
private java.sql.DatabaseMetaData	meta

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
TestDbMetaData(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
private void	assertGetFunctionColumnsRs(java.sql.ResultSet rs) Check that the column names are as expected from getFunctionColumns().
private void	assertGetFunctionsRs(java.sql.ResultSet rs) Check that the column names are as expected from getFunctions().
private void	assertGetSchemasRs(java.sql.ResultSet rs) Check that the column names are as expected from getSchemas().
private static junit.framework.Test	baseSuite(java.lang.String name)
private static void	createFunctions(java.sql.Statement s)
private static java.lang.Object[][]	getGetFunctions() From the list of all functions extract the ones with GET in the name.
private static java.lang.Object[][]	getSysFunctions() From the list of all functions extract the ones in schemas starting with SYS.
protected void	setUp()
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testAutoCommitFailure() Test autoCommitFailureClosesAllResultSets() by checking whether a failure in auto-commit mode will close all result sets, even holdable ones.
void	testAutoCommitFailureClosesAllResultSets()
void	testFunctionNullable() Since JDBC40Translation cannot be accessed in queries in metadata.properties, the query has to use DatabaseMetaData.procedureNullable.
void	testGetClientInfoProperties()
void	testGetFunctionColumnsForDummyFunctions()
void	testGetFunctionColumnsStartingWithDUMMY()
void	testGetFunctionsContainingGET()
void	testGetFunctionsDummySchema()
void	testGetFunctionsFromSysSchemas()
void	testGetFunctionsNoSchemaNoCatalog()
void	testGetFunctionsNullNullNull()
void	testGetSchemasMatchingAPP()
void	testGetSchemasMatchingBLAH()
void	testGetSchemasNullNull()
void	testGetSchemasStartingWithSYS()
void	testGetWrapperNegative()
void	testGetWrapperPositive()
void	testIsWrapperForNegative()
void	testIsWrapperForPositive()
void	testStoredProcEscapeSyntax() Test supportsStoredFunctionsUsingCallSyntax() by checking whether calling a stored procedure using the escape syntax succeeds.
void	testSupportsStoredFunctionsUsingCallSyntax()

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

FUNCTION_NO_TABLE_VALUE

private static final java.lang.Integer FUNCTION_NO_TABLE_VALUE

meta

private java.sql.DatabaseMetaData meta

GENERIC_NAME

private static final JDBC.GeneratedId GENERIC_NAME

ALL_FUNCTIONS

private static final java.lang.Object[][] ALL_FUNCTIONS

Expected rows from getFunctions() when all functions match.

Constructor Detail

TestDbMetaData

public TestDbMetaData(java.lang.String name)

Method Detail

setUp

protected void setUp()
              throws java.sql.SQLException

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Description copied from class: BaseJDBCTestCase

Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

createFunctions

private static void createFunctions(java.sql.Statement s)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

baseSuite

private static junit.framework.Test baseSuite(java.lang.String name)

suite

public static junit.framework.Test suite()

testSupportsStoredFunctionsUsingCallSyntax

public void testSupportsStoredFunctionsUsingCallSyntax()
                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testAutoCommitFailureClosesAllResultSets

public void testAutoCommitFailureClosesAllResultSets()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetClientInfoProperties

public void testGetClientInfoProperties()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testFunctionNullable

public void testFunctionNullable()

Since JDBC40Translation cannot be accessed in queries in metadata.properties, the query has to use DatabaseMetaData.procedureNullable. Hence it is necessary to verify that that value of DatabaseMetaData.functionNullable is the same.

assertGetFunctionsRs

private void assertGetFunctionsRs(java.sql.ResultSet rs)
                           throws java.sql.SQLException

Check that the column names are as expected from getFunctions().

Throws:

java.sql.SQLException

testGetFunctionsNullNullNull

public void testGetFunctionsNullNullNull()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetFunctionsDummySchema

public void testGetFunctionsDummySchema()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetFunctionsFromSysSchemas

public void testGetFunctionsFromSysSchemas()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getSysFunctions

private static java.lang.Object[][] getSysFunctions()

From the list of all functions extract the ones in schemas starting with SYS.

getGetFunctions

private static java.lang.Object[][] getGetFunctions()

From the list of all functions extract the ones with GET in the name. This assumes this test does not create functions with GET.

testGetFunctionsContainingGET

public void testGetFunctionsContainingGET()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetFunctionsNoSchemaNoCatalog

public void testGetFunctionsNoSchemaNoCatalog()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

assertGetFunctionColumnsRs

private void assertGetFunctionColumnsRs(java.sql.ResultSet rs)
                                 throws java.sql.SQLException

Check that the column names are as expected from getFunctionColumns().

Throws:

java.sql.SQLException

testGetFunctionColumnsStartingWithDUMMY

public void testGetFunctionColumnsStartingWithDUMMY()
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetFunctionColumnsForDummyFunctions

public void testGetFunctionColumnsForDummyFunctions()
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

assertGetSchemasRs

private void assertGetSchemasRs(java.sql.ResultSet rs)
                         throws java.sql.SQLException

Check that the column names are as expected from getSchemas().

Throws:

java.sql.SQLException

testGetSchemasNullNull

public void testGetSchemasNullNull()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetSchemasStartingWithSYS

public void testGetSchemasStartingWithSYS()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetSchemasMatchingAPP

public void testGetSchemasMatchingAPP()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetSchemasMatchingBLAH

public void testGetSchemasMatchingBLAH()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testStoredProcEscapeSyntax

public void testStoredProcEscapeSyntax()
                                throws java.sql.SQLException

Test supportsStoredFunctionsUsingCallSyntax() by checking whether calling a stored procedure using the escape syntax succeeds.

Throws:

java.sql.SQLException - if an unexpected database error occurs

testAutoCommitFailure

public void testAutoCommitFailure()
                           throws java.sql.SQLException

Test autoCommitFailureClosesAllResultSets() by checking whether a failure in auto-commit mode will close all result sets, even holdable ones.

Throws:

java.sql.SQLException - if an unexpected database error occurs

testIsWrapperForPositive

public void testIsWrapperForPositive()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsWrapperForNegative

public void testIsWrapperForNegative()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetWrapperPositive

public void testGetWrapperPositive()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

testGetWrapperNegative

public void testGetWrapperNegative()