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 (f
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