Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » UnaryTableSequence per entity vs single table-sequence table(UnaryTableSequence per entity vs single table-sequence table)
UnaryTableSequence per entity vs single table-sequence table [message #1386164] Fri, 13 June 2014 20:35
Alberto Otero is currently offline Alberto OteroFriend
Messages: 2
Registered: June 2014
Junior Member
I have recently read a web page about identity and sequencing in JPA (en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing) where it says:

Quote:
"One issue with table sequencing is that the sequence table can become a concurrency bottleneck, even causing deadlocks. ... In some cases the entire sequence table or the table page could be locked causing even transactions allocating other sequences to wait or even deadlock."


Quote:
"TopLink, EclipseLink : Several additional sequencing options are provided. A UnaryTableSequence allows a single column table to be used."


As a conclusion, I suppose it is better to use one UnaryTableSequence per entity instead of a single table-sequence table for all entities because it will reduce the concurrency problems. Am I right?

Is there any drawback in creating one UnaryTableSequence per entity?
Previous Topic:MongoDB and multi-tenancy
Next Topic:EL QBE JPA2
Goto Forum:
  


Current Time: Sun Nov 19 19:59:32 GMT 2017

Powered by FUDForum. Page generated in 0.01785 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software