Expand Authors Top

If you have a few years of experience in the Java ecosystem and you’d like to share that with the community, have a look at our Contribution Guidelines.

Expanded Audience – Frontegg – Security (partner)
announcement - icon User management is very complex, when implemented properly. No surprise here.

Not having to roll all of that out manually, but instead integrating a mature, fully-fledged solution - yeah, that makes a lot of sense.
That's basically what Frontegg is - User Management for your application. It's focused on making your app scalable, secure and enjoyable for your users.
From signup to authentication, it supports simple scenarios all the way to complex and custom application logic.

Have a look:

>> Elegant User Management, Tailor-made for B2B SaaS

NPI – JPA Buddy – JPA (partner)
announcement - icon

JPA is huge! It covers nearly every aspect of communication between relational databases and the Java application and is deeply integrated into all major frameworks.

If you're using IntelliJ, JPA Buddy is super helpful. The plugin gently guides you through the subtleties of the most popular JPA implementations, visually reminds you of JPA features, generates code that follows best practices, and integrates intelligent inspections to improve your existing persistence code.

More concretely, it provides powerful tooling to generate Spring Data JPA repositories and methods, Flyway Versioned Migrations, Liquibase Differential Changelogs, DDL and SQL statements, DTO objects, and MapStruct interfaces.

Oh, and it actually generates JPA entities from an existing database and gradually update the data model as the database evolves! Yeah.

>> Become a lot more productive with JPA Buddy

1. Introduction

In this short tutorial, we'll learn how to set SQL table names using JPA.

We'll cover how JPA generates the default names and how to provide custom ones.

2. Default Table Names

The JPA default table name generation is specific to its implementation.

For instance, in Hibernate the default table name is the name of the class with the first letter capitalized. It's determined through the ImplicitNamingStrategy contract.

But we can change this behavior by implementing a PhysicalNamingStrategy interface.

3. Using @Table

The easiest way to set a custom SQL table name is to annotate the entity with @javax.persistence.Table and define its name parameter:

@Table(name = "ARTICLES")
public class Article {
    // ...

We can also store the table name in a static final variable:

@Table(name = Article.TABLE_NAME)
public class Article {
    public static final String TABLE_NAME= "ARTICLES";
    // ...

4. Overwriting the Table Name in JPQL Queries

By default in JPQL queries, we use the entity class name:

select * from Article

But we can change it by defining the name parameter in the @javax.persistence.Entity annotation:

@Entity(name = "MyArticle")

Then we'd change our JPQL query to:

select * from MyArticle

5. Conclusion

In this article, we've learned how JPA generates default table names and how to set SQL table names using JPA.

As always all source code is available over on GitHub.

Persistence bottom

Get started with Spring Data JPA through the reference Learn Spring Data JPA course:

Persistence footer banner
Comments are closed on this article!