----- Original Message ----- From: "Andrew Vardeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 13, 2002 7:59 AM Subject: RE: RE: stateful service example (no cookies)
> Well, the service exists to provide a middleware layer between a client and > a database, so that's pretty much all that will be going on during a > session. Our Oracle DBA doesn't like the pooled connection idea because it > makes troubleshooting harder for him. He'd rather that unique clients were > mapped to specific database logins so when user X calls to say "my session > crashed," he doesn't have to dig through log files to find out which > session that was. maybe you should make mapping from username to session ID in the logs easier. IMO any admin task on a server is a valid use case, a use case your code should support. > Anyway, as I discovered five minutes later, a Connection > object is automatically closed when it is garbage collected, and that > should suffice. We don't anticipate a large number of simultaneous users. You are relying on garbage collection being approximately deterministic then, and not having objects hang around for 30 minutes or more
