JOOQ requires JDBC Connection, How to get it from JPA of Play ?

[Rakesh Waghela]

http://sourceforge.net/apps/trac/jooq is an excellent library for relational DB access. Unfortunately it provides only the query generation and depends upon external Connection,Transaction management. { http://sourceforge.net/apps/trac/jooq/wiki/Manual/JOOQ/Factory }

I want to use connection management,transaction management provided by Play JPA. How to get it done ?

[Lukas Eder]

> I want to use connection management,transaction management provided by Play
> JPA. How to get it done ?

I had recently thought about an integration of jOOQ and Play and
supporting this integration as a jooq-play module as a part of the
jOOQ project. The licenses of the two frameworks are compatible (both
Apache 2.0), hence a cooperation should be possible.

In any case, I'm curious about your experience, Rakesh.

> Unfortunately it [jOOQ...] provides only the query generation and depends
> upon external Connection,Transaction management.

Maybe, for the time being, you could bridge the two frameworks with
spring?

Cheers
Lukas

[GrailsDeveloper]

Have a look to the JPA-Plugin. You get a Connection with
DB.getConnection().
Niels

[Rakesh Waghela]

Thank you Niels ! :)