Our application uses the HiLo key generation to generate primary keys in the database. A plugin to our app doesn't want to use hibernate to talk to the database (just using plain old SQL). The problem is with the primary key generation, where there is a possibilty that primary keys will clash.

I'm not very familiar with how the HiLo generation strategy works. Is this really going to be a problem if we combine Hibernate's HiLo generation strategy with generating ids using plain old SQL? I'm not sure of the chances of primary keys clashing, but obviously we don't want this to happen.