Hello all, I have a situation where i frequently have to merge data from different databases. Uptill now every database has it's own sequence. That means that i cannot merge the data blindly because two records with the same id might not be the same record. I am thinking of switching from int id's to varchar UID's. Does ojb support such mechanism in an offline manner, so that the two servers do not need to communicate with each other. If all id's are globally unique i can blindly merge data without the danger of overwriting stuff. If ojb does not offer this out of the box then does anybody now a way to generate UID's across systems. Within one system I use java.rmi.server.UID().toString() but i dont know how unique that is across different VM's.
Cheers, Dennis
