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.
I spent some time looking into Java’s Spring framework today.
There are two things you need to do to write a prepared statement in Java. First your going to need an SQL string with ?s in place of the values. Second we add the values to the statement by calling the set methods of the preparedstatement. PreparedStatement.setString(1, AnyStringData) will set the first question mark in the SQL string with “AnyStringData”. Continue reading
Posted in Programming
Tagged Code, Java, SQL