how to execute several sql files on Derby DB?

I have many table creation scripts (sql files), which I would like to run, in order to create a db structure.

Is there a good way of doing it with Derby DB?

开发者_如何学Python

I intend to run this script occasionally, which mean it should be an automatic process. Is there a way to execute a bunch of .sql scripts automatically?

Thanks, Daniel

---

Use the bundled utility ij - have a look at the doc