Hi,

I am using Hibernate3.0. I want to know how to use null check function(NVL). My DB is Oracle 10g.My dialect is "org.hibernate.OracleDialect".

I am using named querys. If i use NVL function directly, when Null value is going for Long or Integer I got error like "can't assign Binary value to Integer".

In search condition if i have three fields they may be null, Now i am writting eight querys for each possible condition.

Pls Help.

Hi

You can use coalesce Hibernate function.

Example:
SELECT
COALESCE(bscserappc0_.BSCS_CONTRACT_ID,12) AS col_0_0_
FROM
AERAPP_CONTRACTS bscserappc0_

Regards,
Adam Woźniak

PS. rate if helps.