Re: [Hibernate] Using Oracle Sequence

[Ugo C. <u....@cb...>]

Raible, Matt wrote:
> How do I convert the following Oracle query to a hiberate?
> 
> select ccr_master_sq.nextval from dual;
> 
> Here's a WAG:
> 
> <id name="id" type="long" column="ccr_id">
>     <generator class="sequence">
>         <param>ccr_master_sq.nextval</param>
>         <param>dual</param>
>     </generator>
> </id>
> 
> Is this correct?

No, use

       <generator class="sequence">
         <param>ccr_master_sq</param>
       </generator>

> Thanks,
> 
> Matt

You're welcome,

	Ugo

-- 
Ugo Cei - http://www.beblogging.com/blog/