shortland/Little-Bobby-Tables-Auction-House

GetEmployees misspelling

Closed this issue · 6 comments

khan-ibrahim commented

Fix misspelled word #2087879
Logged in as Manager, tried to view/edit/delete employee.
Error:
java.sql.SQLException: Column 'SocialSecutiy' not found.

shortland commented

Release eclipse-stuff 2a18217 fixes this issue.

Requesting test @khan-ibrahim

khan-ibrahim commented

New error on same workflow. 2a18217
Requesting fix
Error:
java.lang.NumberFormatException: For input string: "60.0"

shortland commented

Fix attempted.
Database (EmployeeData.HourlyRate) was of type Double. Changed to type INT.

Test requested.

khan-ibrahim commented

Error resolved. New error present. 2a18217
Likely database side error.
Requesting fix @shortland
Error:
java.sql.SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (LittleBobbyTablesAuctionHouse.AuctionData, CONSTRAINT AuctionData_ibfk_1 FOREIGN KEY (EmployeeID) REFERENCES EmployeeData (EmployeeID))

shortland commented

Fix attempted.

ALTER TABLE `AuctionData` 
ADD CONSTRAINT `AuctionData_EmployeeID_EmployeeData` 
FOREIGN KEY (`EmployeeID`) REFERENCES `EmployeeData`(`EmployeeID`) 
ON DELETE SET NULL 
ON UPDATE NO ACTION;

Test requested
@khan-ibrahim

khan-ibrahim commented

Error addressed. Potential side effects of null value in auction table for other use cases? Issue closed.