Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

COALESCE FUNCTION

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

dariolr

Post subject: COALESCE FUNCTION

Posted: Tue Mar 15, 2011 11:59 am

Newbie

Joined: Tue Mar 15, 2011 11:37 am
Posts: 1

Hello...

I CAN'T EXECUTE THIS MAPPED QUERY!!!!

Code:

 <query name="findByCoalesceQuery">
     <![CDATA[

        FROM firstObjVO AS firstVO
        WHERE firstVO.key.cod = ?
        AND firstVO.imp <>  COALESCE((SELECT SUM(secondVO.imp) FROM secondObjVO AS secondVO WHERE secondVO.key.cod = firstVO.key.cod), 0)

     ]]>
 </query>

I receive an -170 SQL ERROR CODE.

Please help!!!!!!!

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