Hi ,

I am a new bie to this forum.

I am facing difficulty with using a "|| ' ' ||" (concatenation operator) in Hibernate.

please tell me how to use || ' ' || operator in HQL .


with regards
pravi

select firstName||' '||initial||' '||upper(lastName) from Person

Hi,

Thanks for your reply. below is the SQL Query that I need to convert to HQL. I am facing problem with the concatenation operator.

SELECT ADV.BR_SET_CODE,ADV.LOAN_AMT,FEE_ID,FEE_FREQ_IDFEE_AMT,IS_W

AIVABLE_FEE,IS_OTHER_FEE,EMP.FIRST_NAME||','||EMP.LAST_NAME,FEE.

DATE_UPDATED,GAP_PERIOD FROM LT_CA_BR_LOAN_AMT ADV,

LT_CA_BR_FEE_AMT FEE,CA_EMP_MASTER EMP WHERE

ADV.BR_SET_CODE =FEE.BR_SET_CODE AND

ADV.LOAN_AMT=FEE.LOAN_AMT AND ADV.BR_SET_CODE=? AND

ADV.UPDATED_BY = EMP.EMP_CODE";

I converted the above Query to Hibernate Query as follows . It is giving the results for the first 7 columns in select clause. Unable to return the results of the remaining columns starting from || ' , '|| operator column


[size=18]
SELECT

ADV.caBrSet.brSetCode,ADV.id.loanAmt,FEE.id.feeId,FEE.ltCaBrFeeFreqTy

pe.feeFreqId,FEE.feeAmt,FEE.isWaivableFee,FEE.isOtherFee,EMP.firstName

|| ' , ' || EMP.lastName,FEE.dateUpdated,FEE.ltCaBrLoanAmt.gapPeriod

FROM LtCaBrLoanAmt ADV, LtCaBrFeeAmt FEE,CaEmpMaster EMP

WHERE ADV.caBrSet.brSetCode =FEE.caBrSet.brSetCode AND

ADV.id.loanAmt=FEE.ltCaBrLoanAmt.id.loanAmt AND

ADV.caBrSet.brSetCode=? AND ADV.updatedBy = EMP.empCode;[/size]

[color=red][/color]

plz help me out

with regards
pravi

Can you post the stacktrace for the error?

hi,

There is no Error display. The Query is returning 7 columns instead of 9 columns. columns up to the column containing string concatenation operator.

The problem got solved when I replaced the || ' ' || with concat() function.

But wht is wrong with || ' '|| representation


thanks

with regards
Pravi