[DERBY-3789] Shutting down encrypted database with ResultSet open does not allow directory to be deleted on Windows

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 10.5.1.1
• Component/s: Services

Environment

Windows XP java version "1.5.0"
Java(TM) 2 Runtime Environment, Standard Edition (build pwi32dev-20070201 (SR4))
IBM J9 VM (build 2.3, J2RE 1.5.0 IBM J9 2.3 Windows XP x86-32 j9vmwi3223-20070201 (JIT enabled)
J9VM - 20070131_11312_lHdSMR
JIT - 20070109_1805ifx1_r8
GC - 200701_09)
JCL - 20070131

• Issue & fix info: High Value Fix
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 21/Jul/08 18:43
• Updated: 30/Jun/09 16:02
• Resolved: 30/Jul/08 17:45

Description

If I run the attached program on Windows to create an encrypted database open a result set, shutdown and attempt to delete the directory it fails with:
[C:]java EncryptShutdown
Exception in thread "main" junit.framework.AssertionFailedError: encryptdb\seg0\c400.dat
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.assertTrue(Assert.java:20)
at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:130)
at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDir(DropDatabaseSetup.java:128)
at org.apache.derbyTesting.junit.DropDatabaseSetup.access$000(DropDatabaseSetup.java:35)
at org.apache.derbyTesting.junit.DropDatabaseSetup$1.run(DropDatabaseSetup.java:105)
at java.security.AccessController.doPrivileged(AccessController.java:193)
at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDirectory(DropDatabaseSetup.java:102)
at org.apache.derbyTesting.junit.DropDatabaseSetup.removeDirectory(DropDatabaseSetup.java:98)
at org.apache.derbyTesting.junit.BaseTestCase.removeDirectory(BaseTestCase.java:522)
at EncryptShutdown.main(EncryptShutdown.java:25)

Apparently all resources are not being released. It runs fine if the database is not encrypted.