Did you check if the "date" column is in the yyyy/mm/dd format or if the first character of the "Rate" is the "$" (dollar) sign, the same with the customer id - if it's exactly 8 digits long ??
SCJP, OCMJD, OCMJEA
The id value (an 8 digit number) of the customer who has booked this.
The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
Field formats are known at runtime and the specs say nothing about them, you only know if they are numeric/alphanumeric and their length.
Valid values are "Y" indicating a smoking room, and "N" indicating a non-smoking room ...
This field includes the currency symbol ...
Date available date 10 The single night to which this record relates, format is yyyy/mm/dd...
Customer holding this record owner 8 The id value (an 8 digit number)...
So I believe there should be some validation mechanisms in the Data class too ...
... I know that using common sense you can easily conclude that there is nothing bad if the value is less than 8 digits long, but the instructions leave no doubt about how it is expected to be.
character of the "Rate" is the "$" (dollar) sign
SCJP, OCMJD, OCMJEA
name VARCHAR(64) NOT NULL // only the length is checked
location VARCHAR(64) NOT NULL // only the length is checked
size LONG NOT NULL // length is checked, also must be valid long (Java long)
smokingCHAR NOT NULL // only the length is checked
rate MONEY NOT NULL // must be within $0.00 - $9999.99, the leading $ is required
date DATE NOT NULL // must be a valid date formated as yyyy/mm/dd
owner LONG // length is checked, must be valid long (Java long)
"shower thinking", and "WC thinking"
smoking CHAR NOT NULL
... not checked in my case since I do not change the field
About the owner column - check the link from Andrew's reply in this thread (in short: Sun does not complain if the ids are less than 8 digit long).
Also the requirements for the owner column seem business requirements
record owner 8 The id value (an 8 digit number)
SCJP, OCMJD, OCMJEA
smoking CHAR NOT NULL
what about ...?
smoking BOOLEAN DEFAULT FALSE NOT NULL
SCJP, OCMJD, OCMJEA
The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
SCJP, OCMJD, OCMJEA
Don't touch me. And dont' touch this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
|