New Live Stream: Testcontainers – From Zero to Hero
Register now and join us for our next IntelliJ IDEA Live Stream of Testcontainers: From Zero to Hero. In this live stream, Marco Behler, Developer Advocate @JetBrains, will help you get started with Testcontainers for your integration, or UI tests, using your favorite IDE, IntelliJ IDEA. Day: Wednesday Date: Aug 18, 2021 Time: 5:00 pm – 6:00 pm CEST (more…)
Manage Your Database Schema in IntelliJ IDEA 12
As you know, IntelliJ IDEA provides built-in database tools with support for many SQL dialects, such as Oracle, PostgreSQL, MySQL, Microsoft SQL Server and others. A while ago we shared this video with a quick overview of how to set up a connection to a database, use smart completion (even for SQL queries within Java), on-the-fly code analysis, navigation (between queries and database), search (for tables and fields), and more cool features. Now, please enjoy a new video with even more exciting features available in IntelliJ IDEA 12 for working with databases: (more…)
Find Table/Column Usages Searches Database Schema
In IDEA 10.5 "Find Usages" (Alt-F7) results for tables and columns include database schema usages, i.e. references in indices, primary and foreign keys, see screenshot below: Develop with pleasure!
Generate Persistence Mappings by Database Schema
The upcoming IntelliJ IDEA 8.1.1 includes a new option to generate separate XML mapping per entity.
Generating Persistence Mappings from Database Schema
With IntelliJ IDEA you can quickly generate persistence mappings from any database schema. This feature is not so easy to find, so here's the tip:
HQL Console with Pure JPA Facets
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 d