Assignment 3 Clarifications and Corrections

Check this page regularly for any hints, clarifications or corrections related to Assignment 3

• Constructor name change:
  Your constructor method should be named the same as your Java class. Therefore instead of Assignment2() it should be Assignment3().
• Connecting to the Database
  If you cannot connect to the database, try the following:
  1. Read the jdbc information on the Postgres Web page for this course. Specifically - it points to a sample hello java program (on your cdf or bladen system) which illustrates a connection.
  2. Look at the tutorial notes for week 7
  3. Make sure that you are connected (ssh) to the machine with the database server
  4. Look at the course bulletin board for problems that others have had - and how they fixed them.
  5. Make sure that you have set your classpaths.
• The submission deadline for both UTSC and St. George has been moved to Sunday, March 9th at midnight.
  Assignments submitted after midnight Sunday will not be accepted (i.e., no late assignments). You must submit your assignment electronically. As well, you must include a text cover page which contains your student information. So your electronic submission must contain two files: Assignment3Cover.txt and Assignment3.java

• DDL changes::
  Because we can delay flights to as late as 12:59 p.m. (in the delayFlights method), we can run into problems if a flight leaves at 12:59 p.m. and arrives early the next day. Currently there is a constraint (see the DDL) which does not permit the arrival time to precede the departure time. This constraint does not allow us to delay a flight to 12:59 p.m. since the flight would arrive the next morning. For this reason, we have modified the DDL to eliminate this constraint. Please download and use the revised DDL.
• Throwing Exceptions
  Some students wanted to know what to do when an exception is thrown. This is described in the handout (page 1):
  9. A successful action (Update, Delete) is when:
     a. It doesn't throw an SQL exception, and
     b. The number of rows to be updated or deleted is correct.
  If an exception is thrown in an update or delete, then return "false". If you are generating a list of items to be contained in a string - then return an empty string.