Getting a syntax error when executing SQL statement

Question

I have the following method that drops the database but I get a syntax error and I dont know what is going on.

public void deleteDB(){
    try{
        Statement s = conn.createStatement();
        System.out.println("Deleteting database...");
        s.execute("DROP DATABASE Courses");
        System.out.println("Database deleted.");
    }
    catch(SQLException error){
        System.err.println("Unable to delete database.");
        error.printStackTrace(System.err);
        System.exit(0);
    }
}

I call the method with:

UpdateDB update = new UpdateDB();
update.connectDatabase(dbName);
update.deleteDB();

I get this error:

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "DATABASE" at line 1, column 6.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

Any suggestions?

Does the account you have used have permission to drop the database? — BugFinder
– BugFinder, Commented May 31, 2011 at 22:16
there does not seem to be a drop database db.apache.org/derby/manuals/reference/sqlj28.html . Maybe you need drop schema? — Bala R
– Bala R, Commented May 31, 2011 at 22:19

John Gardner · Accepted Answer · 2011-05-31 22:17:09Z

10

Do you have a database called courses? or a table named courses?

according to this: http://db.apache.org/derby/docs/10.0/manuals/develop/develop13.html

There is no drop database command. To drop a database, delete the database directory with operating system commands.

answered May 31, 2011 at 22:17

John Gardner

25.3k5 gold badges65 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

0xDAB-DAD Over a year ago

I have a database named Courses. I was able to delete my table using a DROP Table command that worked fine.

Collectives™ on Stack Overflow

Getting a syntax error when executing SQL statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related