HSQL changes not getting saved

Posted on January 6, 2008
Filed Under Java | Leave a Comment

I had my time with the interns yesterday when they complained that the changes they made are not getting saved to the HSQL database. I spend an hour trying to find out why, at last I found out that in HSQL you need to send a SHUTDOWN command to save the changes in a clean way…

1
2
3
4
5

Statement st = conn.createStatement();
 
// db writes out to files and performs clean shuts down
st.execute("SHUTDOWN");
conn.close();

  • About

    This is an area on your website where you can add text. This will serve as an informative location on your website, where you can talk about your site.