May 23, 2012

Post: Upcoming webinar on Hibernate and Connector/J

… be giving a webinar about performance implications for Hibernate and Connector/J. If you cannot attend at this time, a recorded session… 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: Alternatives of PHP ?

… them pretty for my taste. – Too much standardization. For example Connector/J has to be JDBC complaint which means it has to… can take a look at any stack trace posted for Connector/J bugs… it is rarely less than 20 levels. – Too many…

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

… document (http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html), I found a property called autoReconnect…

Comment: SELECT LOCK IN SHARE MODE and FOR UPDATE

…. Essentially things look like this (MySQL 5.0.45/Windows/Connector-J-5.1.5): Transaction-1 ————- SELECT p FROM assets WHERE…