From: Priyesh

Newsgroups: sybase.public.sqlanywhere.ultralite

Subject: How does Ultralite create UUIDs?

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

Version 10.0.1.3579

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?

TIA

Priyesh

asked 20 Apr '10, 10:12

Breck%20Carter's gravatar image

Breck Carter
25.7k428592852
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

PhilippeBert...
1.5k41735
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×145

question asked: 20 Apr '10, 10:12

question was seen: 1,277 times

last updated: 06 May '11, 11:14