DatabaseClassLoadingTest (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.lang.DatabaseClassLoadingTest

All Implemented Interfaces:

junit.framework.Test
```
public class DatabaseClassLoadingTest
extends BaseJDBCTestCase
```
Test database class loading, executing routines from the installed jars including accessing resources. Replacing jars and handling signed jars is also tested.

Field Summary
- Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
  DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors
Constructor and Description

DatabaseClassLoadingTest(java.lang.String name)

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

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`(package private) static void`	`addEntries(java.util.zip.ZipOutputStream zos, java.io.File dir, java.lang.String dbName, int old)`
`private static void`	`addFile(java.util.zip.ZipOutputStream zos, java.io.File f, java.lang.String dbName, int old)`
`private void`	`checkCorrectLoader(java.lang.String className, java.sql.PreparedStatement ps1, java.sql.PreparedStatement ps2, java.sql.PreparedStatement ps3)`
`private void`	`checkLoading(java.lang.String order)` Run a number of tests to ensure classes are loaded from the correct class loader.
`private static void`	`createArchive(java.lang.String jarName, java.io.File dbDir, java.lang.String dbName)` jarname - jarname to use path - path to database dbname - database name in archive
`private void`	`derby2035Workaround()`
`private static void`	`getResourceTests(java.sql.Connection conn)`
`private void`	`installJar(java.lang.String resource, java.lang.String jarName)`
`private void`	`loadJavaClass(java.lang.String method, java.lang.String expectedSQLState)` Test loading classes in the java. and javax. namespaces from a jar, it should be disallowed or be ignored.
`private static void`	`readOnlyTest(javax.sql.DataSource ds)` Run an number of statements against a jar'ed database to ensure it is read-only and that class loading works from jar files embedded in jar'ed up databases.
`private void`	`removeJar(java.lang.String jarName)`
`private void`	`replaceJar(java.lang.String resource, java.lang.String jarName)`
`private static void`	`setContextClassLoader(java.net.URL url)`
`private void`	`setDBClasspath(java.lang.String cp)`
`private static void`	`signersTests(java.sql.Connection conn)`
`static junit.framework.Test`	`suite()` Run the tests only in embedded since this is testing server side behaviour.
`void`	`test_5352()` Test that restricted table functions can be invoked from inside jar files stored in the database.
`void`	`testAddContact()` Test that a new connection successfully sees the changes.
`void`	`testAlterTable()` Alter the table to add a column, the add contact procedure should still work.
`void`	`testClassLoadOrdering()` Test ordering of class loading.
`void`	`testClassPathRollback()` check the roll back of class loading.
`void`	`testCreateDatabaseJar()` Create a Jar of the current database.
`void`	`testDatabaseInClasspath()`
`void`	`testDatabaseInJar()` Test the jar'ed up database created by testCreateDatabaseJar accessing the database using the jar(path to archive)db form of database name.
`void`	`testGetResource()`
`void`	`testHackedJarReplacedClass()` Replace the signed jar with a hacked jar. emc.class modified to diable valid e-mail address check but using same signatures within jar.
`void`	`testIndirectLoading()` Test that loading of Derby's internal classes from an installed jar file is disallowed.
`void`	`testInvalidJar()` replace with a hacked jar file, emc.class modified to be an invalid class (no signing on this jar).
`void`	`testJarHandling()` Test the sqlj procedures without setting any database classpath.
`void`	`testLoadDerbyClassIndirectly()` Load a org.apache.derby class directly (ie. through a direct procedure call) from the jar file.
`void`	`testLoadJavaClassDirectly()` Load a java.sql class directly (ie. through a direct procedure call) from the jar file.
`void`	`testLoadJavaClassDirectly2()` Load a java.derby99 class directly (ie. through a direct procedure call) from the jar file.
`void`	`testLoadJavaClassDirectly3()` Load a javax.derby99 class directly (ie. through a direct procedure call) from the jar file.
`void`	`testLoadJavaClassIndirectly()` Load a java.sql class indirectly (ie. through a valid class in the installed jar file) from the jar file.
`void`	`testRemoveJar()`
`void`	`testReplacedClass()` Change of class due to testReplaceJar that changes the application to run checks on the e-mail to ensure it is valid (in this case by seeing if it simply includes 'spam' in the title).
`void`	`testReplaceJar()` Replace the jar to later test the prepare from a different connection picks up the new version.
`void`	`testSecondJar()` now add another jar in to test two jars and a quoted identifer for the jar names.
`void`	`testSetClasspath()` Set the classpath to include the MAIL_APP jar.
`void`	`testSignedJar()` Test to see if the jar signatures can be obtained from the jar file.
`void`	`testTableFunctionInJar()` Test that table functions can be invoked from inside jar files stored in the database.
`void`	`testUDAInJar()` Test that user-defined aggregates can be invoked from inside jar files stored in the database.
`void`	`testWithNoClasspath()` Install the jar, but don't set the classpath.
`void`	`testWithNoInstalledJars()` Test the routines fail before the jars that contain their code have been installed and/or set in the classpath.

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

- Constructor Detail
  - DatabaseClassLoadingTest
```
public DatabaseClassLoadingTest(java.lang.String name)
```
- Method Detail
  - suite
```
public static junit.framework.Test suite()
```
    Run the tests only in embedded since this is testing server side behaviour. Due to DERBY-537 and DERBY-2040 most of the tests are run without a security manager. Ordering is important here so the fixtures are added explicitly.
  - testWithNoInstalledJars
```
public void testWithNoInstalledJars()
                             throws java.sql.SQLException
```
    Test the routines fail before the jars that contain their code have been installed and/or set in the classpath.
    
    Throws:
    
    java.sql.SQLException
  - testJarHandling
```
public void testJarHandling()
                     throws java.sql.SQLException,
                            java.net.MalformedURLException
```
    Test the sqlj procedures without setting any database classpath. This allows testing with the security manager without hitting the bugs that exist when the database class path is set with the security manager.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testWithNoClasspath
```
public void testWithNoClasspath()
                         throws java.sql.SQLException,
                                java.net.MalformedURLException
```
    Install the jar, but don't set the classpath.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testSetClasspath
```
public void testSetClasspath()
                      throws java.sql.SQLException
```
    Set the classpath to include the MAIL_APP jar.
    
    Throws:
    
    java.sql.SQLException
  - testAddContact
```
public void testAddContact()
                    throws java.sql.SQLException
```
    Test that a new connection successfully sees the changes.
    
    Throws:
    
    java.sql.SQLException
  - testGetResource
```
public void testGetResource()
                     throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - getResourceTests
```
private static void getResourceTests(java.sql.Connection conn)
                              throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testAlterTable
```
public void testAlterTable()
                    throws java.sql.SQLException
```
    Alter the table to add a column, the add contact procedure should still work.
    
    Throws:
    
    java.sql.SQLException
  - testClassPathRollback
```
public void testClassPathRollback()
                           throws java.sql.SQLException,
                                  java.net.MalformedURLException
```
    check the roll back of class loading. install a new jar in a transaction, see that the new class is used and then rollback the old class should be used after the rollback.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testReplaceJar
```
public void testReplaceJar()
                    throws java.sql.SQLException,
                           java.net.MalformedURLException
```
    Replace the jar to later test the prepare from a different connection picks up the new version.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testReplacedClass
```
public void testReplacedClass()
                       throws java.sql.SQLException
```
    Change of class due to testReplaceJar that changes the application to run checks on the e-mail to ensure it is valid (in this case by seeing if it simply includes 'spam' in the title).
    
    Throws:
    
    java.sql.SQLException
  - testSecondJar
```
public void testSecondJar()
                   throws java.sql.SQLException,
                          java.net.MalformedURLException
```
    now add another jar in to test two jars and a quoted identifer for the jar names.
    
    Throws:
    
    java.net.MalformedURLException
    
    java.sql.SQLException
  - testSignedJar
```
public void testSignedJar()
                   throws java.sql.SQLException,
                          java.net.MalformedURLException
```
    Test to see if the jar signatures can be obtained from the jar file. The jar was signed with a self signed certificate keytool -delete -alias emccto -keystore emcks -storepass ab987c keytool -genkey -dname "cn=EMC CTO, ou=EMC APP, o=Easy Mail Company, c=US" -alias emccto -keypass kpi135 -keystore emcks -storepass ab987c keytool -selfcert -alias emccto -keypass kpi135 -validity 36500 -keystore emcks -storepass ab987c keytool -keystore emcks -storepass ab987c -list -v jarsigner -keystore emcks -storepass ab987c -keypass kpi135 -signedjar dcl_emc2s.jar dcl_emc2.jar emccto keytool -delete -alias emccto -keystore emcks -storepass ab987c
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - signersTests
```
private static void signersTests(java.sql.Connection conn)
                          throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testHackedJarReplacedClass
```
public void testHackedJarReplacedClass()
                                throws java.sql.SQLException,
                                       java.net.MalformedURLException
```
    Replace the signed jar with a hacked jar. emc.class modified to diable valid e-mail address check but using same signatures within jar. Class loader should reject. rejects it.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testInvalidJar
```
public void testInvalidJar()
                    throws java.sql.SQLException,
                           java.net.MalformedURLException
```
    replace with a hacked jar file, emc.class modified to be an invalid class (no signing on this jar).
    
    Throws:
    
    java.net.MalformedURLException
    
    java.sql.SQLException
  - testRemoveJar
```
public void testRemoveJar()
                   throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testCreateDatabaseJar
```
public void testCreateDatabaseJar()
                           throws java.lang.Exception
```
    Create a Jar of the current database.
    
    Throws:
    
    java.lang.Exception
  - testDatabaseInJar
```
public void testDatabaseInJar()
                       throws java.sql.SQLException
```
    Test the jar'ed up database created by testCreateDatabaseJar accessing the database using the jar(path to archive)db form of database name.
    
    Throws:
    
    java.sql.SQLException
  - testDatabaseInClasspath
```
public void testDatabaseInClasspath()
                             throws java.sql.SQLException,
                                    java.net.MalformedURLException
```
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testLoadJavaClassIndirectly
```
public void testLoadJavaClassIndirectly()
                                 throws java.sql.SQLException,
                                        java.net.MalformedURLException
```
    Load a java.sql class indirectly (ie. through a valid class in the installed jar file) from the jar file.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testLoadJavaClassDirectly
```
public void testLoadJavaClassDirectly()
                               throws java.sql.SQLException,
                                      java.net.MalformedURLException
```
    Load a java.sql class directly (ie. through a direct procedure call) from the jar file.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testLoadJavaClassDirectly2
```
public void testLoadJavaClassDirectly2()
                                throws java.sql.SQLException,
                                       java.net.MalformedURLException
```
    Load a java.derby99 class directly (ie. through a direct procedure call) from the jar file. This is to see if additional non-standard java.* packages can be added into the JVM
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testLoadJavaClassDirectly3
```
public void testLoadJavaClassDirectly3()
                                throws java.sql.SQLException,
                                       java.net.MalformedURLException
```
    Load a javax.derby99 class directly (ie. through a direct procedure call) from the jar file. This is to see if additional non-standard javax.* packages can be added into the JVM. As an implementation note this is blocked by Derby's class loader, not the JVM's security mechanism.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testLoadDerbyClassIndirectly
```
public void testLoadDerbyClassIndirectly()
                                  throws java.sql.SQLException,
                                         java.net.MalformedURLException
```
    Load a org.apache.derby class directly (ie. through a direct procedure call) from the jar file. As an implementation note this is blocked by Derby's class loader, not the JVM's security mechanism.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - loadJavaClass
```
private void loadJavaClass(java.lang.String method,
                           java.lang.String expectedSQLState)
                    throws java.sql.SQLException,
                           java.net.MalformedURLException
```
    Test loading classes in the java. and javax. namespaces from a jar, it should be disallowed or be ignored. These tests are run as separate fixtures to ensure the failed loading does not affect subsequent attempts to load.
    
    Throws:
    
    java.net.MalformedURLException
    
    java.sql.SQLException
  - readOnlyTest
```
private static void readOnlyTest(javax.sql.DataSource ds)
                          throws java.sql.SQLException
```
    Run an number of statements against a jar'ed database to ensure it is read-only and that class loading works from jar files embedded in jar'ed up databases.
    
    Throws:
    
    java.sql.SQLException
  - testClassLoadOrdering
```
public void testClassLoadOrdering()
                           throws java.sql.SQLException,
                                  java.net.MalformedURLException
```
    Test ordering of class loading.
    
    Throws:
    
    java.net.MalformedURLException
    
    java.sql.SQLException
  - checkLoading
```
private void checkLoading(java.lang.String order)
                   throws java.sql.SQLException
```
    Run a number of tests to ensure classes are loaded from the correct class loader. The order of loading the entry point classes is set by order. 123 will load the entry point classes in order OrderTest1, OrderTest2, OrderTest3. Since loading these entry point classes and the order of execution will determine the loading order of the other classes, we change the order to ensure that classes are loaded from the correct jar regardless of which class loaded it. Ie. Loading OrderTest2 first, which loads indirectly OrderObject1,2,3 ensures that even though OrderTest2 is loaded from OT2 that the others are loaded from their correct jar.
    
    Parameters:
    
    order - Order the entry point classes will be loaded.
    
    Throws:
    
    java.sql.SQLException
  - checkCorrectLoader
```
private void checkCorrectLoader(java.lang.String className,
                                java.sql.PreparedStatement ps1,
                                java.sql.PreparedStatement ps2,
                                java.sql.PreparedStatement ps3)
                         throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testIndirectLoading
```
public void testIndirectLoading()
                         throws java.sql.SQLException,
                                java.net.MalformedURLException
```
    Test that loading of Derby's internal classes from an installed jar file is disallowed.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testTableFunctionInJar
```
public void testTableFunctionInJar()
                            throws java.sql.SQLException,
                                   java.net.MalformedURLException
```
    Test that table functions can be invoked from inside jar files stored in the database.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - testUDAInJar
```
public void testUDAInJar()
                  throws java.sql.SQLException,
                         java.net.MalformedURLException
```
    Test that user-defined aggregates can be invoked from inside jar files stored in the database.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - test_5352
```
public void test_5352()
               throws java.sql.SQLException,
                      java.net.MalformedURLException
```
    Test that restricted table functions can be invoked from inside jar files stored in the database.
    
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - installJar
```
private void installJar(java.lang.String resource,
                        java.lang.String jarName)
                 throws java.sql.SQLException,
                        java.net.MalformedURLException
```
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - replaceJar
```
private void replaceJar(java.lang.String resource,
                        java.lang.String jarName)
                 throws java.sql.SQLException,
                        java.net.MalformedURLException
```
    Throws:
    
    java.sql.SQLException
    
    java.net.MalformedURLException
  - removeJar
```
private void removeJar(java.lang.String jarName)
                throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - setDBClasspath
```
private void setDBClasspath(java.lang.String cp)
                     throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - derby2035Workaround
```
private void derby2035Workaround()
                          throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - createArchive
```
private static void createArchive(java.lang.String jarName,
                                  java.io.File dbDir,
                                  java.lang.String dbName)
                           throws java.lang.Exception
```
    jarname - jarname to use path - path to database dbname - database name in archive
    
    Throws:
    
    java.lang.Exception
  - addEntries
```
static void addEntries(java.util.zip.ZipOutputStream zos,
                       java.io.File dir,
                       java.lang.String dbName,
                       int old)
                throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - addFile
```
private static void addFile(java.util.zip.ZipOutputStream zos,
                            java.io.File f,
                            java.lang.String dbName,
                            int old)
                     throws java.io.IOException
```
    Throws:
    
    java.io.IOException
  - setContextClassLoader
```
private static void setContextClassLoader(java.net.URL url)
```

Class DatabaseClassLoadingTest

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

Constructor Detail

DatabaseClassLoadingTest

Method Detail

suite

testWithNoInstalledJars

testJarHandling

testWithNoClasspath

testSetClasspath

testAddContact

testGetResource

getResourceTests

testAlterTable

testClassPathRollback

testReplaceJar

testReplacedClass

testSecondJar

testSignedJar

signersTests

testHackedJarReplacedClass

testInvalidJar

testRemoveJar

testCreateDatabaseJar

testDatabaseInJar

testDatabaseInClasspath

testLoadJavaClassIndirectly

testLoadJavaClassDirectly

testLoadJavaClassDirectly2

testLoadJavaClassDirectly3

testLoadDerbyClassIndirectly

loadJavaClass

readOnlyTest

testClassLoadOrdering

checkLoading

checkCorrectLoader

testIndirectLoading

testTableFunctionInJar

testUDAInJar

test_5352

installJar

replaceJar

removeJar

setDBClasspath

derby2035Workaround

createArchive

addEntries

addFile

setContextClassLoader