Hibernate Community • View topic - Where does the date() function come from

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Where does the date() function come from

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

babicka_baba

Post subject: Where does the date() function come from

Posted: Sat Jul 31, 2010 5:36 am

Newbie

Joined: Sat Jul 31, 2010 4:58 am
Posts: 2

Hibernate version: 3.5.3-Final

DB: Firebird 2.1

Using org.hibernate.dialect.FirebirdDialect, JPA 2.0

I am having a problem with the SQL generated for one of my JPQL queries - here is an excerpt from the where clause:

Code:

date(timestamp_column)<=date_column

This obviously got generated because timestamp_column is annotated @Temporal(TemporalType.Timestamp) while date_column is @Temporal(TemporalType.Date)

The trouble is that Firebird does not understand this syntax, it should be parsed as

Code:

CAST(timestamp_column AS DATE)<=date_column

I thought it is an issue with the dialect and was trying to subclass the FirebirdDialect to override this behaviour. But I could not find any place in the dialect that would be responsible for this concrete piece of SQL. Thought even about doing some regex replacement in Dialect.transformSelectString, but it turns out it does not work as I supposed (ie. it is not called on every query sent to DB)

Does anyone have an idea where does the date() function come from and what can I tweak to get it working?

Thanks a lot
Martin Cerny

Top

babicka_baba

Post subject: Re: Where does the date() function come from

Posted: Sat Jul 31, 2010 6:00 am