Eclipse Community Forums: EclipseLink » Multi tenancy with schema per tenant and ids by sequence

Home » Eclipse Projects » EclipseLink » Multi tenancy with schema per tenant and ids by sequence(The same sequence on each schema.)

Show: Today's Messages :: Show Polls :: Message Navigator

Multi tenancy with schema per tenant and ids by sequence [message #1698519]

Tue, 16 June 2015 08:34

Tomasz W.

Messages: 1
Registered: June 2015

Junior Member

Hi.
EclipseLink 2.5.2
I have setup multitenancy per table accessed by Persistence Context per Tenant model, so with shared emf and Postgresql as a backend.
Everything going well until i had to use sequence generator for my ids, and here is the problem: looks like sequence name doesn't follow by per schema naming convention, so on each tenant/schema system trying to use the same sequence.

Any advice ?

[Updated on: Tue, 16 June 2015 17:14]

Report message to a moderator