Hi community,
I am in the process of designing the application and I have an architectural issue.
We will use oracle db 12, top 19.1, ords 19.1 and the latest tomcat.
I want to ask about the pool of connections. Can anyone describe how it works in this environment or maybe someone knows good source to read about it
I've found that when the page loads or there is some action in the application the first free connection session is used. So, can it be the case that two simultaneously logged in users will use the same session?
Is it possible to set each new logged-in user to receive their own unique session?
There are packages with variables on the database that are unique for the session. The requirement is that each user has access to variables from one specific session (his from the start).
Thank you help.