Query File Config and Generated Code

mlipper · **Posted:** Fri Oct 10, 2003 11:10 am

Howdy,

I'd like to store my queries in a file separate from the class/table *.hbm.xml mappings so they don't get clobbered everytime a I run Middlegen against my schema?

I realize that this is more of an XML issue (elements must start and end w/in the same entity) and/or Middlegen issue, but I'm wondering if this has already been encountered and solved by a good samaritan in the Hibernate communtiy.

Any pointers are much appreciated...

Thanks!

Matt

BTW - Hibernate rocks!

max · **Posted:** Fri Oct 10, 2003 11:36 am

Why don't you just have them in seperate hbm.xml file(s) ?

The definition is

<!ELEMENT hibernate-mapping (meta*, import*, class*, query*)>

so, that is possible.

mlipper · **Posted:** Fri Oct 10, 2003 11:57 am

Yeah, I tried this in hibernate.cfg.xml:

Code:

<hibernate-configuration>

    <session-factory>
        ...
        <property name="show_sql">true</property>        
        ...
        <mapping resource="example/MyClass.hbm.xml"/>
        ...
        <mapping resource="query.hbm.xml"/>

    </session-factory>

</hibernate-configuration>

and this in query.cfg.xml:

Code:

<hibernate-mapping>

<query name="example.MyClass.select.all">
    from example.MyClass as myClass
</query>

</hibernate-mapping>

But the XML parser complains:

Code:

org.dom4j.DocumentException: Error on line 65 of document  : XML document structures must start and end within the same entity. Nested exception: XML document structures must start and end within the same entity.
   at org.dom4j.io.SAXReader.read(SAXReader.java:355)
   at net.sf.hibernate.cfg.Configuration.addInputStream(Configuration.java:252)
   at net.sf.hibernate.cfg.Configuration.addResource(Configuration.java:273)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:841)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:792)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:732)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:719)
   at com.abp.nl.fi.SimpleTest.initHibernate(SimpleTest.java:192)
   at com.abp.nl.fi.SimpleTest.<init>(SimpleTest.java:29)
   at com.abp.nl.fi.SimpleTest.main(SimpleTest.java:34)
Nested exception: 
org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
   at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
   at org.dom4j.io.SAXReader.read(SAXReader.java:339)
   at net.sf.hibernate.cfg.Configuration.addInputStream(Configuration.java:252)
   at net.sf.hibernate.cfg.Configuration.addResource(Configuration.java:273)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:841)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:792)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:732)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:719)
   at com.abp.nl.fi.SimpleTest.initHibernate(SimpleTest.java:192)
   at com.abp.nl.fi.SimpleTest.<init>(SimpleTest.java:29)
   at com.abp.nl.fi.SimpleTest.main(SimpleTest.java:34)
rethrown as net.sf.hibernate.MappingException: Error on line 65 of document  : XML document structures must start and end within the same entity. Nested exception: XML document structures must start and end within the same entity.
   at net.sf.hibernate.cfg.Configuration.addInputStream(Configuration.java:260)
   at net.sf.hibernate.cfg.Configuration.addResource(Configuration.java:273)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:841)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:792)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:732)
   at net.sf.hibernate.cfg.Configuration.configure(Configuration.java:719)
   at com.abp.nl.fi.SimpleTest.initHibernate(SimpleTest.java:192)
   at com.abp.nl.fi.SimpleTest.<init>(SimpleTest.java:29)
   at com.abp.nl.fi.SimpleTest.main(SimpleTest.java:34)
Caused by: org.dom4j.DocumentException: Error on line 65 of document  : XML document structures must start and end within the same entity. Nested exception: XML document structures must start and end within the same entity.
   at org.dom4j.io.SAXReader.read(SAXReader.java:355)
   at net.sf.hibernate.cfg.Configuration.addInputStream(Configuration.java:252)
   ... 8 more
Exception in thread "main" 

max · **Posted:** Sat Oct 11, 2003 6:43 am

eh ? that's sounds like a mistype somewhere!

I can see one: query.hbm.xml in the code, but query.cfg.xml in the text ? error ?

What happen if you just add query.hbm.xml via code instead ?

david · **Posted:** Sat Oct 11, 2003 7:40 am

I suppose I can add this option to the enhancement list of Middlegen.

mlipper · **Posted:** Mon Oct 13, 2003 10:07 am

Max,

The typo was actually just in my post and the file is located correctly. The error occurs as the file's being parsed.

David,

I would offer to help, but ATM my newbie-ness to Hibernate/Middlegen and a lack of time, combine to make me somewhat useless; although, I'm glad to give it a shot...

Thanks, everyone, for your help!

Matt