db-derby-user mailing list archives

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 <eduardosaltelli@gmail.com> 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.