Cathal King

Greenhorn
+ Follow
since May 14, 2012
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Cathal King

Lukas, thanks for the response. That's given me some food for thought.
I'd be interested in hearing from anyone who has experience of introducing usage of JOOQ http://www.jooq.org/ into their application as a replacement for, say, handrolled JDBC-based DAOs.

Where there any unexpected gotchas that you would've like to have known about up-front?
Is your build process more complex as a result? Are you ok with that? (I'm thinking here about the code generation aspects of JOOQ and what this might imply for version controlling your DB schema through out your environments)
In hindsight do you feel it has been worth the investment?

I'm asking from the perspective of someone who works on relatively humble Enterprise Web App with a significant amount of JDBC DAO dependent CRUD functionality.
We're about to evolve our DB schema (Oracle) quite a bit over the coming months as part of functional changes to the application's user entitlements model.

So, if the benefits are enticing enough, this might be an opportune time to leverage a tool such as JOOQ as part of that effort.