Hibernate Community • View topic - Formula for boolean types possible?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Formula for boolean types possible?

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

fatzopilot

Post subject: Formula for boolean types possible?

Posted: Sun Aug 08, 2010 9:04 am

Newbie

Joined: Sat Mar 20, 2010 7:26 am
Posts: 6

Hi,

I ought to use the following formula to determine whether a process has ended (the type of its last event is 10)

Code:

SELECT (e.type = 10) FROM event e WHERE e.id = (SELECT MAX(e.id) FROM event e WHERE e.process_id = id)

In my application, I get a null value here.
When use this directly on the underlying MYSQL DB however, this returns 0 or 1.

Is it possible at all to define formulas / derived properties for fields with boolean types?

Thanks
fatzopilot

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