« Smart WebBeans Event Model Navigation in Maia
Generating Persistence Mappings from Database Schema »

HQL Console with Pure JPA Facets

March 18th, 2009 by Gregory Shrago

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).

Tags: , , ,

This entry was posted on Wednesday, March 18th, 2009 at 10:44 am and is filed under How-To's, Tips & Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

2 Responses to “HQL Console with Pure JPA Facets”

  1. Sigmund Lundgren Says:
    October 16th, 2009 at 6:08 am

    What if the entitymanagerfactory (JPA) is Spring configured? How to make the HQL console work?

    persistence.xml only contains an empty PU def with RESOURCE_LOCAL.

  2. Gregory Shrago Says:
    October 19th, 2009 at 10:00 am

    Currently only Hibernate LocalSessionFactoryBean/AnnotationSessionFactoryBean are supported by SpringHibernateIntegration plugin.
    Actually you are the first person to ask this question.

    Vote for: http://youtrack.jetbrains.net/issue/IDEADEV-40904

    As a workaround configure the empty PU to contain all the required mappings, map it to a DataSource with valid JDBC parameters (driver/url/password) and use it to run console as if spring configuration doesn’t exist.

Leave a Reply