Hibernate not supporting DATE_ADD function using mysql

chandrashekhar · **Posted:** Tue Jul 01, 2008 2:24 am

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.x

Mapping documents:

DATE_FORMAT(curdate(),'%Y-%m-%d') > date_add('2008-07-01', INTERVAL 6 MONTH)

11:46:44,734 ERROR [PARSER:33] <AST>:1:359: unexpected AST node: :

MYSQL v5.23

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

rachasatish · **Posted:** Wed Jul 02, 2008 10:54 pm

Hi Chandra,
Try using hibernate dielect Mapping

check this url for example

http://technosatish.blogspot.com/2008/07/hibernate-dielect-example.html