On 20/02/2008, at 9:51 AM, Scott Anderson wrote:

I am working an a request ticket system, similar to the one I'm using to
enter this issue. I need to import requests from the old schema to the
new schema, and the PKs must be specified while doing an import. When
using the tool normally, the PKs must be database generated. Is there
any way to do this?

You can specify the key yourself easily: 
http://cayenne.apache.org/doc/primary-key-generation.html

But I can't see how you can guarantee you will not get collisions between your two schemes. Maybe better to keep the old key in a separate field for reference purposes.

Ari Maniatis



-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001   fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A


Reply via email to