Book Club Saturdays

The Metropolitan Public Library hosts "Book Club Saturdays," a wildly popular event where 30-40 members arrive at 10 AM to check out their monthly selections. The current system processes each loan individually with auto-commit enabled, creating two critical problems:

Data inconsistency: Last month, the system crashed while processing a member's four-book checkout. Two books were recorded as loaned, but the other two weren't, causing inventory discrepancies and frustrated patrons.
Performance bottleneck: Processing each loan as a separate database transaction takes 15-20 minutes, creating long queues and unhappy library staff.

Your mission is to implement batch processing with transaction control.

Set autoCommit to false to enable manual transaction control in line 32.
Add multiple loans to the batch in line 43.
Commit the transaction if all operations are successful in line 49.

Exercise

Book Club Saturdays

Instructions

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise