How to use Integer as primary key ?

[tsangcn]

Hello,

Originally, my database contains tables with composite primary keys.
But since JBossCMP's CMR does not support primary key fields as foreign key fields, I plan to assign a Integer id to replace the compsite key.
A table is used to contain the name of the ejb and the last used value for id.
Whenever an ejb is created, the value is retrieved from the table and incremented by 1.

Is there any better method?

The id will be assigned as 1, 2, 3, ...
Since deleted record's id will not be reused, it may reaches Integer.MAX_VALUE in one day.
Is it need a checking for Integer.MAX_VALUE?
How to handle when it is Integer.MAX_VALUE?

Thanks
CN

[marc.fleury]

This is a CMP question please use the CMP forum

[sgturner]

I think different ways to handle primary keys are discussed in this book. If not, look further on the site, its there somewhere.

http://www.theserverside.com/books/EJBDesignPatterns/index.jsp

Also, consider, not using Integer, but use Long instead if you are worried about running out of values.