Skip to content
  • Java And Other Languages
  • jOOQ and jOOλ
  • jOOQ Tuesdays and Guest Posts
  • SQL Features and Tuning
  • Thoughts on Programming

Java, SQL and jOOQ.

Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ.

Tag: meta data

jOOQ Tip of the Day: Discover all Primary Keys

Posted on November 14, 2014November 1, 2014 by lukaseder

We've recently encountered this interesting use-case on the jOOQ user group. How do you discover all primary keys of your schema via the jOOQ API? There are two ways: Using the generated meta data Using runtime meta data Let's see how it works: Using the generated meta data This is straightforward. If you're using Java … Continue reading jOOQ Tip of the Day: Discover all Primary Keys →

  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • More
  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)

Like this:

Like Loading...
Tagged information_schema, jooq, meta data, query, schema information4 Comments

Database schema navigation in Java

Posted on September 11, 2011 by lukaseder

An important part of jOOQ is jooq-meta, the database schema navigation module. This is used by the code generator to discover relevant schema objects. I was asked several times why I rolled my own instead of using other libraries, such as SchemaCrawler or SchemaSpy, and indeed it's a pity I cannot rely on other stable … Continue reading Database schema navigation in Java →

  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • More
  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)

Like this:

Like Loading...
Tagged dictionary tables, dictionary views, information_schema, jooq, jooq-meta, meta data, meta navigation, navigation, schema, schema navigation, SQL 922 Comments

Like this blog? Check out our the best way to write SQL in Java:

jOOQ: Get Back in Control of Your SQL

Don’t forget to follow us on Twitter

Jump to:

  • Home
  • SQL Tricks and Tuning
  • Thoughts on Programming
  • jOOQ Tuesdays and Guest Posts
  • Java and Other Languages
  • jOOQ and jOOλ

Follow Blog via Email

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,106 other subscribers

Top Posts & Pages

  • Say NO to Venn Diagrams When Explaining JOINs
  • Selecting all Columns Except One in PostgreSQL
  • A Beginner's Guide to the True Order of SQL Operations
  • 10 SQL Tricks That You Didn't Think Were Possible
  • How SQL DISTINCT and ORDER BY are Related
  • How to Write a Multiplication Aggregate Function in SQL
  • 3 Reasons why You Shouldn't Replace Your for-loops by Stream.forEach()
  • Common SQL Clauses and Their Equivalents in Java 8 Streams
  • What's Faster? COUNT(*) or COUNT(1)?
  • You Probably don't Use SQL INTERSECT or EXCEPT Often Enough

Recent Posts

  • Emulating Window Functions in MySQL 5.7 January 20, 2023
  • Why You Should Execute jOOQ Queries With jOOQ January 18, 2023
  • jOOQ’s R2DBC LoggingConnection to log all SQL statements January 17, 2023
  • When to Use jOOQ and When to Use Native SQL December 8, 2022
  • LATERAL is Your Friend to Create Local Column Variables in SQL November 4, 2022
  • Calling Procedures with Default Parameters using JDBC or jOOQ October 21, 2022
  • Using jOOQ’s Implicit Join From Within the JOIN .. ON Clause September 13, 2022
  • A Brief Overview over the Most Common jOOQ Types September 6, 2022
  • How to Plot an ASCII Bar Chart with SQL September 1, 2022
  • The Second Best Way to Fetch a Spring Data JPA DTO Projection August 30, 2022
jOOQ: Get Back in Control of Your SQL

About

Learn more about jOOQ

Copyright (c) by Data Geekery GmbH.
Content is licensed CC BY-SA 3.0

 

Subscribe to this blog

↑ Back to top

 

Loading Comments...
 

    %d bloggers like this: