drop database with PreparedStatement

[yaron re]

any idead why the following code doesn't work:

con = dataSource.getConnection();
ps = con.prepareStatement("DROP DATABASE DBNAME ");
rs = ps.executeQuery();

[Jan Cumps]

Maybe because your code has an active connection to the database?
What happens when you execute the code? (better not try this on your production instance)

[Adeel Ansari]

Why do you think that its appropriate here in performance?

[yaron re]

the dataSource is in a superior level to the instance that i am tring to delete.
The connection must have the ability to delete the DB.

[Adeel Ansari]

The question remains the same. What are you getting? Any errors? Excpetions? Messages?