oracle constraint problem, sequences for generating unique IDs

Hello:

 

We are attempting to overcome an oracle constraint problem, specifically:

 

Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint
(..SYS_C001711) violated

 

We've resolved the error with a short term solution but we are trying to get
away from sequences for generating unique IDs since it is expensive on the
performance side.  Has anyone implemented WO such that the capability to
cache sequence numbers is functional and it is NOT necessary to cache and
query for the next sequence number before making an update to Oracle?


Thanks in advance.