Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Blatant Advertising and the fly likes jOOQ is the Best and an Increasingly Popular Way to Write SQL in Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Other » Blatant Advertising
Bookmark "jOOQ is the Best and an Increasingly Popular Way to Write SQL in Java" Watch "jOOQ is the Best and an Increasingly Popular Way to Write SQL in Java" New topic
Author

jOOQ is the Best and an Increasingly Popular Way to Write SQL in Java

Lukas Eder
Ranch Hand

Joined: Jul 22, 2013
Posts: 41
    
    4

Why is jOOQ becoming increasingly popular in the Java ecosystem?

Java and SQL are both very popular languages in enterprise software development. Yet, the only standard interface between the two is JDBC, which is agreed by many programmers to be a very awkward, stateful and verbose API. Being low-level, it covers (almost) complete access to all SQL standard and vendor-specific SQL functionality, but client code is tedious to write, string-based, and thus, error-prone.

Other alternative standards (JPA and JDO) mostly hide SQL from their clients. While they ease the pain for writing CRUD, querying may become very difficult or slow.

jOOQ is a true and increasingly popular Open Source alternative to the Java standards, where users want to embed typesafe SQL as an internal domain-specific language directly into their Java code. The Java compiler can infer a lot of SQL syntax, metamodel and data type typesafety for you via jOOQ's unique fluent API technique and row value expression typesafety.

These are typical SQL statements



... and this is how they translate to jOOQ



jOOQ...

  • ... models a large subset of the SQL language in Java
  • ... translates functions and SQL clauses into equivalent SQL, if not supported by your database
  • ... executes your SQL and lets you transform flat result sets into your own domain model
  • ... ships with a code-generator which generates typesafe artefacts from your database meta data
  • ... allows for typesafely embedding your stored functions in SQL expressions


  • And much more. See more of jOOQ in the jOOQ tutorial. You will see that there is no better way to embed SQL into the Java language, than by using jOOQ


    When Java and SQL work together, great software can evolve. That's why I have created jOOQ. Follow me on blog.jooq.org
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: jOOQ is the Best and an Increasingly Popular Way to Write SQL in Java