Here are some resources on the apache’s Structs library, most of this was taken from apache’s structs site:
SHOW INNODB STATUS Walk Through
By: Peter Zaitsev
I found Peter’s blog from a StackOverflow question about deadlocking. It’s well documented and looks promoising. Here is the link for the orginal SO question.
MySQL 5.0 Reference Manual – The InnoDB Transaction Model and Locking
Manuals are always good reads.
Here are a few resources to get you using with BoneCP. You can get this free library at jolbox.com