The best practice for connecting to a
JDBC DataSource in a Struts or any
J2EE Web Application is to define the DataSource as a JNDI resource using your Application Server's preferred method and then using JNDI to look up the DataSource in your application code. If you're using
Tomcat, this link explains how to do it.
Also see question 7 in the JavaRanch Struts FAQ