Hibernate Community • View topic - Hibernate Doesn't Treats SQL Server Dateparts as Keywords

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Hibernate Doesn't Treats SQL Server Dateparts as Keywords

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

tomwnorton

Post subject: Hibernate Doesn't Treats SQL Server Dateparts as Keywords

Posted: Mon Apr 02, 2012 10:51 am

Newbie

Joined: Mon Apr 02, 2012 10:20 am
Posts: 1

We have an entity formula that requires today's date at midnight in order to calculate itself properly.

Code:

DATEADD(DD, DATEDIFF(DD, 0, GETDATE()), 0)

Hibernate transforms this into:

Code:

DATEADD(mytablename0_.DD, DATEDIFF(mytablename0_.DD, 0, GETDATE()), 0)

I have tried both Day and DD. I have double checked that my dialect is SQLServerDialect. I have also tried to trick hibernate into doing it correctly by setting

Code:

hibernate.query.substitutions

Code:

Day=DD

Is there any way to get hibernate to treat either Day or DD as a keyword?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum