I take your point. Thanks.
--- Jim Barrows <[EMAIL PROTECTED]> wrote:
> > -----Original Message-----
> > From: Research labs
> [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 02, 2004 1:54 PM
> > To: Struts Users Mailing List
> > Subject: RE: DaTASOURCE CREATION AT USER LOGIN
> TIME...Newbie
> >
> >
> > Jim,
> >
> > Thanks a lot. Quite exhaustive. I will
> experiment
> > with your suggestion.
> >
> > Gosh! It is a lot of hard work; Oracle Forms takes
> > care of things like this. I am tempted to go back
> to
> > Oracle forms, but my clients cannot afford the
> cost.
> >
> > This is the first time I've really had to work
> hard.
>
> *LOL* It's also much more flexible, and performant.
> If you're letting users log in to the database over
> a stateless protocol, you can get a lot of open,
> unused connections in a hurry if your website gets
> hammered.. at least this way your connections will
> get recycled since they're a generic user login.
>
> >
> > Regards.
> >
> > Ola.
> >
> >
> > --- Jim Barrows <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > > > -----Original Message-----
> > > > From: Research labs
> > > [mailto:[EMAIL PROTECTED]
> > > > Sent: Monday, August 02, 2004 1:23 PM
> > > > To: Struts Users Mailing List
> > > > Subject: RE: DaTASOURCE CREATION AT USER LOGIN
> > > TIME...Newbie
> > > >
> > > >
> > > > Jim,
> > > >
> > > > Thanks for your response.
> > > > I want each user to login to the
> database(MySQL),
> > > via
> > > > a JSP. Once logged in, I want them to use
> their
> > > > database username (specified at log in time)
> for
> > > > communicating with the database throught their
> > > > session. To put it another way, if 4 users
> are
> > > > currently logged in (via a JSP etc.), When I
> query
> > > the
> > > > data dictionary of the database, I want their
> > > names to
> > > > come up. At any point in time, I want to be
> able
> > > to
> > > > find out, who is logged in, this is why I do
> not
> > > want
> > > > everyone to log in with the same username and
> > > password
> > > > e.g. ola/ola-hardcoded in the Struts config's
> > > > data-source.
> > >
> > > Okay... well this isn't an easy solution to be
> 100%
> > > right about. Mostly becuase users can simply
> close
> > > their browser, leaving themselves logged in
> until
> > > their session times out. Which means they'll
> have a
> > > connection open to the database.... not exactly
> a
> > > performance booster.
> > >
> > > What you could do, and I believe is a standard
> > > practice, is to put in the application scope a
> hash
> > > table/list of usernames that have logged in, and
> use
> > > an HttpSessinListener to remove users from the
> hash
> > > table/list as they log off or are to'd. You can
> > > even persist this to a db table if you wanted,
> > > rather then pt it into application scope.
> > >
> > > That would pretty much achieve your objective of
> > > knowing who is logged in at any moment. Use a
> hash
> > > table with the userid as the key, and in the
> value
> > > you can keep track of last acitivity, current
> > > sessionId and other nice to know bits as well.
> > >
> > >
> > > >
> > > > I do not mind using any datasource so long as
> I
> > > can
> > > > achieve my objective.
> > > >
> > > > Thanks.
> > > > Ola.
> > > >
> > > > --- Jim Barrows <[EMAIL PROTECTED]> wrote:
> > > > >
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Research labs
> > > > > [mailto:[EMAIL PROTECTED]
> > > > > > Sent: Monday, August 02, 2004 12:15 PM
> > > > > > To: Struts Users Mailing List
> > > > > > Subject: DaTASOURCE CREATION AT USER LOGIN
> > > > > TIME...Newbie
> > > > > >
> > > > > >
> > > > > > Hello,
> > > > > >
> > > > > > Can anyone please tell me how to specify
> the
> > > > > username
> > > > > > and password for "<data-source" at the
> time a
> > > user
> > > > > > logs in, instead of hard coding as "ola"
> is
> > > > > hardcoded
> > > > > > below:
> > > > > >
> > > > > > <data-sources>
> > > > > > <data-source
> > > > > >
> > > type="org.apache.commons.dbcp.BasicDataSource">
> > > > > > <set-property
> property="driverClassName"
> > > > > > value="com.mysql.jdbc.Driver" />
> > > > > > <set-property property="url"
> > > > > > value="jdbc:mysql://localhost/cargo" />
> > > > > > <set-property property="username"
> > > value="ola"
> > > > > />
> > > > > > <set-property property="password"
> > > value="ola"
> > > > > />
> > > > > > </data-source>
> > > > > > </data-sources>
> > > > > >
> > > > > > If this is not possible, can you please
> tell
> > > an
> > > > > > alternative way of achieving this.
> > > > >
> > > > > I think you're deep into containter
> dependency
> > > here.
> > > > > Not sure what you're needs are for a
> dynamic
> > > login
> > > > > it to the database, you could also look at
> > > providing
> > > > > the informaiton through Ant, or other build
> > > tool.
> > > > >
> > > > >
> > > >
> > > > Thanks for your response.
> > > > I want each user to login to the
> database(MySQL),
> > > via
> > > > a JSP. Once logged in, I want them to use
> their
> > > > database username (specified at log in time)
> for
> > > > communicating with the database throught their
> > > > session. To put it another way, if 4 users
> are
> > > > currently logged in (via a JSP etc.), When I
> query
> > > the
> > > > data dictionary of the database, I want their
> > > names to
> > > > come up. At any point in time, I want to be
> able
> > > to
> > > > find out, who is logged in, this is why I do
> not
> > > want
> > > > everyone to log in with the same username and
> > > password
> > > > e.g. ola/ola-hardcoded in the Struts config's
> > > > data-source.
> > > >
> > > > I do not mind using any datasource so long as
> I
> > > can
> > > > achieve my objective.
> > > >
> > > > Thanks.
> > > > Ola.
> > > >
> > > >
> > > > > >
> > > > > > Thanks.
> > > > > >
> > > > > > Ola.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
___________________________________________________________ALL
> > > > > > -NEW Yahoo! Messenger - all new features -
> > > even
> > > > > more fun!
> > > > > http://uk.messenger.yahoo.com
> > > > >
> > > > >
> > > >
> > >
> >
>
---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail:
> > > > > [EMAIL PROTECTED]
> > > > > For additional commands, e-mail:
> > > > > [EMAIL PROTECTED]
> > > > >
> > > > >
> > > > >
> > > >
> > >
> >
>
---------------------------------------------------------------------
> > > > > To unsubscribe, e-mail:
> > > > > [EMAIL PROTECTED]
> > > > > For additional commands, e-mail:
> > > > > [EMAIL PROTECTED]
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
>
___________________________________________________________ALL
> > > > -NEW Yahoo! Messenger - all new features -
> even
> > > more fun!
> > > http://uk.messenger.yahoo.com
> > >
> > >
> >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > > [EMAIL PROTECTED]
> > > For additional commands, e-mail:
> > > [EMAIL PROTECTED]
> > >
> > >
> > >
> >
>
---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > > [EMAIL PROTECTED]
> > > For additional commands, e-mail:
> > > [EMAIL PROTECTED]
> > >
> > >
> >
> >
> >
> >
> >
> >
>
___________________________________________________________ALL
> > -NEW Yahoo! Messenger - all new features - even
> more fun!
> http://uk.messenger.yahoo.com
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
___________________________________________________________ALL-NEW Yahoo! Messenger -
all new features - even more fun! http://uk.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
