• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Primary Key generation - size limit
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Primary Key generation - size limit


  • Subject: Re: Primary Key generation - size limit
  • From: Chuck Hill <email@hidden>
  • Date: Fri, 23 Apr 2004 09:52:10 -0700

It just goes. It is a matter of choosing the appropriate Java type to hold the size of data that the database stores. You will want to look at your DB docs and see what will fit in the column type you are using.


On Apr 23, 2004, at 9:44 AM, Jacky Gagnon wrote:

Hi Chuck

Do I need to use databaseContextNewPrimaryKey if i use a long?

Because in documentation, Apple talk about using a simple Integer for pk Generation by WO...

Thanks

Jacky


Le 04-04-23, ` 12:27, Chuck Hill a icrit :

java.lang.Long valueType l




On Apr 23, 2004, at 8:48 AM, Jacky Gagnon wrote:

Hi,

By default WebObjects use Integer for storing PK. Integer have a max
value of 231-1. In other word the limit is not infinite, especially
when record are deleted regularly from a table (gap are created because
some primary key value are lost, not reused by WO).


Whats the best stategy in this case, if I don't want to reach this
limit?

-Using a bigger number (long) or binary keys (24 bytes).
-Trying reusing objects (vs deleting these objects) to avoid gaps in
keys generation.
-Trying to avoid gaps into pk generation algorithm.

If you can point me to some documentation or case studies about
strategies in pk generation...


Thanks!

Jacky :-)
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.


References: 
 >Primary Key generation - size limit (From: Jacky Gagnon <email@hidden>)
 >Re: Primary Key generation - size limit (From: Chuck Hill <email@hidden>)
 >Re: Primary Key generation - size limit (From: Jacky Gagnon <email@hidden>)

  • Prev by Date: components to go?
  • Next by Date: Re: components to go?
  • Previous by thread: Re: Primary Key generation - size limit
  • Next by thread: RE: Primary Key generation - size limit
  • Index(es):
    • Date
    • Thread