Hey folks,

Our model is mapped using Annotations and we have a persistence.xml file available. I tried to setup the easiest possible configuration as I'm just trying to prototype HQL queries against our database instead of having to deploy them and debug into the SessionFactoryImpl in order to get the syntax of the query correct.

Alas I can't seem to be able to get it to work right. I was getting a cannot locate treecache.xml exception when I attempted the JPA option. So instead I tried to create a basic AnnotationConfiguration.

The configuration has our model project specified which contains all annotated objects.
I created a hibernate.cfg.xml file via the wizard that simplified the connection and looks like the following with deets commented out.

<hibernate-configuration>
<session-factory name="SessionFactory">
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.password">********</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@10.10.8.20:1521:SIDB</property>
<property name="hibernate.connection.username">myusername</property>
<property name="hibernate.default_schema">myschema</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
</session-factory>
</hibernate-configuration>

When I expand the 'hibernate' node it provides three other nodes,
Configuration
SessionFactory
Database

Expanding either the Configuration or SessionFactory tabs do nothing. I would have thought that the SessionFactory node would have then supplied all the classes for which it found annotations?

I can't see what's going on under the hood as I don't know where the output for the Hibernate tools login is and the only info that seems to be printed out in the Plugin perspective relates to errors.

I'm using Ganymede and hibernate 3.2.6.ga.jar

Would anyone have any idea as to why the tool doesn't seem to be picking up the classes? Or even where I can find the tools output log. I found the hibernate-tools.log file in the .plugins folder of the .metadata folder under my home directory but it's empty.

This would be fantastic if we could get this to work as it would save so much time as redeployment and test is no way to prototype a query. Any help greatly appreciated.

Thanks,
Mark.

If your persistence.xml needs a treecache.xml then you need to have that one the classpath. Workaround: don't enable caching when you use it from the tools (doesn't really make sense for query prototyping).

And the difference or rather one of the differences between JPA and Hibernate Annotations is that JPA scans automatically for classes/mappings, Hibernate annotations does not - which explains why you don't see anything.