Hibernate Community • View topic - Error in Formula parsing

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Error in Formula parsing

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

antoska

Post subject: Error in Formula parsing

Posted: Wed Jun 13, 2007 10:57 am

Beginner

Joined: Wed May 03, 2006 5:10 am
Posts: 32
Location: Monopoli - Italy

I'm having some problems creating computed properties using the FORMULA attribute of the Property element.

I have the following class:

Code:

  <class name="ObjectModel.Asset.AssetBase, ObjectModel" table="Asset_AssetBase">
..........
    <property name="ExpiryDate" column="ExpiryDate" type="DateTime" />
    <property name="IsAlive" formula="(CASE WHEN ExpiryDate IS NULL THEN 1 ELSE 0 END)" type="Boolean" />

but NHibernate translates it by the query

Code:

([this_1_].CASE [this_1_].WHEN [this_1_].ExpiryDate IS NULL [this_1_].THEN 1 [this_1_].ELSE 0 [this_1_].END) as f0_4_, 

Any suggestions to solve the problem?

Antonella

Hibernate version: 1.0.4

Top

antoska

Post subject:

Posted: Thu Jun 14, 2007 5:03 am

Beginner

Joined: Wed May 03, 2006 5:10 am
Posts: 32
Location: Monopoli - Italy

Solved using IsDate

Code:

Thanks
Antonella

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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