org.apache.derbyTesting.functionTests.tests.lang

Class SQLAuthorizationPropTest

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.SQLAuthorizationPropTest

All Implemented Interfaces:

junit.framework.Test

public class SQLAuthorizationPropTest
extends BaseJDBCTestCase

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	grantRevokeAfterSettingSQLAuthProperty() This method tests that grant/revoke is available once derby.database.sqlAuthorization property is set to true.
void	resetSQLAuthProperty() This method tests that once derby.database.sqlAuthorization property has been set to true, it cannot be reset to any other value.
protected void	setUp() Create a table to test grant/revoke statements
static junit.framework.Test	suite()
protected void	tearDown() Drop the table created during setup.
void	test_5838() Verify that you can't make the database unbootable by changing the database version.
void	testGrantRevokeWithoutSQLAuthProperty() This method tests that grant/revoke is not available if derby.database.sqlAuthorization property is not set.
private void	testPropertyReset(java.sql.CallableStatement cs, java.lang.String value) This method executes a callable statement to set the database property to a given value.

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

Constructor Detail

SQLAuthorizationPropTest

public SQLAuthorizationPropTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

setUp

protected void setUp()
              throws java.sql.SQLException

Create a table to test grant/revoke statements

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Drop the table created during setup.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testGrantRevokeWithoutSQLAuthProperty

public void testGrantRevokeWithoutSQLAuthProperty()
                                           throws java.sql.SQLException

This method tests that grant/revoke is not available if derby.database.sqlAuthorization property is not set.

Throws:

java.sql.SQLException

grantRevokeAfterSettingSQLAuthProperty

public void grantRevokeAfterSettingSQLAuthProperty()
                                            throws java.sql.SQLException

This method tests that grant/revoke is available once derby.database.sqlAuthorization property is set to true.

Throws:

java.sql.SQLException

resetSQLAuthProperty

public void resetSQLAuthProperty()
                          throws java.sql.SQLException

This method tests that once derby.database.sqlAuthorization property has been set to true, it cannot be reset to any other value. For the test to be valid, it must follow the test method which sets derby.database.sqlAuthorization property to true.

Throws:

java.sql.SQLException

testPropertyReset

private void testPropertyReset(java.sql.CallableStatement cs,
                               java.lang.String value)
                        throws java.sql.SQLException

This method executes a callable statement to set the database property to a given value. It checks that reset to any value other than "true" fails.

Parameters:

cs - CallableStatement object used to set database property

value - value of database property

Throws:

java.sql.SQLException

test_5838

public void test_5838()
               throws java.lang.Exception

Verify that you can't make the database unbootable by changing the database version. See DERBY-5838.

Throws:

java.lang.Exception