I am looking for some guidance on key generators with castor. Basically pros/cons for speed and concurrency. Currently I am using HIGH/LOW but I run into issues when the application has been running for over a week. I get duplicate identity exceptions. I basically have to restart the webapp.

1) HIGH/LOW -- the fastest?
2) IDENTITY -- is this as fast as HIGH/LOW?
3) SEQUENCE -- this seems to be problematic if you already have a table populated. Would you need to have custom sql to update the sequences?

Also how do you turn on SQL tracing with castor? I looked at the FAQ but it pointed to a dead link.

Steve

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

   http://xircles.codehaus.org/manage_email


Reply via email to