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

The solution was to remove the id from the HQL, the SQL statement generated by Hibernate uses the sequence defined into the .hbm to generate the id.