 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | DB Connection prob (next step) | DB Connection prob (next step) 2007-03-21 - By Graeme McLaren
Back
Hi there, nice one that worked perfectly!
Thank you,
Graeme :)
>From: Duc Vo <dvo@(protected)>
>Reply-To: A mailing list about Java Server Pages specification and
>reference <JSP-INTEREST@(protected)>
>To: JSP-INTEREST@(protected)
>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@(protected); 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@(protected)>; 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@(protected)
>Delivered-To: JSP-INTEREST@(protected)
>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: <45FFEA96.1050409@(protected)>
><BAY138-F25E72B0BFA8D4AF9C7CB26D7750@(protected)>
>X-imss-version: 2.046
>X-imss-result: Passed
>X-imss-approveListMatch: *@(protected)
>Precedence: list
>Return-Path: owner-jsp-interest@(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:JSP-INTEREST@(protected)] On Behalf Of Graeme McLaren
>Sent: Wednesday, 21 March 2007 10:50 AM
>To: JSP-INTEREST@(protected)
>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 listserv@(protected) with body: "signoff
>JSP-INTEREST".
>For digest: mailto listserv@(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 listserv@(protected) with body: "signoff
>JSP-INTEREST".
>For digest: mailto listserv@(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 listserv@(protected) with body: "signoff JSP-INTEREST".
For digest: mailto listserv@(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
|
|
|
