Stephen,
let me address one issue at a time, and where I have go something to say
at all.
Werner
Stephen Ince wrote:
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?
It depends. If it's just a range between 1 and a certina value that is
assigend already, you could always initialize the sequence to a value
outside of Castor before 'turning on' your application (the one that
uses Castor for key generation). It gets far more complicated if the
values assigned already are equally (evently) distributed across the
complete value space, if not impossible.
Also how do you turn on SQL tracing with castor?
Hmm, if SQL tracing can be turned on by the means of a JDBC property,
you can pass JDBC properties ... in the JDO configuration file, afair.
I looked at the FAQ but
it pointed to a dead link.
Where is that link ?
Steve
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
