----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 15, 2002 4:51 PM
Subject: mysql process keeps references to files after conn.close()
> Hi.
>
> I am doing a simple programmatic task. I am opening a connection to a
> database using
>
> connn = DriverManager.getConnection("jdbc:mysql://localhost/dbname")
>
> I then do some stuff, and execute a conn.close().
>
> I then try and delete the database files, and I get an error that they are
> in use by another process - you guessed it, mysql.
>
> My question is why?!!!
Because the MySQL database server process has nothing to do with the
connections that are made to it. You are also probably running on Windows
which does have 'interesting' file handling semantics, to say the least.
You will need to stop the MySQL server before trying to delete the files. On
the other hand, you would be better off to use the normal 'drop table' and
'drop database' commands from within MySQL, really.
-Mark
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
