Using Numbers as Sequences in Oracle

tradem · **Joined:** Mon Oct 06, 2003 1:59 am **Posts:** 52

Hi Folks,

The tables on which I have to map my objects are using Oracle Number for all primary key fields. On some tables Oracle native sequences are installed.

I'm using java.math.BigDecimal to represent the Numbers in my POJOs.
Unfortunatly hibernate supports long, short and int for sequences only.

Can I easily get around this limitation, if yes how?

Thx
Toby

gavin · **Posted:** Fri Nov 14, 2003 3:41 am

Yes, its easy; just write a custom IdentifierGenerator

tradem · **Joined:** Mon Oct 06, 2003 1:59 am **Posts:** 52

gavin wrote:

Yes, its easy; just write a custom IdentifierGenerator

Thanks Gavin. It was really farily easy. I guess it will work. I'm gonna testing is in a new minutes.

Is this a extension usefull for others? Or is it to exotic? BTW the idea of using numbers is not from me ;-)

Bye
Toby

emmanuel · **Posted:** Fri Nov 14, 2003 6:54 am

Post it in the wiki

gavin · **Posted:** Fri Nov 14, 2003 7:42 am

I think its exotic ;)

But by all means post it to the Wiki, the more examples of how to do exocitc "stuff", the better!