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]
