Developing with Apache Derby -- Hitting the Trifecta: Database development with Apache Derby, Part 3

(Robert Brunner) In the previous article in this series, "Database development with Apache Derby, Part 2: Schemas," you executed SQL commands directly at the prompt of the ij tool. By using the ij tool, you can easily experiment with different SQL or Derby commands. Often, however, you'll need to execute multiple, complex commands. To simplify debugging a set of complex SQL commands, it's generally easier to write them in a text file and then execute the commands in the text file all at once. This operation is known as running a SQL script, and you can do so easily by using Apache Derby. By placing SQL commands in a script file, you gain the additional benefit of being able to execute the commands as many times as necessary.