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: [email 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 [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
