3.0:

I'm trying to use the "<=:" and ">=" signs in my following query.

<query name="findProduct">
from Inventory c where
c.companyCode = :companyCode and
c.productType=:productType and
c.Id = :Id and
c.cucDealer = :cucDealer and
c.creationTimeStamp >=:startCreationTimeStamp and
c.creationTimeStamp <=:endCreationTimeStamp
</query>



">=" works fine but for "<=" Hibernate gives me a DOM syntax exception. Following is a part of the stack trace.

org.dom4j.DocumentException: Error on line 86 of document : The content of elements must consist of well-formed character data or markup. Nested exception: The content of elements must consist of well-formed character data or markup.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.hibernate.cfg.Configuration.addInputStream


The syntax error disappears if I remove the "<=".

And I'm using hibernate with Spring.

Any ideas ??

Thanks in advance.

Vikas

I still can't make the "<=" work. But my query works fine if I use "between". Like this:

<query name="findProduct">
from Inventory c where
c.companyCode = :companyCode and
c.productType=:productType and
c.Id = :Id and
c.cucDealer = :cucDealer and
c.creationTimeStamp between :startCreationTimeStamp and
:endCreationTimeStamp
</query>


Thanks,
Vikas

you need to put your query inside a CDATA block: