Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

From: Priyesh

Newsgroups: sybase.public.sqlanywhere.ultralite

Subject: How does Ultralite create UUIDs?

Date: 19 Apr 2010 09:25:26 -0700


Device: Samsung Saga

OS: Windows Mobile 6.1

I have a client installation where devices create UUIDs with a '1' in the third group. According to UUID articles this should mean the last group is constant if created from the same device as it uses the device mac address there.

In this particular instance, i need to find if the same physical device created some of the records i see at the server. Just wondering if this is a reliable way to go forward. So far the data does not seem to agree. Could you please explain how Ultralite creates UUIDs in Windows Mobile?



asked 20 Apr '10, 10:12

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

[repost from the newsgroup to ensure we have an answer on this question]:

On systems where we can't always obtain a MAC address, including Windows CE/Mobile, we generate a random 47 bit node ID in place of the MAC address. This node ID is constant only as long as the UltraLite runtime library is loaded in memory -- we do not persist the random node ID to storage. So, UltraLite's UUIDs do not provide a reliable way to determine the generating device.

If you want that kind of functionality, you could consider using global auto increment.

Hope that helps,

  • Tim

I would add that the best way to identify the device is to insert the remote id into the consolidated tables.

  • Philippe
permanent link

answered 06 May '11, 11:14

PhilippeBertrand%20_SAP_'s gravatar image

accept rate: 22%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 20 Apr '10, 10:12

question was seen: 2,290 times

last updated: 06 May '11, 11:14