Running embedded mode within a Tomcat webapp. I have some Java code that programmatically does the shutdown and directory deletion.
I get the expected SQLException on the shutdown. Attempting to delete the directories fails both within the webapp and from external shell command. In a debugger I've paused a derby.rawStoreDaemon thread to walk the data structures. I have come across references to the database in question. So somewhere along the lines the shutdown isn't really cleaning everything up. I was under the impression that a shutdown pickles off any outstanding connections. Is it possible that a reference to an existing connection (obtained prior to the shutdown) is harboring the reference to this data file? BTW--Thanks for the quick reply! cheers, Ed Manjula Kutty wrote: > > I tried the same scenario you mentioned and I'm able to delete the > database > without any problem? Are you deleting manually or through any pgm? > > -Manjula > > > On 10/3/07, EdS <[EMAIL PROTECTED]> wrote: >> >> >> I run into an issue where i dynamically create databases to cache >> data. At >> some point when I no longer need the cache, I perform a shutdown and >> delete >> the directory where the database resides. >> >> Unfortunately there's still open file references to one of the c*.dat >> files >> that prevents me from getting a clean filesystem delete. >> >> Anyone else seen this behavior, or is it a known bug? My searches so far >> have proved fruitless. >> >> tia, >> >> Ed >> >> >> -- >> View this message in context: >> http://www.nabble.com/Database-shutdown-not-releasing-file-locks-tf4564520.html#a13028425 >> Sent from the Apache Derby Users mailing list archive at Nabble.com. >> >> > > > -- > Thanks, > Manjula. > > -- View this message in context: http://www.nabble.com/Database-shutdown-not-releasing-file-locks-tf4564520.html#a13029853 Sent from the Apache Derby Users mailing list archive at Nabble.com.
