> -----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]
