Hi there, nice one that worked perfectly!
Thank you, Graeme :)
From: Duc Vo <[EMAIL PROTECTED]> Reply-To: A mailing list about Java Server Pages specification and reference <JSP-INTEREST@JAVA.SUN.COM> To: JSP-INTEREST@JAVA.SUN.COM Subject: Re: DB Connection prob (next step) Date: Wed, 21 Mar 2007 11:15:12 +1100 MIME-Version: 1.0 Received: from swjscmail2.java.sun.com ([192.18.99.108]) by bay0-mc10-f8.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Tue, 20 Mar 2007 17:25:40 -0700 Received: from swjscmail1 (swjscmail1.Sun.COM [192.18.99.107])by swjscmail2.java.sun.com (Postfix) with ESMTPid 97CB321EE9; Tue, 20 Mar 2007 18:22:10 -0600 (MDT) Received: from JAVA.SUN.COM by JAVA.SUN.COM (LISTSERV-TCP/IP release 1.8e) with spool id 14164816 for JSP-INTEREST@JAVA.SUN.COM; Tue, 20 Mar 2007 18:19:24 -0600 Received: from mx1.powerlan.com (mx1.powerlan.com [203.14.32.36]) by swjscmail1.java.sun.com (Postfix) with ESMTP id 8F8F84F63 for <JSP-INTEREST@JAVA.SUN.COM>; Tue, 20 Mar 2007 18:09:20 -0600 (MDT) Received: from pwrexns1.powerlan.com ([10.3.51.11]) by mx1.powerlan.com with InterScan Message Security Suite; Wed, 21 Mar 2007 11:14:33 +1100 X-Message-Info: LsUYwwHHNt3xx4ZEEJ5HUNEM2HdCQTJuIqC3qlQwKQol2gzrXRvSLHKGqfon3uB/ X-Original-To: JSP-INTEREST@JAVA.SUN.COM Delivered-To: JSP-INTEREST@JAVA.SUN.COM X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: DB Connection prob (next step) Thread-Index: AcdrSn2waGi00U9pT5GH3IHkT0MryAAA2KEg References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> X-imss-version: 2.046 X-imss-result: Passed X-imss-approveListMatch: [EMAIL PROTECTED] Precedence: list Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 21 Mar 2007 00:25:42.0345 (UTC) FILETIME=[75A16B90:01C76B4F] You need to import javax.naming.* -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED] On Behalf Of Graeme McLaren Sent: Wednesday, 21 March 2007 10:50 AM To: JSP-INTEREST@JAVA.SUN.COM Subject: Re: DB Connection prob (next step) 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\DBCPoolingList ener.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\DBCPoolingList ener.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\DBCPoolingList ener.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\DBCPoolingList ener.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\DBCPoolingList ener.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 =========================================================================== 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
=========================================================================== 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