unable to drop table in HSQLDB

Question

I am unable to drop table with default user SA(or any user for that matter) in HSQLDB even though I can create table and read them without problem, please see my code below, what's wrong? On the other hand, If I use a third party SQL client(eg. squirrel), I can login and drop table without problem even when user is empty.

 public static void main(String[]args){ try { DBManager.executeUpdate("drop table mytable"); } catch (SQLException ex) { ex.printStackTrace(); } } public static Connection getConnection(){ Connection c =null; try { c = DriverManager.getConnection("jdbc:hsqldb:file:e:\\xxx_db\\xxx", "SA", ""); } catch (SQLException ex) { ex.printStackTrace(); } return c; } public static int executeUpdate(String s) throws SQLException { Connection con = getConnection(); try{ return con.createStatement().executeUpdate(s); } finally{ if(con!=null)try { con.close(); } catch (SQLException ex) { Logger.getLogger(DBManager.class.getName()).log(Level.SEVERE, null, ex); } } }

Are you getting an error/Exception? Is the SQL succeeding but the table is still there? — Adam Batkin
– Adam Batkin, Commented Jun 2, 2011 at 20:20
@Adam Batkin: I am not getting any exceptions, the SQL seems to be succeeding but table is still there.. — user775187
– user775187, Commented Jun 2, 2011 at 20:37

user775187 · Accepted Answer · 2011-06-05 16:09:58Z

1

It turns out I need to do an explicit shutdown aftwards

 DBManager.executeUpdate("shutdown");

answered Jun 5, 2011 at 16:09

user775187

23.7k8 gold badges31 silver badges37 bronze badges

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

Comments

Adam Batkin · Accepted Answer · 2011-06-02 22:09:53Z

0

Try committing after executing the DDL.

answered Jun 2, 2011 at 22:09

Adam Batkin

53.3k9 gold badges128 silver badges115 bronze badges

Collectives™ on Stack Overflow

unable to drop table in HSQLDB

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related