Hibernate version: 3

I want to do a bulk update which needs join. Because join doesnt work in bulk update , I am using subselect.

This is my query:

String query = "update PaymentCcards pcc set pcc.Number=null where pcc.Id in {select pcc.Id from PaymentCcards pcc, Booking b where pcc.BookingId=b.Id and b.FirstDate = :pfirstdate and pcc.Number is not null} ";

I get this error:
unexpected char: '{'

That's because { is in invalid char. Use () not{}

Thanks, But Still I have this error:

Column 'ID' in field list is ambiguous

Im not using ID any where in:

update PaymentCcards pc set pc.Number=null where pc.Number is not null and pc.Id in (select pcc.Id from PaymentCcards pcc, Booking b where b.FirstDate = :pfirstdate)