Java Mailing List Archive

http://www.gg3721.com/

Home » users.openjpa »

Clustering & ID TableGenerator (OPENJPA_SEQUENCE_TABLE)

Michael Vorburger

2008-07-09

Replies: Find Java Web Hosting

Author LoginPost Reply
Hello,

How do you do Clustering and ID TableGenerator
(e.g.OPENJPA_SEQUENCE_TABLE) ?

Will this somehow magically work (how?), or will different nodes "step
on each other's feet" because they'll use the same PK? Can they each use
different "slices" ?

If impossible, do you HAVE to use Identify columns or Sequence
generators in the DB? I thought that was not such a good idea (if you
have a choice), performance wise, because it requires an extra
round-trip to the DB to get the PK e.g. to set it as FK. Also
https://issues.apache.org/jira/browse/OPENJPA-464 states that Statement
Batching won't work with GeneratedType=IDENTITY - so this option doesn't
seem terribly tempting in order to get ID and clustering happily married
together.

How do people out there do this with OpenJPA?

Thank you,
Michael

_____________________________
Michael Vorburger, Odyssey Financial Technologies


____________________________________________________________

• This email and any files transmitted with it are CONFIDENTIAL and intended
solely for the use of the individual or entity to which they are addressed.
• Any unauthorized copying, disclosure, or distribution of the material within
this email is strictly forbidden.
• Any views or opinions presented within this e-mail are solely those of the
author and do not necessarily represent those of Odyssey Financial
Technologies SA unless otherwise specifically stated.
• An electronic message is not binding on its sender. Any message referring to
a binding engagement must be confirmed in writing and duly signed.
• If you have received this email in error, please notify the sender immediately
and delete the original.
©2008 gg3721.com - Jax Systems, LLC, U.S.A.