Skip to content Burger menu icon
Idea logo

IntelliJ IDEA

IntelliJ IDEA – the Leading Java and Kotlin IDE, by JetBrains

Download
Tips & Tricks

HQL Console with Pure JPA Facets

JetBrains
JetBrains

In IntelliJ IDEA HQL console can be used with pure JPA facets (as well as with Hibernate facets) to run JPAQL and HQL queries. All you need is Hibernate libraries and JDBC driver in a module classpath. If persistence.xml contains no Hibernate-specific database connection options, it should be mapped to an existing data source via JPA facet settings.

Tip: HQL console can also be used to generate DDL statements for JPA and Hibernate mappings via its Generate DDL command.

Update: If a Persistence Unit or Session Factory is mapped to a valid local Data Source there is no need to specify JDBC driver jars in a module classpath (Since 8.1.1).

code generation database Hibernate JPA
Prev post Smart WebBeans Event Model Navigation in MaiaGenerating Persistence Mappings from Database Schema Next post
image description

Discover more

Streamline Your Workflow in IntelliJ IDEA’s Database Tools With AI Assistant

Streamline Your Workflow in IntelliJ IDEA’s Database Tools With AI Assistant

In IntelliJ IDEA, you can leverage AI Assistant’s capabilities within Database Tools for more efficient data querying and handling. It can significantly speed up SQL query generation, explain code, suggest fixes, and even create tables and populate them with test data on your command! Let’s get star…

Julia Shashkova
Julia Shashkova
Top 10 IntelliJ IDEA Shortcuts for Efficient Data Querying With the Database Tools

Top 10 IntelliJ IDEA Shortcuts for Efficient Data Querying With the Database Tools

Thanks to the dedicated SQL query console inside IntelliJ IDEA Ultimate’s Database Tools, you can easily modify and extract data from any database connected to your Java application without ever leaving the IDE. The query console comes with an SQL statement-specific code snippets library, code compl…

Julia Shashkova
Julia Shashkova

10 Plugins to Enhance Your IntelliJ IDEA Experience in 2024

Even though IntelliJ IDEA is powerful and self-sufficient, we love to customize it a bit with plugins. Why? Because they’re fun! In this blog post, we’ll share a list of cool plugins that will help you liven things up in your IDE. Let’s go! JetBrains AI Assistant AI has touched every indust…

Irina Mariasova
Irina Mariasova

Java Best Practices

Good code follows certain rules, and knowing them increases your chances of success. We’d like to share some Java best practices that will help you on your way. We'll cover the must-know tips and tricks, from broad advice on software development to Java- and project-specific know-how. Let's get star…

Irina Mariasova
Irina Mariasova