help conection a pool class (JDBC) and JSTL page.

["Manso Gomez, Ramon" <rm...@indra.es>]

 
 
I just buy JST book and I do not find any example that how to do this. I need to use a pool 
connection and I have :
 
IN WEB.XML
 
<context-param>
<param-name>AppListener</param-name>
<param-value>ds</param-value>
</context-param>
 
THE class is put undex WEB-INF/class and is:
 
mport javax.servlet.jsp.jstl.core.Config;
import javax.servlet.*;
import javax.servlet.http.*;
import oracle.jdbc.pool.*;
 
public abstract class AppListener implements ServletContextListener {
 
private OracleConnectionCacheImpl ds =null;
 
public void contextInitialized(ServletContextEvent sce){
  ServletContext application =sce.getServletContext();
  try {
 ds = new OracleConnectionCacheImpl();
 ds.setURL("jdbc:oracle:thin:@172.30.1.62:1521:CAM");
 ds.setMaxLimit(20);
 ds.setUser("DEMO");
 ds.setPassword("DEMO");
  }
  catch (Exception e){
 application.log("Failed to create data source:"+
 e.getMessage());
 
AND jsp:
 
<sql:transaction dataSource>
 
  <sql:update var="newTable">
    create table mytable (
      nameid number(10) primary key,
      name varchar2(80)
    )
  </sql:update>
.
.
 
But it is not working. I can not connect the class with datasource of jps page.
 
 
 
       }
  Config.set(application,Config.SQL_DATA_SOURCE, ds);              }
 
}
 

and give this error:
 
org.apache.jasper.JasperException
 at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:248)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:289)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:240)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain
 
Please, help.