May 25, 2012

Post: Upcoming webinar on Hibernate and Connector/J

… Hibernate and Connector/J. If you cannot attend at this time, a recorded session will be available soon after the webinar. MySQL is… persistence with a MySQL backend, and also some more broad implications for Connector/J that will apply for anyone using MySQL from Java. Topics… * Lazyness * Manually written SQL * Concurrency * Concurrency-related config options for Connector/J You may register here.

Comment: Logging MySQL queries from the client instead of the server

I suppose you could also use MySQL Proxy to do the logging. This is like how MySQL Enterprise does the query capturing for the Query Analyzer. The Query Analyzer also uses hooks in the JDBC connector for an interceptor plugin, so you could also write a plugin for Connector/J.

Comment: Checking for a live database connection considered harmful

Baron, I was trying to verify that mysql is able to resume transaction in reconnect. In JDBC standard, … no mentioning of reconnect. In mysql jconnector document (http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html), I…

Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE

… into some deadlocking. Essentially things look like this (MySQL 5.0.45/Windows/Connector-J-5.1.5): Transaction-1 ————- SELECT p FROM… statements in Transaction-1 and hence the deadlock condition. The MySQL 5.0 Reference Guide has the following advice: Another way…