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 ( where it says:

"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."

"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:Lazy-loaded basic attribute never refreshed
Next Topic:SessionCustomizer not used
Goto Forum:

Current Time: Thu Apr 26 20:43:01 GMT 2018

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

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