Reviews by real users

Just finished a project using open source libraries and have fresh impressions?

Write a review to share your experiences with open source!

On DevRates we focus on reviews by developers using libraries on their daily work.

Technology radar

Launching a start-up or commercial project using open-source libraries? No time to evaluate various technology stacks?

Interested in the latest trends and top-rated open source projects for all layers of your application?

DevRates contains projects reviews of most popular tagged categories and programming languages.

Build your skill profile

Join DevRates and build your public profile from libraries you know and experience positions from projects you've been involved in.

Follow projects and don't miss any news from blogs and twitter on your wall.

Your company is looking for talented developers? Register on DevRates and show your technology stack on your company profile.




Latest release

2.5.1 (23/09/2012)

Developed by


Apache 2.0

Overall rating



  • sql

  • dsl

  • api

  • java


jOOQ stands for Java Object Oriented Querying. It combines these essential features:

  • Code Generation: jOOQ generates a simple Java representation of your database schema. Every table, view, stored procedure, enum, UDT is a class.
  • Active records: jOOQ implements an easy-to-use active record pattern. It is NOT an OR-mapper, but provides a 1:1 mapping between tables/views and classes. Between columns and members.
  • Typesafe SQL: jOOQ allows for writing compile-time typesafe querying using its built-in fluent API.
  • SQL standard: jOOQ supports all standard SQL language features including the more complex UNION's, nested SELECTs, joins, aliasing
  • Vendor-specific feature support: jOOQ encourages the use of vendor-specific extensions such as stored procedures, UDT's and ARRAY's, recursive queries, and many more.
How does jOOQ help you?
  • Your database always comes FIRST! That's where the schema is, not in your Java code or some XML mapping file.
  • Your schema is generated in Java. You can use auto-completion in your IDE!
  • Your "value objects" or "data transfer objects" are generated too. This keeps things DRY
  • Your Java code won't compile anymore when you modify your schema. That means less runtime errors.
  • You and your DBA can be friends again because you have full control over your SQL.
  • You can port your SQL to a new database. jOOQ will generate SQL that works on any database.
  • You won't have syntax errors in your query.
  • You won't forget to bind variables correctly. No SQL injection, either.
  • You can forget about JDBC's verbosity (especially useful when dealing with UDTs, ARRAYs and stored procedures).
Or in short:
  • You can be productive again!


Related projects

Latest reviews

No reviews
Please sign in to rate or post a comment
Scroll to top