Let’s rewrite the previous query to get employees by emp_number using the. All code in this tutorial can be found in this GitHub repository. Modify both the field names of entities and the corresponding field names in the Entity View JPAB-2545. JPA Buddy provides a clear. g. 1. 3, and bring you a handpicked selection of engaging events, tutorials, talks, and opinions from. Lập trình Fullstack: Spring Boot + React playlist Page: (data transfer object) is an object that carries data between processes. In Project Structure (Ctrl-Shift-Alt-S), you'll see a list of modules. It works as an addition to your IntelliJ IDEA enabling a number of JPA-related features. JPA Buddy is an IntelliJ IDEA plugin that helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and. #jpa #hibernate #intellijidea #java #jpabuddy #reverseengineereing #springdata #flyway #mapstruct #restIn this video, we will use JPA Buddy and IntelliJ IDEA. *-221, JPA Buddy provides free and paid functionality. However, i just noticed, that JPA Buddy highliths it and suggest to replace. JPA Buddy is trusted by hundreds of thousands of Java/Kotlin developers, including Java Rock Stars and Champions. Learn how to build data centric Spring Boot applications with JPA Buddy and IntelliJ IDEA Ultimate faster than ever. Its first release was almost twenty. JPA Buddy provides an easy start for new developers and speeds up the development process for more experienced ones. Update JPA entity according to new requirements. 1. JPA Support in IntelliJ IDEA and Eclipse. Because of this automatic management, the only statements allowed by JPA are SELECT, UPDATE and DELETE. TypedQuery. Just don't forget. This plugin helps you work with JPA and related technologies inside IntelliJ IDEA. 1. However, there are still significant improvements, and you have the opportunity to test them in the latest EAP build before the major release. As you may guess its data layer is built over JPA; its tooling, Jmix Studio, provides great. #jpa #intellijidea #java #kotlin #jpabuddy #springdataJPA Buddy provides various ways to create repositories to make working with JPA-related objects more co. Click Generate. 2) Select Add JAR/Folder. . Once we need to store large text in the database, we can start with defining a LOB column. The reference implementation for JPA is EclipseLink. Note that JPA facet must be linked to. Press Ctrl Alt 0S to open the IDE settings and then select Plugins. 5. 3) Browse to C:Program FilesJavajdk1. 2 (ETA is April 2022) diff scripts generation comparing JPA entities with DB will be available in the commercial subscription. @Entity @Table (name = "collar") @IdClass (CollarId. In this tutorial, we’ll have a look at some supporting tools for JPA. We're excited to announce our first major release of the year! This new version comes with a lot of improvements, including: Improved DTO Generator and Coding Assistance features. 1. Let’s start by creating a dynamic class by subclassing an existing class. JPA Buddy Tool Windows. Positioned as powerful plugins for working with JPA data and React applications, respectively, they will offer even more functionality for IntelliJ IDEA and WebStorm developers moving forward. #jpa #hibernate #eclipselink #intellijidea #java #kotlin #jpabuddy JPA lifecycle events are useful when you need to set default values or update audit fields. PyCharm Professional. Getting familiar with version control systems (VCS) can be very time-consuming, so to make this process quicker and more convenient for you Dmitriy Smirnov has prepared a step-by-step guide on how to work with a VCS in IntelliJ IDEA. #jpa #hibernate #intellijidea #java #kotlin #jpabuddy #liquibase #database Diff & Init Liquibase changelog generation are extremely useful features that save. If the Java installation has been done properly, then it will display the current version and specification of. 4 - 2023-04-10 Bug-fix. In this video, we'll explore a few Hibernate and JPA features in IntelliJ IDEA Ultimate. An EntityManager instance is associated with a persistence context. Provides visual tools for generating JPA entities, Spring Data JPA repositories, Liquibase changelogs and SQL scripts. JPA and React Plugins: From Buddies To Full Members of The JetBrains Family We are excited to announce that JPA Buddy and React Buddy have joined the JetBrains family. Surface Studio vs iMac – Which Should You Pick? 5 Ways to Connect Wireless Headphones to TV. The JPA console input pane opens as a separate tab where you can write and execute JPQL queries. JPA Buddy is an advanced plugin for IntelliJ IDEA intended to simplify and accelerate everything related to JPA and surrounding mainstream technology. It also guides both kinds of developers to follow the best practices of working with JPA. I'd recommend using JPA Buddy plugin for that, it can generate changelogs by comparing your Java model to your current database, here is how it looks. sql" file which you can run on your database server. Checkout the feature branch. 5. This improvement has significantly enhanced the performance of the "JPA Entities from Database" action. . Improved Spring Audit support for smoother and more effortless usage. In this tutorial we will demonstrate one interesting plugin called jpa-buddy okay alright . #jpa #hibernate #springdata #crud #rest #postgresql #intellij The video demonstrates the features of JPA Buddy by creating a simple CRUD application from scratch within a few minutes upon the mainstream stack: — Spring Boot — Spring Data. How to generate Spring Data JPA Repositories | JPA Buddy. To create the database, we will use Docker. JPA Buddy lets you create callbacks in both SQL and Java/Kotlin: Flyway also allows you to create migrations in Java or Kotlin, which are much more flexible than regular SQL. Each JPA Buddy release gets issued for the two latest stable versions of IntelliJ IDEA. 12. gradle file: compile net. As for IntelliJ IDEA 2023. 5 -. Ближайшая конференция: JPoint 2023, 12–13 апреля (Online), 18–19 апреля (Offline)Подробности и билеты:. You can even generate repositories for a bunch of entities at once. When I right click and select "Entities from DB" it correctly connects to my MySQL Database, and it succesfully performs the introspection, so that I can see the list of tables from the IntelliJ side view. JPA Buddy will create and configure another DB connection with the parameters as described above. Powered by world’s most popular Java IDE. 1. JPA Buddy is a free IntelliJ plugin. JPA Buddy is an IntelliJ IDEA plugin that helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and. Previous Next. If you use gradle, applying the kotlin-jpa plugin is enough to generate default constructors for classes annotated with @Entity: buildscript { dependencies { classpath "org. JPA Buddy is an advanced plugin for IntelliJ IDEA intended to simplify and accelerate everything related to JPA and surrounding mainstream technology. We'll create a simple Spring Boot application using IntelliJ IDEA Ultimate to take advantage of its Spring feature. 0. Support all databases. JPA Buddy provides a clear UI for generating repositories, projections, queries, etc. 1. Overview. Now, JPA Buddy properly handles @PrimaryKeyJoinColumn annotation in a parent class for Liquibase diff generator JPAB-2147; Fixed an. New Livestream: JPA Buddy – From Zero to Hero. JPA Buddy is now available for IntelliJ IDEA 2022. 0:3306 user@server -N # 13306 your machine local port # 3306 server remote port. What's new in JPA Buddy 2023. 1. JPA Buddy – From Zero to Hero Java Annotated. Installation Guide § What is JPA Buddy? JPA Buddy is an IntelliJ IDEA plugin that helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and other related technologies in both Java and Kotlin. Here’s the Q&A follow-up. JPA Buddy. Common JPA Buddy intentions and actions are now available in "Actions" dropdown in JPA Inspector and via line markers in IDEA Ultimate JPAB-725; Improved performance of:. Go to the terminal where you are running Quarkus in Dev Mode. Check it out! Useful Shortcuts to Boost Your Productivity with IntelliJ IDEA and JPA Buddy. Unsupported Products. Positioned as powerful plugins for working with JPA data and React. Start typing Insert and choose it. The @Entity annotation indicates that the Customer class is a JPA entity that should translate into the corresponding table in the database. JPA can’t deduce what the Query result type will be, and, as a result, we have to cast. 2. Even though IntelliJ IDEA allows you to create a data source without specifying a target schema or even a database, JPA Buddy can only get data from an explicitly specified connection string. Multiple 1:many relationship in Hibernate. . Entity Graph is a popular method for optimizing JPA join queries. 1 — 2023. JPA Buddy is an IntelliJ IDEA plugin that helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and. yml file but when i start server, none. In this Spring Boot video tutorial, you will learn how to use IntelliJ IDEA for developing a Java web application based on Spring framework in which you will learn to implement the User module with CRUD operations (Create, Retrieve, Update. These dependencies enable you to use JPA Buddy’s functionalities with Flyway and access a PostgresSQL database. The new major release of JPA Buddy is out! The 2022. Java is a great language, but it can sometimes get too verbose for common tasks we have to do in our code or compliance with some framework practices. . Starting with JPA Buddy 2022. . So if your DB is empty, you'll get a changelog that describes your whole model. Jakarta Persistence is the new name for the Java Persistence. Android Studio — Hedgehog | 2023. I've come to realize perhaps I don't quite understand how it works in Java (I am using IntelliJ), even though I understood the concept of it. Just don't forget to refresh it when the database gets changed (2). JPA Buddy is an advanced IntelliJ IDEA plugin intended to accelerate and simplify using JPA and related tech: Hibernate, Spring Data JPA, Liquibase, Flyway. A vast set of code generation actions available via hotkeys and quick-fixes. . In this tutorial, I’ll use the latest. 0 (ETA is January 17, 2022) diff scripts generation comparing JPA entities with DB will be available in the commercial subscription. For MySQL, you need to explicitly specify the schema name in the connection string to make JPA Buddy work. Even though IntelliJ IDEA allows you to create a data source without specifying a target schema or even a database, JPA Buddy can only get data from an explicitly specified connection string. Blaze Persistence Support. Now, JPA Buddy can migrate database comments using the @Comment annotation from Hibernate or Java Doc JPAB-1268; JPA Buddy now seamlessly integrates with IntelliJ IDEA Ultimate to read information from the database. To view and edit data of a database object, open Data editor and viewer by double-clicking. JPA Buddy makes this process much easier for new Java developers and faster for experienced developers. Join us for the new IntelliJ IDEA LiveStream episode with Marco Behler to learn about JPA Buddy’s functionality. In this blog, we’re going to look at how to create a simple JPA application in IntelliJ IDEA Ultimate. 4,539,369 downloads. Use visual designers and rich code generation capabilities to make it easier to work with Hibernate, EclipseLink. 4631 — 213. IntelliJ IDEA Community — 2022. This will create an "init-schema. Smart completions from JPA Buddy no longer appear before most suited IntelliJ IDEA options JPAB-2239. Create a Spring Data repository for CRUD operations. Instead of using query parameters, we could’ve used literals, although that’s not the recommended way to do it, as we’ll see now. . It is enable a new menu JPA. In this tutorial, we’ll learn about the basics of entities, along with various annotations that define and customize an entity in JPA. It greatly simplifies the data fetch process for many cases. #jpa #hibernate #eclipselink #intellijidea #java #kotlin #jpabuddy JPA lifecycle events are useful when you need to set default values or update audit fields. Starting with JPA Buddy 7. If you are using IntelliJ Idea's newer version (2022 or so) and not able to find the option in step 3 "Generate by Database Schema" in the accepted answer above then use the following:Step 1: Create DataSource (as you create for database in Idea) Step 2: Add JPA Hibernate Facet through File -> Project Structure ->Facets Step 3: Generate. JPA Buddy no longer skips columns from the @Embedded attribute of @MappedSuperclass type JPAB-2247. The feature remains free for academic use. 2 - 2022-20-12. Open the JPA console. 1 RC 2. In fact, you can develop. 2. 19 followers LondonBlaze Persistence Support. . Smart completions from JPA Buddy no longer appear before most suited IntelliJ IDEA options JPAB-2239. Subscribe to receive demos, tutorials and new features highlightings. The code and presentation used in this live stream by the speaker can be accessed using this link. We'll keep all the fields selected and click OK. 9 implies that JPA Buddy really simplifies the lives of. JPA Buddy is a plugin for IntelliJ IDEA that makes working with JPA and related technologies easier. We are excited to announce that JPA Buddy and React Buddy have joined the JetBrains family. You will see how to generate JPA entities and Spring Data repositories, create DTOs and MapStruct mappers in a couple of minutes and write Liquibase/Flyway scripts in a. . Bug-fix. xml is called the root of the persistence unit. Mark them with @Id. 2023. 1. Choose either Gradle or Maven and the language you want to use. Effectively, this means that getting stuck with some specific version of IntelliJ IDEA, you will not be able to get more than 2 feature updates of. This second step creates a Reactive Spring Java client that connects to a REST service that’s streaming stock prices once a second. 1 — 2023. Entities in JPA are nothing but POJOs representing data that can be persisted in the database. 4. Currently supported languages are English, 简体中文. . #jpa #hibernate #eclipselink #intellijidea #java #kotlin #jpabuddy JPA Buddy is an IntelliJ. Thanks to the JPA Buddy team for the great tool that makes Hibernate even closer to developers. Select the Liquibase icon in JPA Structure to invoke the Liquibase Update wizard. 2. * Android Studio. Jmix Framework Version: 1. Follow edited Mar 9 at 13:27. Now, JPA Buddy allows you to. 2023. Ivan Molero. java and select Run File from the right-click menu. . 5 version brings new features, improvements, and bug fixes. In this tutorial we will demonstrate one interesting plugin called jpa-buddy okay alright . Also JPA facet must be configured for the module (with set JPA configuration file and JPA Provided). Insert four employees into the database. What is Lombok library? How is it useful for JPA, and how can it harm? Lombok is a library targeted to replacing boilerplate code writing with annotations and bytecode instrumentation. The Spring Boot project is intended to make creating Spring applications much faster and easier. 3. Open the JPA console. The Spring Data JPA EntityGraph library adds significant value by enabling the reuse of different entity graphs in the same query method in repositories as well as creating entity graphs at run-time. Add Spring Data JPA dependency. Aqua — build 223. , differential migration scripts generation. JPA Buddy is an IntelliJ IDEA plugin that helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and. The 2022. . Now I need to generate entity classes and tables too. JpaTest. JPA bao gồm gần như mọi khía cạnh giao tiếp giữa cơ sở dữ liệu và ứng dụng Java, được tích hợp vào tất cả framework chính. This improvement has significantly enhanced the performance of the "JPA Entities from Database" action. sql in the resources folder. 3. I can't find Persistence in the list. JPA tutorial provides basic and advanced concepts of Java Persistence API. Nếu sử dụng Intellij, JPA Buddy sẽ rất hữu ích cho bạn. 5. #jpa #intellijidea #java #kotlin #jpabuddy #springdata JPA Buddy provides various ways to create repositories to make working with JPA-related objects more convenient for most users. . ClassCastException no longer appears while generating Kotlin data class as DTO from the Java entity JPAB-2128. . 1. 3. 3. Visit Spring Initializr’s Website. Copy snippet. . Here are the 7 useful plugins that you can use in your JetBrains IDE to make your life easier and more fun. JPA Buddy Tool Windows. This is why we introduced a number of code inspections for Lombok to JPA Buddy. Choose the public schema as your DB connection to see your tables, then tick the post table. 1. Clicking it will allow you to add various facets to existing modules. Code Demonstration – Using SceneBuilder in IntelliJ IDEA. Alternatively, you can click in the toolbar or press Ctrl Shift F10. All we need to do is mark the docText attribute with the @Lob annotation. Tutorials. Fixed incorrect display of the "DB Type Selection" wizard for IntelliJ IDEA EAP 2022. This plugin helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and other related technologies in both Java and Kotlin. Rainbow-CSV. 4. You can do it directly from the "Enable Minimalistic Mode" window, by clicking on the "Add keyboard shortcut": Or via preferences. 6 JPA Buddy Version: 2022. Better support for new Hibernate 6 features. gradle file: compile net. JPA Buddy provides an easy start for new developers and speeds up the development process for more experienced ones. 2. My project is a SpringBoot application, and my database is a postgresql database. A few months ago we published a video on how IntelliJ IDEA integrates with Gradle. In this tutorial, we’ll learn about the basics of entities, along with various annotations that define and customize an entity in JPA. Fewer strings, more. 4. Creating a Java Class at Runtime. . How to generate Spring Data JPA Repositories | JPA Buddy. Step1: Verify your Java Installation. Generate a Spring Data JPA repository for the Entity View JPAB-2544. In this guide, you will use JPA Buddy’s features to create a simple blog application, generate and manage DTOs, keep them in sync with your entities and create MapStruct mappers. . Logging with sl4j — @sl4jMost loved features. 4. #jpa #hibernate #eclipselink #intellijidea #java #kotlin #jpabuddy #database #liquibase #sql #json #yaml #xmlJPA Buddy is an IntelliJ IDEA plugin that helps. I usually use this plugin to be able to quickly generate my. 00:00 - Intro00:27 - Creating a Hibernate/JPA Project01:37 - Creati. We can achieve this by using a plugin for IntelliJ IDEA called JPA Buddy. For starters you to lay the groundwork for building the CRUD application, for that create a Spring Boot application using Spring Initializr. To enable JPA in a Spring Boot application, we need the spring-boot-starter and spring-boot-starter-data-jpa. opened my git repo in itellij 2021. 0 application and use EclipseLink as my provider. Press d to access the Quarkus Dev UI, shown in Figure 1. Java Tutorials & Tips. Spring Data JPA is a powerful framework that allows users to easily interact with their database while minimizing boilerplate code. The @Id annotation indicates that the id field is the object's ID. 5 - 2022-31-10. Persistence units are defined by the persistence. Unsupported Products. 525 5 5 silver badges 6 6 bronze badges. Create the project. To download SQLite database software, refer to the official software downloads. WebStorm )やチームツールはプラグインにより拡張することが可能です。. This plugin helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and other related technologies in both Java and Kotlin. 3 JPAB-2090. We hope the paid features are useful and bring enough value in exchange for a couple of dollars. Password. Now, JPA Buddy can migrate database comments using the @Comment annotation from Hibernate or Java Doc JPAB-1268; JPA Buddy now seamlessly integrates with IntelliJ IDEA Ultimate to read information from the database. 1 — 2023. * Android Studio — Dolphin | 2021. At that point you will see the Persistence option in "View --> Tool Windows --> Persistence". Hibernate is one of the most popular Java ORM frameworks in use today. IntelliJ IDEA inspections is a cool thing that helps to catch errors in advance. Default annotation from Lombok JPAB-2451; The @IdClass annotation is now considered while generating Spring Data JPA repositories JPAB-2435; JPA Buddy no longer generates redundant getters/setters while performing "Extract to. To verify this, execute any of the following two commands depending on the platform you are working on. If you want to create your new applications using the new jakarta namespace, checkout Creating a Simple Jakarta Persistence Application video or blog post. For more information about working with database objects in IntelliJ IDEA, refer to Database objects. You can now define the ID generation strategy for each entity right from the "Entities from DB" wizard JPAB-1501. You will. Open Preferences -> Keymap -> type JPA Inspector Popup and set your desired combination. Aqua — build 231. JPA provides the @Embeddable annotation to declare that a class will be embedded by other entities. But it is also useful to keep your evolving model and your changelogs in sync. In this article, we will try to replace Spring Data JPA and see what affects the code apart from API changes due. JPA Buddy is an IntelliJ IDEA plugin that helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct, and. JPA Buddy provides the following tool windows: JPA Structure (1); JPA Palette (2); JPA Inspector (3); You can customize the appearance of the panel in the designer settings. #jpa #hibernate #eclipselink #intellijidea #java #kotlin #jpabuddy #database #reverseengineereing Bulk entities generation from exiting DB. docker run --rm --name postgres-db -e POSTGRES_PASSWORD=password -e POSTGRES_DB=tutorial -p 5432:5432 -d postgres:13-alpine. This article shows the most common issues you may face using Lombok with JPA entities. 2. In this video, we'll use IntelliJ IDEA Ultimate, Swagger Codegen, and JPA Buddy to build a fully working Spring Boot application based on the OpenAPI specification file. 8 currently). In this tutorial, we’ll learn how to generate and export our database schema based on the entity models from our code. I think you need the install the JPA Buddy plugin to see something in the right panel. In this tutorial, we will learn how to use IntelliJ to debug your Java Streams and gain insight into the intermediate operations of a Stream. Now, JPA Buddy can migrate database comments using the @Comment annotation from Hibernate or Java Doc JPAB-1268; JPA Buddy now seamlessly. It helps learn best practices and immensely accelerates. Hibernate Validator provides data validation for our entities. Describe the bug （描述这个Bug） idea ce 启动时, 提示jpa插件异常 Expected behavior （期望的行为） A clear and concise description of what you expected to happen. 3 JPAB-2090; ClassCastException no longer appears while generating Kotlin data class as DTO from the Java entity JPAB-2128; Fixed MethodInvocationException for the case when owning entity does not have a column annotation for the id attribute JPAB-2136; 2022. Explore project structure with the Dependency Matrix. 2. Everyone knows "Extract Superclass" refactoring in IntelliJ IDEA. To use the Spring Initializr to create the project, use a browser to visit Select your Spring Boot level (default is 2. Then you can make JPA Console available after associating your persistence unit with the corresponding data. This often doesn’t bring any real value to the business side of our programs, and that’s where Lombok comes in to make us more productive. psi. Ultimate users can access all paid features without the JPA Buddy license; Fixed inappropriate behavior of DTO creation dialog JPAB-2656, JPAB-2653 New actions for @OnDelete annotation from Hibernate 6. In addition to the core aspects, we’ll also look at more advanced. It also guides both kinds of developers to follow the best practices of. Our JPA tutorial is designed for beginners and professionals. To enable those features, your project should contain dependencies mentioned in the Installation Guide. Introduction. Visit Spring Initializr’s Website. For a step-by-step introduction. 2270 — 222. In this video we’ll build the application from scratch. The plugin is intended to: – Lower barrier to entry into. In the Persistence tool window, select appropriate node. DTOs for JPA entities generally contain a subset of entity attributes. We can even use hbm2dd for generation, but modern tools like JPA Buddy allow us to generate update scripts by comparing the JPA model and database. Moritz Ringler. 3 — 2022. Search Spring Data Jpa Tutorial 4 Create And Setup The Spring Boot Project In Intellij Idea buy items, solutions, and more in your community area. JPA Buddy is an IntelliJ IDEA plugin that helps developers work efficiently with Hibernate, EclipseLink, Spring Data JPA, Flyway, Liquibase, Lombok, MapStruct,. 2. The @GeneratedValue tells JPA that the ID should. we have scoured the web to bring you the most interesting and informative articles, tutorials, and videos on Java and other technologies. . JPA is a specification and several implementations are available. Refactoring of entity fields associated with DTO. microsoft. @Embedded. xml configuration file. Click on the + button. Default annotation from Lombok JPAB-2451; The @IdClass annotation is now considered while generating Spring Data JPA repositories JPAB-2435; JPA Buddy no longer generates redundant getters/setters while performing "Extract to. The plugin is top rated at the JetBrains. Avoid Repetitive Code. For a step-by-step introduction to setting up the Spring context using Java-based configuration and the basic Maven pom for the project, see this article. Option 1: Create your new applications using the new jakarta namespace. In this section, we will tell you how features available in IntelliJ IDEA Ultimate Edition help developers accelerate the development process and save a lot of time from routine work. You will see how to generate JPA entities and Spring Data repositories, create DTOs and MapStruct mappers in a couple of minutes and write Liquibase/Flyway scripts in a. While it has a freemium model, the free version includes most of the features. . There are a few features available only for IntelliJ IDEA Ultimate Edition subscribers. #jpa #hibernate #eclipselink #intellijidea #java #kotlin #jpabuddy #springdata #dto #springSometimes you only need a subset of columns from a table. Bug-fix. This tutorial provides you the basic understanding of Persistence (storing the copy of database object into temporary memory), and we will learn the understanding of JAVA Persistence API (JPA). We are excited to announce that JPA Buddy and React Buddy have joined the JetBrains family. Thanks to all members of the community who are helping us to make JPA Buddy better! Fixed bug with: java. JPA Buddy now supports Blaze Persistence and can help you with the following: Create an Entity View for any entity JPAB-2543. You should make sure that you hit button refresh tables. Global settings apply to all projects that you open with a specific installation or version of. We welcomed JPA Buddy to the JetBrains Marketplace two and a half years ago. The JPA console input pane opens as a separate tab where you can write and execute JPQL queries.