Hi all after getting all of the otherthings that I have been working on to work I am now facing the task of pulling in live data from the database. I can make a viable connection within the action form, but that just strikes me of bad design. I am trying to find out the best manner in which to create a connection to the database. I am currently using the BasicDataSource as it is defined in the struts-config.xml, but wanted to know if there is a better way of doing this (the reason I ask is the only way that I have found to get a connection in my database classes is to pass in the request object so that I can pull out the datasource - can someone point me to a good reference on current manners of connecting to a db.
Thanks once again for all your help on the matter.
I would strongly discourage you from using the Struts datasource utility. The best practice for all J2EE applications is to set up the DataSource as a JNDI resource using your application server's DataSource setup interface and then to lookup the datasource in JNDI in your applicaiton code.