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