You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Pablo Gomes Ludermir <pa...@inflor.com.br> on 2003/05/06 22:20:34 UTC

creating JNDI/JDBC connection pool

Hi People,

I would like to create a connection pool in Tomcat 5. I'd used the admin
tool that comes with tomcat and created it on the Resources -> Data Sources
session.
The problem is that when I try to use it on my JSP I get a null pointer.

        Context initCtx = new InitialContext();
        Context envCtx = (Context) initCtx.lookup("java:comp/env");
        DataSource ds = (DataSource) envCtx.lookup("jdbc/sgo");
        c = ds.getConnection(); //null pointer here


[]s
Pablo


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

Re: creating JNDI/JDBC connection pool

Posted by Pablo Gomes Ludermir <pa...@inflor.com.br>.
You just forgot to attach the application.
Actually if I put the zip file with the oracle drivers into the folder
<TOMCAT>\common\lib it does not load the driver. I had to unzip the file and
then the error has changed.
Does anyone knows why Tomcat does not load drivers in zip files? Should I
put the JAR?
[]s

----- Original Message -----
From: "Lorrin Nelson" <lh...@the-fam.net>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Tuesday, May 06, 2003 6:37 PM
Subject: Re: creating JNDI/JDBC connection pool


> I've had the same problem with Tomcat 4.0 and 4.1 for the last week, it's
> driving me crazy. For what it's worth, there's a Tomcat example
application
> that pulls information out of the context and it working fine for me; I
> just can't tell what's different between it and my app. Very frustrating!!
> I actually normally get java/comp is not bound, so you seem to be one step
> ahead of me. ;-)
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

Re: creating JNDI/JDBC connection pool

Posted by Lorrin Nelson <lh...@the-fam.net>.
I've had the same problem with Tomcat 4.0 and 4.1 for the last week, it's 
driving me crazy. For what it's worth, there's a Tomcat example application 
that pulls information out of the context and it working fine for me; I 
just can't tell what's different between it and my app. Very frustrating!! 
I actually normally get java/comp is not bound, so you seem to be one step 
ahead of me. ;-)

-Lorrin

At 02:29 PM 5/6/2003, Pablo Gomes Ludermir wrote:
>Yes, I did. Still not working... Anyone can help?
>The error is that:
>org.apache.jasper.JasperException: Name jdbc is not bound in this Context
>         at
>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
>54)
>         at 
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
>         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:247)
>         at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:193)
>         at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
>va:256)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
>va:191)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
>         at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
>)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
>java:171)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:641)
>         at
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
>)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:641)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
>:174)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at 
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
>         at
>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
>         at
>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
>ction(Http11Protocol.java:392)
>         at
>org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>         at
>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
>a:619)
>         at java.lang.Thread.run(Thread.java:536)
>
>root cause
>
>javax.servlet.ServletException: Name jdbc is not bound in this Context
>         at
>org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
>l.java:536)
>         at org.apache.jsp.login_jsp._jspService(login_jsp.java:85)
>         at 
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at
>org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
>10)
>         at 
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
>         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:247)
>         at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:193)
>         at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
>va:256)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
>va:191)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
>         at
>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
>)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
>java:171)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:641)
>         at
>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
>)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:641)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at
>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
>:174)
>         at
>org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
>eNext(StandardPipeline.java:643)
>         at
>org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
>         at 
> org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
>         at 
> org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
>         at
>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
>         at
>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
>ction(Http11Protocol.java:392)
>         at
>org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
>         at
>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
>a:619)
>         at java.lang.Thread.run(Thread.java:536)
>----- Original Message -----
>From: "YoGi" <yo...@darkmag.net>
>To: "Tomcat Users List" <to...@jakarta.apache.org>
>Sent: Tuesday, May 06, 2003 5:40 PM
>Subject: Re: creating JNDI/JDBC connection pool
>
>
> > did you specify useNaming="true" in the Context tag ? (it's the way it
>works
> > with tc4.x)
> > ----- Original Message -----
> > From: "Pablo Gomes Ludermir" <pa...@inflor.com.br>
> > To: <to...@jakarta.apache.org>
> > Sent: Tuesday, May 06, 2003 10:20 PM
> > Subject: creating JNDI/JDBC connection pool
> >
> >
> > > Hi People,
> > >
> > > I would like to create a connection pool in Tomcat 5. I'd used the admin
> > > tool that comes with tomcat and created it on the Resources -> Data
>Sources
> > > session.
> > > The problem is that when I try to use it on my JSP I get a null pointer.
> > >
> > >         Context initCtx = new InitialContext();
> > >         Context envCtx = (Context) initCtx.lookup("java:comp/env");
> > >         DataSource ds = (DataSource) envCtx.lookup("jdbc/sgo");
> > >         c = ds.getConnection(); //null pointer here
> > >
> > >
> > > []s
> > > Pablo
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> > >
> > >
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

Re: creating JNDI/JDBC connection pool

Posted by Pablo Gomes Ludermir <pa...@inflor.com.br>.
Yes, I did. Still not working... Anyone can help?
The error is that:
org.apache.jasper.JasperException: Name jdbc is not bound in this Context
	at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
54)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
	at java.lang.Thread.run(Thread.java:536)

root cause

javax.servlet.ServletException: Name jdbc is not bound in this Context
	at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:536)
	at org.apache.jsp.login_jsp._jspService(login_jsp.java:85)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
10)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
	at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
	at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
	at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
	at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
	at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
	at java.lang.Thread.run(Thread.java:536)
----- Original Message -----
From: "YoGi" <yo...@darkmag.net>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Tuesday, May 06, 2003 5:40 PM
Subject: Re: creating JNDI/JDBC connection pool


> did you specify useNaming="true" in the Context tag ? (it's the way it
works
> with tc4.x)
> ----- Original Message -----
> From: "Pablo Gomes Ludermir" <pa...@inflor.com.br>
> To: <to...@jakarta.apache.org>
> Sent: Tuesday, May 06, 2003 10:20 PM
> Subject: creating JNDI/JDBC connection pool
>
>
> > Hi People,
> >
> > I would like to create a connection pool in Tomcat 5. I'd used the admin
> > tool that comes with tomcat and created it on the Resources -> Data
Sources
> > session.
> > The problem is that when I try to use it on my JSP I get a null pointer.
> >
> >         Context initCtx = new InitialContext();
> >         Context envCtx = (Context) initCtx.lookup("java:comp/env");
> >         DataSource ds = (DataSource) envCtx.lookup("jdbc/sgo");
> >         c = ds.getConnection(); //null pointer here
> >
> >
> > []s
> > Pablo
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org

Re: creating JNDI/JDBC connection pool

Posted by YoGi <yo...@darkmag.net>.
did you specify useNaming="true" in the Context tag ? (it's the way it works
with tc4.x)
----- Original Message -----
From: "Pablo Gomes Ludermir" <pa...@inflor.com.br>
To: <to...@jakarta.apache.org>
Sent: Tuesday, May 06, 2003 10:20 PM
Subject: creating JNDI/JDBC connection pool


> Hi People,
>
> I would like to create a connection pool in Tomcat 5. I'd used the admin
> tool that comes with tomcat and created it on the Resources -> Data Sources
> session.
> The problem is that when I try to use it on my JSP I get a null pointer.
>
>         Context initCtx = new InitialContext();
>         Context envCtx = (Context) initCtx.lookup("java:comp/env");
>         DataSource ds = (DataSource) envCtx.lookup("jdbc/sgo");
>         c = ds.getConnection(); //null pointer here
>
>
> []s
> Pablo
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org