Tag Archives: SQL

MySQL Transactional Databases Resources

SHOW INNODB STATUS Walk Through
By: Peter Zaitsev
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/

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.

http://stackoverflow.com/questions/1851528/mysql-deadlock-explanation-needed

MySQL 5.0 Reference Manual – The InnoDB Transaction Model and Locking
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html

Manuals are always good reads.

Advertisements

Spring into Java

I spent some time looking into Java’s Spring framework today.
Continue reading

Writing SQL Prepared Statements in Java

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