Hibernate version: 3.0 rc1

I am trying to do this in HQL :

allotment.date >= DATE_FORMAT(DATE_ADD( :currentDateTime, INTERVAL supplier_leadtimes HOUR ), '%Y-%m-%d')

the parser barfs saying

org.springframework.orm.hibernate3.HibernateQueryException: unexpected token: supplier_leadtimes

I presume this is because of the INTERVAL keyword - and will also be the case with the HOUR keyword.

Is there anything that I can do with the dialect to support this, or does the parser need to be changed ?

I should mention that this worked in hibernate 2.1.2

You should be able to add a SQLFunctionTemplate to the Dialect.

Make up a HQL function, and have it produce the SQL you want.

Another approach is to define a SQL function in the db.

I can see from

http://cvs.sourceforge.net/viewcvs.py/h ... &view=auto

That I can subclass the Dialect, override the constructor and call



While looking at the mysql dialect, I may have found a bug



shouldn't that be

whoops..

should be

this works

hibernate 3 rocks !


Custom Dialect


Modified HQL


Any chance that something like this can be added to the real mysql dialect ?
[/b]

I fixed the bug in CVS.

I think it will be too much work to add all these kinds of things to the standard dialects, we just need to document that these extensions are possible.

I can see your point.

Maybe there needs to be a dialect project that provides all of the function templates for each specific version of databases.

That way people can just add an extra jar and use all of the custom db functions out of the box.

Hi gavin,

Even in 3.1rc2, date_add function of my sql doesn't work. I used date_add function with hibernate 2.1 and with 3.0.beta4, but in later version hibernate throw exceptions. It may be parser problem.

Currently I'm using date_add_interval with custom dialect, but to my thought i must work correctly without custom dialect.

thanks.