Jefferey, Coming into this thread late, but I'm curious. Why do you want each user to obtain a connection to the database, effectively logging into the DB, instead of using a connection pool with a single, application specific, DB userid/password?
- Bob --- [EMAIL PROTECTED] wrote: > Thanks Doug and Chuck, > > I suspected as much re. the connection pool. This > sort of negates the > value of it a little (for me anyway). > > My original plan was to go with saving the > connection to the session once > it was established but I had read somewhere that > connections are not > 'serializable' and therefore the garbage cleanup in > tomcat may kill the > connection unexpectedly?!.? > > Has anyone used session tracking to store database > connections? If so, has > anything bad happened? > > Doug to answer your question "How many users are > there going to be on the > system at once and can the > system handle that many open connections?"... > > I anticipate that the production version will have > from 20 - 30 people > updating information (in different cities ) and > possibly 50 or so browsing > the database for information. The backend database > will be ORACLE 9i > running in MS Server 2003 on an IBM server. In the > pooled connection > implementation I allowed for 150 concurrent users. > I think oracle running > on a pretty beefy application server should be able > to handle it. The web > server box will also be MS server 2003 on an older > style server so I > suppose the only scary part will be weaknesses (if > there are any) in Tomcat > itself. > > Anyway, I will implement storing the connection in > the session with the log > out killing the connection. > > Any comments or gotchas you know about would be > useful. > > Jeffery S. Eaton > > > > > > ************************************************************ > Opinions contained in this e-mail do not necessarily > reflect > the opinions of the Queensland Department of Main > Roads, > Queensland Transport or Maritime Safety Queensland, > or > endorsed organisations utilising the same > infrastructure. > If you have received this electronic mail message in > error, > please immediately notify the sender and delete the > message > from your computer. > ************************************************************ > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________ Yahoo! Music Unlimited Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]