How to configure Hibernate Tools HQL editor in Eclipse with a custom NamingStrategy

java eclipse ide jboss-tools hibernate-tools
digitaljoel picture digitaljoel · Mar 18, 2009 · Viewed 21.6k times · Source

I've installed Hibernate Tools 3.2.4.GA in Eclipse Ganymede. The main driver for installing it was to be able to issue HQL queries interactively.

I have configured all of our mapping files, hibernate.properties, etc. and it shows all of our entities and mappings and is able to read a list of tables from the database. It doesn't appear to use the custom naming strategy I specified in the configuration and therefore I can't query anything. The query in the Dynamic SQL Preview is correct except for table names.

The way I configured the naming strategy was to right click the hibernate configuration and select 'edit configuration' In the 'Options' tab I 'browse' for a Naming strategy. Eclipse is able to find the naming strategy and auto-complete it for me, which would indicate it is in the classpath. I then hit OK and still have problems.

Am I missing something in the naming strategy configuration for hibernate tools (now jboss tools it would appear) or is it broken?

Optionally, is there another tool that I could use (in or out of eclipse) to issue HQL statements against my database and be able to see the results?

UPDATE The problem was in the NamingStrategy implementation. It prepends a string to the front of every table, and changes camel case to all lower case with underscores. Unfortunately, in the implementation, the string is injected via spring, and there is no default set. That spring injection wasn't happening in hibernate tools, and because there was no default, the string was empty. It has been changed to have a default ( which matches our current spring configuration ) and it is working now.

Answer

Ali Abdel-Aziz picture Ali Abdel-Aziz · Apr 15, 2009

I didn't use Hibernate Tools in Eclipse. But here is an alternative solution to issue HQL statements against your database.

there is tool called HQE Hibernate Query Editor. Hibernate Query Editor (HQE) is a simple application designed to make easy the work of writting HQL/SQL queries for Hibernate. It has simple features like syntax highlight and other editing stuff.

more information about HQE can be found here https://hqe.dev.java.net/

Related questions

How to configure Eclipse build path to use Maven dependencies?

I would like to take advantage of the features that Maven provides for managing dependencies in a project. My brief understanding of how Maven works is that it will aquire the JARs needed and then build the project with these …

Read More
Eclipse/Java code completion not working

I've downloaded, unzipped and setup Eclipse 3.4.2 with some plugins (noteable, EPIC, Clearcase, QuantumDB, MisterQ). Now I find when I'm editing Java projects the code completion is not working. If I type String. and press ctrl+space a popup shows "No …

Read More
Things possible in IntelliJ that aren't possible in Eclipse?

I have heard from people who have switched either way and who swear by the one or the other. Being a huge Eclipse fan but having not had the time to try out IntelliJ, I am interested in hearing from …

Read More