I was wondering how to do a standard count and call it via the getNamedQuery

Here is what i want to do
<sql-query name="verifyBetc"><![CDATA[select count(1) from tableName where item1 = 'IOGINC' and item1= 'C' and estab_dt < sysdate
and sysdate <= NVL(dslv_dt, sysdate)]]></sql-query>

Will this work above or do i need to map a return in there. Also what is the code i use to call get the value of the count?

look in the docs for how you map it - you need to map the return (s).


the same goes for how to call it - its in the docs.

I see how to map to custom object but i dont wanna do that. All i am returning is a number. I looked through the docs and found nothing. I searched through this forumand found not thing about returing the count via a getNamedQuery call. Please help a little more

Please read the docs!

From http://www.hibernate.org/hib_docs/v3/re ... medqueries

A named SQL query may return a scalar value. You must specfy the column alias and Hibernate type using the <return-scalar> element:

<sql-query name="mySqlQuery">
<return-scalar column="name" type="string"/>
<return-scalar column="age" type="long"/>
SELECT p.NAME AS name,
p.AGE AS age,
FROM PERSON p WHERE p.NAME LIKE 'Hiber%'
</sql-query>

Yeah i saw that brutha but when i add the line return-scalar it errors and says return-scalr must be declared. And if it does work it gives no example on how to code for the result. Could you just offer a little advice instead to just pointing things out. Ihave read the docs and would appeciate a little more clarification

are you using the latest hibernate 3?

http://www.hibernate.org/hib_docs/v3/re ... ting-named

on how to execute the queries.

look in unit test for concrete examples.

Nope my jar file says hibernate2.jar I do not dictate what version to use so i cannot upgrade to version 3.

then dont use Hibernate 3 features ;)

hibernate 2 does not support native sql scalar values.