drop database with PreparedStatement

yaronr · #1 (**permalink**) 07-03-07, 12:35

any idead why the following code doesn't work:

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

swapnilclarion · #2 (**permalink**) 07-04-07, 00:59

Hi,

Does it give any error, if yes what type of error?
Try using ps.executeUpdate() instead of ps.executeQuery()

thanks,

yaronr · #3 (**permalink**) 07-04-07, 02:42

thanks

that was the problem...

Internet Services

Web Development

Digital Marketing

Consumer Tech