Oracle8/JDBC/Threads/ConnectionPools... [message #366703] |
Mon, 16 October 2000 14:16 |
Barry Wythoff
Messages: 1 Registered: October 2000
|
Junior Member |
|
|
Hello people,
I have until now been using a multiuser shared server model, with a connection pool of generic connections. I want to transition to a session-based object setup with individual user login, and will spare you the details on that ;-). For performance reasons, I still do not want to open and close connections with each query.
My question is, what will happen if a multithreaded server object recieves a second query request (from the same user) before the first query has been fully processed? Do I have to use a connection pool (of user-specific connections) for each user? Can I harmlessly multiplex queries for the same user on "their" single connection?
Thank you for your kindness,
Barry
|
|
|