Populating the Example Database

When you deploy any of the Duke’s Bookstore applications using ant deploy, the database is automatically populated at the same time. If you want to populate the database separately from the deploy task or are using NetBeans IDE to deploy the application, follow these steps:

1. In a terminal window, go to the books directory or any one of the bookstore1 through bookstore6 example directories.

2. Start the Java DB database server. For instructions, see Starting and Stopping the Java DB Database Server. You don’t have to do this if you are using NetBeans IDE. It starts the database server automatically.

3. Type ant create-tables. This task runs a command to read the file tutorial.sql and execute the SQL commands contained in the file.

4. At the end of the processing, you should see the following output:

   ... [sql] 181 of 181 SQL statements executed successfully

When you are running create-tables, don’t worry if you see a message that an SQL statement failed. This usually happens the first time you run the command because it always tries to delete an existing database table first before it creates a new one. The first time through, there is no table yet, of course.