@NativeQuery overwritten on ReverseEngineer

guurk · **Joined:** Mon Jun 12, 2006 4:59 pm **Posts:** 13

Hibernate version: 3.2

Mapping documents: N/A

Code between sessionFactory.openSession() and session.close(): N/A

Full stack trace of any exception that occurs: N/A

Name and version of the database you are using: N/A

The generated SQL (show_sql=true): N/A

Debug level Hibernate log excerpt: N/A

This must be a configuration issue or simply something that is not yet supported.

I'm using the Reverse Engineering abilities of Tools to create EJB3 based POJOs.

I also wish to define @NamedQuerys within the POJOs, however, when I rerun the Reverse Engineering, the Query definitions get deleted.

Are there suggestions on how to work around that?

My thoughts were to include them all at the package level somewhere, but there isn't any way that I've found to specify a different file for the AnnotationConfiguration to find the @NamedQuery definitions alternatly than from having them within the mapped POJOs.

max · **Posted:** Mon Jun 12, 2006 7:43 pm

currently we generate a complete file and overwrite whatever is output directory.

To do what you want we would need to use something like jmerge which unforunately does not support jdk5/annotations syntax yet ;(
Then we could support merge of generated and hand written java files.

But that is still and outstanding issue.

a workaround is to put your named queries in a orm.xml if you are using ejb3 or add a hbm.xml file with the queries if you "just" uses the hibernate3 api.

guurk · **Joined:** Mon Jun 12, 2006 4:59 pm **Posts:** 13

I appreciate your reply.

I'm interested in the xml files that you mentioned.

Yes, I'm using ejb3 (you can tell by the annotations.)

This is also a stand-alone application (at least initially) so there is really no place for a META-INF/orm.xml file.

guurk · **Joined:** Mon Jun 12, 2006 4:59 pm **Posts:** 13

Never mind. Thank you for your help. I got it working just fine.

In my orm.xml I place the named query.

Code:

<named-query name="Link.findAll">
   <query>select l from Link l</query>
</named-query>

Then I load the orm.xml file as a resource

Code:

AnnotationConfiguration ac = new AnnotationConfiguration();
   ac.configure();
   ac.addResource( "org/test/orm.xml");

This works great! Thanks!

max · **Posted:** Tue Jun 13, 2006 3:15 pm

i don't understand why META-INF/orm.xml isn't possible to use for you?