Retrieving datasource from init(ActionServlet, ModuleConfig)

[Jesus Fernandez]

Hi all, how can i obtain a datasource from de init(ActionServlet, ModuleConfig) methos inside a class that implements Plugin
Here is the code:

 
package trilcejf;
 
import java.util.*;
 
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
 
import java.sql.*;
import javax.sql.DataSource;
 
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
 
import org.apache.struts.action.ActionServlet;
import org.apache.struts.action.PlugIn;
import org.apache.struts.config.ModuleConfig;
 
/**
 * @author Jesus Fernandez
 *
 */
public class GestorInicioAplicacion implements PlugIn {
Log log = LogFactory.getLog(GestorInicioAplicacion.class);
ServletContext sc;
DataSource ds = null;

public GestorInicioAplicacion(){}

/**
 * inicializa recursos necesarios cuando la aplicaci�n arranca
 * @param arg0
 * @param arg1
 * @throws ServletException
 */
public void init(ActionServlet arg0, ModuleConfig arg1) throws ServletException{
sc = arg0.getServletContext();

List tecnologias = new ArrayList();
List contratos = new ArrayList();
Connection con = null;
PreparedStatement ps = null;
ResultSet rsTecnologias = null;
ResultSet rsContratos = null;
String sentenciaSQL = "";

log.info("Obteniendo todas las tecnologias de la BD.");
try {
                         // It is not correct
// con = ds.getConnection();
sentenciaSQL = "SELECT nombre_tecnologia FROM tecnologias";
ps = con.prepareStatement(sentenciaSQL);
rsTecnologias = ps.executeQuery();
...
 
 

Thanks in advance

[Kerry Wilson]

It is generally considered bad design to use the Struts datasource feature since it introduces a dependency between your controller (struts) and your model. Instead use your JNDI, follow this link:

http://www.coderanch.com/t/51774/Struts/struts-database-connection

[Jesus Fernandez]

Thanks for the reply Kerry.
But my goal is obtain a DataSource when my application startup ro retrieve some data from a BD. That's why i need the DataSource. My question is how can i obtain this one from the init method of a class that implements Plugin and execute both the init(..) and destroy() methods
Thanks in advance