hi,




I'm running a web application on JBuilder / Tomcat 4.1 / JDK1.3.1 / J2EE 1.3.1.




I'm trying to obtain a DB connection from a DataSource, but I can't seem to JNDI-lookup the DataSource. I've tested obtaining a Connection using the "DriverManager way" and it works.




This is the code on my server8080.xml file:




<?xml version="1.0" encoding="UTF-8"?>



































username


****








password


****








driverClassName




oracle.jdbc.driver.OracleDriver








url







jdbc:oracle:thin:@BMSRVORACLE:1521:BMSRVMS































This is the code in my web.xml file:




<?xml version="1.0" encoding="UTF-8"?>








Testing





debugjsp


Added to compile JSPs with debug info


org.apache.jasper.servlet.JspServlet





classdebuginfo


true





3








debugjsp


*.jsp








Resource reference to a factory for java.sql.Connection
instances that may be used for talking to a particular
database that is configured in the server.xml file.


jdbc/SGC_CNID


javax.sql.DataSource


Container












This is the java code:






ContextWrapper ctxW = Globals.getContextWrapper();

Context ctx = ctxW.getContext();



String dsName = "jdbc/SGC_CNID";



try {

DataSource ds = (DataSource) ctx.lookup(dsName);

return ds.getConnection();

} catch (NamingException ne) {

throw new UselessResourceException("No se puede recuperar el DataSource '"+dsName+"'.", ne);

} catch (SQLException sqle) {

throw new UselessResourceException("ERROR: No se puede obtener una Connection del DataSource '"+dsName+"'.", sqle);

}





ctxW.getContext() (successfully finds and) returns the "java:comp/env" entry, restored by the following piece of code:




try {

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup("java:comp/env");

this.setContext(envCtx);

} catch (NamingException ne) {

throw new LinkedRuntimeException("No se pudo construir el Context Wrapper.", ne);

}







WHAT'S HAPPENING HERE???



THANKS EVERYBODY!


Freddy.