For many users, it may be an obvious choice to use jOOQ along with Play Framework, leveraging simplicity and effectiveness in the Java world. While I do not have any personal experience with Play, some users have. Consider this GitHub issue where a couple of very active jOOQ users discuss various techniques of integrating the two frameworks:
https://github.com/jOOQ/jOOQ/issues/768
From the above discussion, a third-party plugin example has evolved: