User Story #1158 (closed)
Find optimal JTA implementation
|Reported by:||jamoore||Owned by:||jamoore|
|Component:||ORM||Keywords:||jta, orm, database, transactions|
|Total Remaining Time:||n.a.||Estimated Remaining Time:||n.a.|
Description (last modified by jmoore)
While using c3p0 in blitz, it was found that large sections of code were unprotected by transactions. Since then, we've been testing various JTA providers to improve the situation.
Under high-load could become completely dead-locked.
After 2-3 weeks of uptime, the server fails with "heurtistic" exceptions.
With 2PC, hangs on one of the first server calls; with 1PC throws "can only enlist one Lru source"
JBossTS / Arjuna
Without conncetion reconnect, consumes all Postgres connections; with, throws heuristic exceptions.
Apparently our use of transactions is not compatible with any JTA implementation (or the spec??) and so some re-architecting is necessary.