AO - what happens when int Id's are exhausted?

AO ID are integers, as shown.

Out of curiosity, what happens to AO if you exhaust its postive ID range of 2,147,483,647, does it rollover and start using negatives or does the sky fall? Sure I could look at the source, but just maybe others might find this interesting?

2 answers

1 accepted

Accepted Answer
3 votes

The short answer is: I don't know. Good question. Maybe we could warn or do some check of some sort… What were you thinking should happen?

Do you have a concrete use case where you fear you might reach this limit?

In any case, nothing prevents you from using Long for you entity IDs. For example I know the GreenHopper developers defined their own Entity parent class as:

public interface Entity extends RawEntity<Long>
{
	@AutoIncrement
	@NotNull
	@PrimaryKey("ID")
	public long getID();
}

This should give you some room up to 9,223,372,036,854,775,807 ;-)

Note that AO is capable of migrating int IDs to long IDs if necessary, however I would advise choosing the type that will suit your expected usage as soon as possible. Of course.

Hmm, yes, that seems like a good thing, thanks for the pointer. Given JIRA uses long types, wouldnt it be consistent to default AO objects to use them for ID's by default too, ints just stand out...

Well, int has been the default ID type for AO for a little while, so I didn't want to change that. Maybe I should have…

0 votes

Kudos to the AO developers if they have code that specifically addresses this situation. Anyway, it's likely that the database would die long before IDs are exhausted ;)

That is irrelevant if the codebase is incompatible because it uses int instead of long!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

122 views 6 8
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you