Hi all, I'm trying to get connection pooling working, I've altered the server.xml and web.xml files, written a class and it compiled with a few errors. What am I doing wrong here?
Cheers, Graeme :) in server.xml: <Context path="/dbcp" docBase="dbcp" debug="5" reloadable="true" crossContext="true"> <Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource" removeAbandoned="true" removeAbandonedTimeout="30" maxActive="100" maxIdle="30" maxWait="10000" username="myUsername" password="myPassword" driverClassName="oracle.jdbc.driver.OracleDriver" url="WorkingDBUrl"/> </Context> <!-- Configuring the request and response endpoints --> <Connector port="80" maxHttpHeaderSize="8192" maxProcessors="150" maxThreads="150" minSpareThreads="25" maxSpareThreads="75" enableLookups="false" redirectPort="8443" acceptCount="150" connectionTimeout="20000" disableUploadTimeout="true" /> in web.xml file: <listener> <listener-class>com.javacomponents.DBConnectionListener</listener-class> </listener> <!-- This component has a dependency on an external resource--> <resource-ref> <description>DB Connection Pooling</description> <res-ref-name>jdbc/TestDB</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> code to create connection: package com.javacomponents; import javax.servlet.*; import javax.servlet.http.*; import javax.sql.DataSource; import java.sql.*; public class DBCPoolingListener implements ServletContextListener{ public void contextInitialized(ServletContextEvent sce){ InitialContext context = null; Context envContext = null; DataSource ds = null; Connection conn; try{ context = new InitialContext(); envContext = (Context) context.lookup("java:comp/env"); ds = (DataSource) envContext.lookup("jdbc/TestDB"); conn = ds.getConnection(); }catch(NamingException ne){ // log the naming exception }catch(SQLException sqle){ // handle the SLQ exception (log) } } public void contextDestroyed(ServletContextEvent sce){ } } Errors: C:\Tomcat\webapps\ROOT\WEB-INF\classes\com\javacomponents\DBCPoolingListener.java:8: cannot resolve symbol symbol : class InitialContext location: class com.javacomponents.DBCPoolingListener InitialContext context = null; ^ C:\Tomcat\webapps\ROOT\WEB-INF\classes\com\javacomponents\DBCPoolingListener.java:9: cannot resolve symbol symbol : class Context location: class com.javacomponents.DBCPoolingListener Context envContext = null; ^ C:\Tomcat\webapps\ROOT\WEB-INF\classes\com\javacomponents\DBCPoolingListener.java:14: cannot resolve symbol symbol : class InitialContext location: class com.javacomponents.DBCPoolingListener context = new InitialContext(); ^ C:\Tomcat\webapps\ROOT\WEB-INF\classes\com\javacomponents\DBCPoolingListener.java:15: cannot resolve symbol symbol : class Context location: class com.javacomponents.DBCPoolingListener envContext = (Context) context.lookup("java:comp/env"); ^ C:\Tomcat\webapps\ROOT\WEB-INF\classes\com\javacomponents\DBCPoolingListener.java:18: cannot resolve symbol symbol : class NamingException location: class com.javacomponents.DBCPoolingListener }catch(NamingException ne){ ^ 5 errors Tool completed with exit code 1 =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com