Bug #9823 JDBC Trouble
Submitted: 11 Apr 2005 17:08 Modified: 11 Apr 2005 17:14
Reporter: Vineet Billorey Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:Fedora Core 2 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[11 Apr 2005 17:08] Vineet Billorey
Description:
I connected to the MySQL Database through the JDBC Statement:

Class.forName(.....);
Connection con=DriverManager.getConnection(....);
java.sql.Statement st=con.createStatement();

Now I write command as follows:

st.executeUpdate("create database India");

after some steps, if I write the command:

st.executeUpdate("drop database India");

Sorry!! Tha database is not deleted even after executing above command.
Even if I restart the MySQL Server and repeat the above command, the database still exists.

Can you please suggest the cause or solution?

How to repeat:
I connected to the MySQL Database through the JDBC Statement:

Class.forName(.....);
Connection con=DriverManager.getConnection(....);
java.sql.Statement st=con.createStatement();

Now I write command as follows:

st.executeUpdate("create database India");

after some steps, if I write the command:

st.executeUpdate("drop database India");

Sorry!! Tha database is not deleted even after executing above command.
Even if I restart the MySQL Server and repeat the above command, the database still exists.

Can you please suggest the cause or solution?

Suggested fix:
No Fix.....
[11 Apr 2005 17:14] Mark Matthews
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.