On 6/21/06, Gentry, Michael (Contractor) <[EMAIL PROTECTED]> wrote:
I actually looked into making a PK generator that required no DB access, but
when I looked into it, Java didn't support everything I wanted without
resorting to JNI and C code. Of course, I was more ambitious in what I was
thinking. I wanted it to be similar to what I could do in EOF (hundreds of
keys/sec).
Does anyone here know if Java 1.5 supports obtaining the process ID natively?
I think that was my stumbling point before. I was trying to make a key that
contained server IP, process ID, timestamp, and counter. Maybe it is time to
consider this again. If I could produce a unique string all the time like
that, it would make a nice PK generator and your PKs would have some meaning
(that is me with my production support hat on).
It sounds like you are looking for something like:
http://java.sun.com/j2se/1.5.0/docs/api/java/util/UUID.html
As to your questions ...
A) My gut feeling tells me that wouldn't be a good idea.
Could you be more specific?
We're replacing a horrid .asp + MS Access application, which
inevitably leads to some nausea :-)
B) You could do that, but it seems pretty problematic to me.
More specific?
Maybe some others will have a few good ideas ...
If I can have an MSAccess & Oracle & MS SQL adapter that supports
server generated keys, then that will also solve my problems. Might be
a bit quixotic though. :-)
--
Øyvind Harboe
http://www.zylin.com
