Saving embedded Derby DB to a file.
Posted on 2006-11-23
To create a derby db and get a connection I do:
String driver = "org.apache.derby.jdbc.EmbeddedDriver";
Properties props = new Properties();
// to create a new database
return DriverManager.getConnection(dbUri, props);
I then do normal JDBC operations on that connection to create tables and insert values into those tables.
Then what do I do? How do I tell it to store that data on disk somewhere so that I can open it again later? I assume that the "createFrom" property would be used to reopen an existing derby db. But, I don't see a property that specifies how to save the data there in the first place.