A very nice little rant on Hibernate: http://jeffkemponoracle.com/2011/11/25/3-reasons-to-hate-hibernate While I don't agree 100% (e.g. CRUD/OLTP really is different from OLAP, and Hibernate is a strong CRUD tool), I certainly share most of his feelings.
Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.