Hello everybody,
Hibernate version:
3.2
The following HQL statement works weel
<query name="initPortalStatusToRegistered">
<![CDATA[
insert into AttrListValue(id, panelist, attribute, selectionListValue)
select rownum, pa, at, slv.value
from Panelist pa, ApAttribute at, SelectionListValue slv
where pa.accessPanel.id = :accessPanelID
and at.name = 'PortalStatus'
and at.id = slv.attribute.id
and slv.caption = 'Registered'
]]>
</query>
But, when i replace rownum by hibernate_sequence.nextval*100; it does not work anymore
Do you have any idea please?
Thanks in advance.
Regards
Samuel
|