We have to save concurrent db sessions since customers are running out of licensed sessions. Typically two or three applications are running at the same time all using a session with the same db user.
Is there a way to share a single session (or two) between all applications? It is unlikely that all the applications need it at the same time - a critical section could take care of this of serializing the access.
As far as I know even different threads need a dedicated session, let alone full applications and I have read that datasets must not be shared among different threads (is this also true if concurrent access is prevented?).
A broker-kind of architecture might be the key here. Are there any implementations of this available?
Rgds
Werner Lehmann
Is there a way to share a single session (or two) between all applications? It is unlikely that all the applications need it at the same time - a critical section could take care of this of serializing the access.
As far as I know even different threads need a dedicated session, let alone full applications and I have read that datasets must not be shared among different threads (is this also true if concurrent access is prevented?).
A broker-kind of architecture might be the key here. Are there any implementations of this available?
Rgds
Werner Lehmann
