jOOQ Object Oriented Querying, commonly known as jOOQ, is a light database-mapping software library in Java that implements the active record pattern. I
The software generates Java code from your database and lets you build type safe SQL queries through its fluent API.
There is an open source edition available.
Key Features
- SQL-centric.
- Typesafe SQL
- Code generation – generates Java classes from the database metadata
- Active Records – perform CRUD and POJO mapping directly on Active Records.
- Multi-tenancy – configure database schema and table overrides at runtime and also supports row-level security.
- Standardisation – performs SQL transformation to transform common SQL expressions into the database’s closest match.
- Query lifecycle – hook into its SQL generation for logging, transaction handling, ID generation, SQL transformation, and more.
- Procedures – embed stored function calls into SQL statements.
Website: www.jooq.org
Support: Blog, GitHub Code Repository
Developer: Data Geekery GmbH
License: Apache License, Version 2.0
jOOQ is written in Java. Learn Java with our recommended free books and free tutorials.
Related Software
| Java Object-Relational Mapping Software | |
|---|---|
| Hibernate ORM | Idiomatic persistence for Java and relational databases |
| MyBatis | Persistence framework with custom SQL and stored procedures |
| Apache Cayenne | Provides object-relational mapping (ORM) and remoting services |
| jOOQ | jOOQ Object Oriented Querying |
| DataNucleus | Supports JDO and JPA API's for persistence |
| Apache OpenJPA | Java persistence project |
| Ebean | Designed to be simpler to use and understand than JPA or JDO products |
| EclipseLink | Persistence solution addressing relational, XML, and database web services |
| Persism | Lightweight, auto discovery, autoconfiguration ORM |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |