Thanks keith that looks like a really good elegant way of doing this, but as i conceded before I particularly stupid, and i don't get it. To be honest I've always had the db pooling stuff taken care for me before which was only of the attractions of using struts..
Is there no means to referencing to setting in config.xml. Like an example that explains the following Stuff_to_get_to_the_stuff_configxml.getDatasource(mykey); Or am i trying to make my life too simple and really should give up development and become a dustman or something? Many thanks again mark On 17-12-2002 15:12, "keithBacon" <[EMAIL PROTECTED]> wrote: > Using the command design pattern you can ensure the DB code needs to be coded > only once. > See the example below > > http://www.mail-archive.com/struts-user@jakarta.apache.org/msg24579.html > > > --- Matthias Bauer <[EMAIL PROTECTED]> wrote: >> The normal thing to is the following: You aquire a database connection >> in the action class and pass it on as a parameter to the bean's database >> methods. >> >> --- Matthias >> >> Mark wrote: >> >>> Sorry to repost this question, but the more i think about it the more i >>> think it a reasonable one (please tell me if i'm wrong). >>> >>> >>> ------ Forwarded Message >>> From: "Mark Lowe" <[EMAIL PROTECTED]> >>> Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >>> Date: Tue, 17 Dec 2002 09:03:33 +0100 >>> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >>> Subject: dataSources outside of actionservlet >>> >>> hello >>> >>> you'll all have to forgive my stupidity but i've been having real problems >>> trying to reference the datasource specified in config.xml in my business >>> logic classes. >>> >>> I've been very good and seperated everything as one should. but i really >>> need a straight answer to this (i.e. an example that works). >>> >>> "For maximum code re-use, business logic beans should be designed and >>> implemented so that they do not know they are being executed in a web >>> application environment" >>> >>> now i've only seen examples referencing the datasource inside an action >>> servlet, this appears to go against the design pattern. So how do i do this? >>> have i neglected to find the correct example? why are all the examples of >>> how to reference the datasource breaking the aforementioned priciple? please >>> i'm very confused .. >>> >>> many thanks in advance >>> >>> mark >>> >>> >>> >>> >>> -- >>> To unsubscribe, e-mail: >>> <mailto:[EMAIL PROTECTED]> >>> For additional commands, e-mail: >>> <mailto:[EMAIL PROTECTED]> >>> >>> >>> >>> ------ End of Forwarded Message >>> >>> >>> -- >>> To unsubscribe, e-mail: >> <mailto:[EMAIL PROTECTED]> >>> For additional commands, e-mail: >> <mailto:[EMAIL PROTECTED]> >>> >>> >>> >> >> >> -- >> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >> > > > ===== > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Search the archive:- > http://www.mail-archive.com/struts-user%40jakarta.apache.org/ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Keith Bacon - Looking for struts work - South-East UK. > phone UK 07960 011275 > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
