i was positively surprised to see how popular my recent listing about   10 common mistakes java developers make when writing sql   was, both  on my own blog  and  on my syndication partner dzone  . the popularity shows a couple of things:

how important sql is to the professional java world.
how common it is to forget about some basic sql things.
how well sql-centric libraries such as  jooq  or  mybatis  are responding to market needs, by  embracing sql  . an amusing fact is that users have even mentioned my blog post on  slick’s mailing list  . slick is a non-sql-centric database access library in scala. like  linq (and linq-to-sql) it focuses on language integration  , not on sql code generation.

anyway, the common mistakes i listed previously are far from complete, so i will treat you to a sequel of 10 subtly less common, yet equally interesting mistakes java developers make when writing sql.