Hi all,

I have a requirement that I have to generate a number for a certificate that I am creating. This number will be prefixed with the current year eg. 07/00001
and will be reset each year.

I was wondering if there is any way I can create an oracle sequence that I can use to simply get the next_val each time I need to and then I can recreate the sequence programatically at the start of each new year.

I don't want to have a table that is used by the sequence as I wouldn't be able to reset the sequence programatically each year.

Anyone have any ideas or can point me in the right direction.

Thanks for any help.

Well, I guess you're gonna need to implement something of your own doing some native SQL to retrieve/create/drop the right sequence when needed. I don't think you'll find something already done in Hibernate that will let you do it magicly :-).

Yeah, I think you are right. Think I might have another way of doing it as well.

thanks for the reply.