Return-Path: 
 <user-return-3421-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 42007 invoked from network); 22 May 2006 04:39:32 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 22 May 2006 04:39:32 -0000
Received: (qmail 6021 invoked by uid 500); 22 May 2006 04:39:29 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 6004 invoked by uid 500); 22 May 2006 04:39:29 -0000
Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:user-help@geronimo.apache.org>
list-unsubscribe: <mailto:user-unsubscribe@geronimo.apache.org>
List-Post: <mailto:user@geronimo.apache.org>
Reply-To: user@geronimo.apache.org
List-Id: <user.geronimo.apache.org>
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 5988 invoked by uid 99); 22 May 2006 04:39:29 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 May 2006 21:39:28 -0700
X-ASF-Spam-Status: No, hits=1.0 required=10.0
	tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE,NO_REAL_NAME
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [203.3.176.70] (HELO lngateway.agd.nsw.gov.au) (203.3.176.70)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 May 2006 21:39:27 -0700
X-SEF-Processed: 5_0_0_910__2006_05_22_14_37_45
X-SEF-530AE5E8-B25C-4600-A8B4-A0AAE4DD4687: 1
Received: from Unknown [10.4.11.2] by lngateway.agd.nsw.gov.au - SurfControl
 E-mail Filter (5.0); Mon, 22 May 2006 14:37:43 +1000
In-Reply-To: 
 <1ED7A952DFAE70488C8FE8E0A8100F33016D5F48@MSGBANCLA2WIN.DMN1.FMR.COM>
To: user@geronimo.apache.org
Subject: Re: Unable get datasource reference in bean...
MIME-Version: 1.0
X-Mailer: Lotus Notes Release 6.0 September 26, 2002
Message-ID: 
 <OFD8C32AE2.F63C1E22-ONCA257176.0019709F-CA257176.00198A5E@agd.nsw.gov.au>
From: Luke_Chiam@agd.nsw.gov.au
Date: Mon, 22 May 2006 14:38:59 +1000
X-MIMETrack: Serialize by Router on GOODMDG1/Server/NSW_AG(Release
 6.5.1|January 21, 2004) at
 22/05/2006 02:37:46 PM,
	Serialize complete at 22/05/2006 02:37:46 PM
Content-Type: multipart/alternative;
 boundary="=_alternative 00198A59CA257176_="
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This is a multipart message in MIME format.
--=_alternative 00198A59CA257176_=
Content-Type: text/plain; charset="US-ASCII"

do you need to declare with jdbc for datasource?

ctx.lookup("java:comp/envjdbc//REQUEST");






"Varanasi, Ishwara" <Ishwara.Varanasi@fmr.com> 
22/05/2006 02:23 PM
Please respond to
user@geronimo.apache.org


To
<user@geronimo.apache.org>
cc

Subject
Unable get datasource reference in bean...






Hi,
I am facing a problem with accessing DataSource.
I am able to get reference to a declared database pool in JSP and
Servlet.
But unable to do so in a session bean or class accessed by a session
bean. I am getting a NameNotFoundException... any idea why this is
happening?

The code:
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)
ctx.lookup("java:comp/env/REQUEST");
Connection con = ds.getConnection();

Web.xml:
<resource-ref>
<res-ref-name>REQUEST</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

Geronimo-web.xml:
<naming:resource-ref>
<naming:ref-name>REQUEST</naming:ref-name>
<naming:resource-link>REQUEST</naming:resource-link>
</naming:resource-ref>

Output and stack trace of exception goes here:

Getting ref in Servlet:
==========================
09:46:39,342 INFO  [TimeServerServlet] 2. Getting ds ref in Servlet...
09:46:44,764 INFO  [TimeServerServlet] Got connection:
org.tranql.connector.jdbc.ConnectionHandle@81bb3b
09:46:44,764 INFO  [DateTimeFunctions] Date          : Mon May 22
09:46:44 IST 2006
09:46:44,764 INFO  [DateTimeFunctions] Formatted Date: 22/05/2006
09:46:44.764 In ejbCreate()


Error in bean:
==========================
09:46:44,780 INFO  [TimeServerBean] 1. Getting ds ref in Bean...
09:46:44,780 ERROR [TimeServerBean] Exception #1:
javax.naming.NameNotFoundException: env/REQUEST
javax.naming.NameNotFoundException: env/REQUEST
at
org.apache.geronimo.naming.enc.AbstractReadOnlyContext.lookup(AbstractRe
adOnlyContext.jav
a:81)
at
org.apache.geronimo.naming.java.RootContext.lookup(RootContext.java:51)
at javax.naming.InitialContext.lookup(InitialContext.java:347)
at
com.nis.timeserver.ejb.TimeServerBean.getTime(TimeServerBean.java:72)
at
com.nis.timeserver.ejb.TimeServerBean$$FastClassByCGLIB$$3926a5ec.invoke
(<generated>)
at
org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat
ion.java:90)
at
org.openejb.slsb.BusinessMethod.execute(BusinessMethod.java:67)
at
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java
:72)
at
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo
nentContextInterc
eptor.java:56)
at
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter
ceptor.java:81)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:119)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextIntercepto
r.java:80)
at
org.openejb.slsb.StatelessInstanceInterceptor.invoke(StatelessInstanceIn
terceptor.java:98
)
at
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic
y.java:140)
at
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction
ContextIntercepto
r.java:80)
at
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor
.java:82)
at
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)
at
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja
va:129)
at
org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$39d68ea2.getTime(<g
enerated>)
at
com.nis.timeserver.web.servlet.TimeServerServlet.doGet(TimeServerServlet
.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.j
ava:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)

at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.inv
oke(GeronimoStand
ardContext.java:272)
at
org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(Transact
ionContextValve.j
ava:53)
at
org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(ComponentC
ontextValve.java:
47)
at
org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(InstanceCon
textValve.java:60
)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526
)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85
6)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11P
rotocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.ja
va:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Thread.java:534)


Thanks and Regards,
Ishwara Bhat V

***********************************************************

Please consider our environment before printing this email.

This email and any attachments may be confidential and contain privileged
 information. If you are not the intended recipient you must not use, 
disclose, copy or distribute this communication. If you have received 
this message in error please delete and notify the sender. When communicating 
by email you consent to the monitoring and recording of that correspondence.

The Attorney General's Department of NSW promotes a Just and Safe Society. 
Visit us at http://www.lawlink.nsw.gov.au

--=_alternative 00198A59CA257176_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2><tt>do you need to declare with jdbc for datasource?</tt></font>
<br>
<br><font size=2><tt>ctx.lookup(&quot;java:comp/envjdbc//REQUEST&quot;);</tt></font>
<br>
<br>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>&quot;Varanasi, Ishwara&quot;
&lt;Ishwara.Varanasi@fmr.com&gt;</b> </font>
<p><font size=1 face="sans-serif">22/05/2006 02:23 PM</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Please respond to<br>
user@geronimo.apache.org</font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td valign=top><font size=1 face="sans-serif">&lt;user@geronimo.apache.org&gt;</font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">Unable get datasource reference
in bean...</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2><tt>Hi,<br>
I am facing a problem with accessing DataSource.<br>
I am able to get reference to a declared database pool in JSP and<br>
Servlet.<br>
But unable to do so in a session bean or class accessed by a session<br>
bean. I am getting a NameNotFoundException... any idea why this is<br>
happening?<br>
</tt></font>
<br><font size=2><tt>The code:<br>
InitialContext ctx = new InitialContext();</tt></font>
<br><font size=2><tt>DataSource ds = (DataSource)<br>
ctx.lookup(&quot;java:comp/env/REQUEST&quot;);</tt></font>
<br><font size=2><tt>Connection con = ds.getConnection();<br>
</tt></font>
<br><font size=2><tt>Web.xml:<br>
&lt;resource-ref&gt;</tt></font>
<br><font size=2><tt>&lt;res-ref-name&gt;REQUEST&lt;/res-ref-name&gt;<br>
&lt;res-type&gt;javax.sql.DataSource&lt;/res-type&gt;<br>
&lt;res-auth&gt;Container&lt;/res-auth&gt;<br>
&lt;res-sharing-scope&gt;Shareable&lt;/res-sharing-scope&gt;</tt></font>
<br><font size=2><tt>&lt;/resource-ref&gt;<br>
</tt></font>
<br><font size=2><tt>Geronimo-web.xml:<br>
&lt;naming:resource-ref&gt;</tt></font>
<br><font size=2><tt>&lt;naming:ref-name&gt;REQUEST&lt;/naming:ref-name&gt;<br>
&lt;naming:resource-link&gt;REQUEST&lt;/naming:resource-link&gt;</tt></font>
<br><font size=2><tt>&lt;/naming:resource-ref&gt;<br>
</tt></font>
<br><font size=2><tt>Output and stack trace of exception goes here:<br>
</tt></font>
<br><font size=2><tt>Getting ref in Servlet:<br>
==========================<br>
09:46:39,342 INFO &nbsp;[TimeServerServlet] 2. Getting ds ref in Servlet...<br>
09:46:44,764 INFO &nbsp;[TimeServerServlet] Got connection:<br>
org.tranql.connector.jdbc.ConnectionHandle@81bb3b<br>
09:46:44,764 INFO &nbsp;[DateTimeFunctions] Date &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp;: Mon May 22<br>
09:46:44 IST 2006<br>
09:46:44,764 INFO &nbsp;[DateTimeFunctions] Formatted Date: 22/05/2006<br>
09:46:44.764 In ejbCreate()<br>
</tt></font>
<br>
<br><font size=2><tt>Error in bean:<br>
==========================<br>
09:46:44,780 INFO &nbsp;[TimeServerBean] 1. Getting ds ref in Bean...<br>
09:46:44,780 ERROR [TimeServerBean] Exception #1:<br>
javax.naming.NameNotFoundException: env/REQUEST<br>
javax.naming.NameNotFoundException: env/REQUEST</tt></font>
<br><font size=2><tt>at<br>
org.apache.geronimo.naming.enc.AbstractReadOnlyContext.lookup(AbstractRe<br>
adOnlyContext.jav<br>
a:81)</tt></font>
<br><font size=2><tt>at<br>
org.apache.geronimo.naming.java.RootContext.lookup(RootContext.java:51)</tt></font>
<br><font size=2><tt>at javax.naming.InitialContext.lookup(InitialContext.java:347)<br>
at</tt></font>
<br><font size=2><tt>com.nis.timeserver.ejb.TimeServerBean.getTime(TimeServerBean.java:72)<br>
at</tt></font>
<br><font size=2><tt>com.nis.timeserver.ejb.TimeServerBean$$FastClassByCGLIB$$3926a5ec.invoke<br>
(&lt;generated&gt;)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.dispatch.AbstractMethodOperation.invoke(AbstractMethodOperat<br>
ion.java:90)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.slsb.BusinessMethod.execute(BusinessMethod.java:67)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.dispatch.DispatchInterceptor.invoke(DispatchInterceptor.java<br>
:72)</tt></font>
<br><font size=2><tt>at<br>
org.apache.geronimo.naming.java.ComponentContextInterceptor.invoke(Compo<br>
nentContextInterc<br>
eptor.java:56)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.ConnectionTrackingInterceptor.invoke(ConnectionTrackingInter<br>
ceptor.java:81)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic<br>
y.java:119)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction<br>
ContextIntercepto<br>
r.java:80)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.slsb.StatelessInstanceInterceptor.invoke(StatelessInstanceIn<br>
terceptor.java:98<br>
)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.transaction.ContainerPolicy$TxRequired.invoke(ContainerPolic<br>
y.java:140)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.transaction.TransactionContextInterceptor.invoke(Transaction<br>
ContextIntercepto<br>
r.java:80)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.SystemExceptionInterceptor.invoke(SystemExceptionInterceptor<br>
.java:82)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.GenericEJBContainer.invoke(GenericEJBContainer.java:238)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.proxy.EJBMethodInterceptor.intercept(EJBMethodInterceptor.ja<br>
va:129)</tt></font>
<br><font size=2><tt>at<br>
org.openejb.proxy.SessionEJBObject$$EnhancerByCGLIB$$39d68ea2.getTime(&lt;g<br>
enerated&gt;)</tt></font>
<br><font size=2><tt>at<br>
com.nis.timeserver.web.servlet.TimeServerServlet.doGet(TimeServerServlet<br>
.java:88)</tt></font>
<br><font size=2><tt>at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)<br>
at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)<br>
at</tt></font>
<br><font size=2><tt>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica<br>
tionFilterChain.j<br>
ava:252)</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt<br>
erChain.java:173)<br>
</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv<br>
e.java:213)</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv<br>
e.java:178)</tt></font>
<br><font size=2><tt>at<br>
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.inv<br>
oke(GeronimoStand<br>
ardContext.java:272)</tt></font>
<br><font size=2><tt>at<br>
org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(Transact<br>
ionContextValve.j<br>
ava:53)</tt></font>
<br><font size=2><tt>at<br>
org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(ComponentC<br>
ontextValve.java:<br>
47)</tt></font>
<br><font size=2><tt>at<br>
org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(InstanceCon<br>
textValve.java:60<br>
)</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java<br>
:126)</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java<br>
:105)</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.<br>
java:107)</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526<br>
)</tt></font>
<br><font size=2><tt>at<br>
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1<br>
48)</tt></font>
<br><font size=2><tt>at<br>
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85<br>
6)</tt></font>
<br><font size=2><tt>at<br>
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC<br>
onnection(Http11P<br>
rotocol.java:744)</tt></font>
<br><font size=2><tt>at<br>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint<br>
.java:527)</tt></font>
<br><font size=2><tt>at<br>
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow<br>
erWorkerThread.ja<br>
va:80)</tt></font>
<br><font size=2><tt>at<br>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool<br>
.java:684)</tt></font>
<br><font size=2><tt>at java.lang.Thread.run(Thread.java:534)<br>
</tt></font>
<br>
<br><font size=2><tt>Thanks and Regards,<br>
Ishwara Bhat V</tt></font>
<br>
<br><br><br><table bgcolor=white style="color:black"><tr><td><br>***********************************************************<br>
<br>
Please&nbsp;consider&nbsp;our&nbsp;environment&nbsp;before&nbsp;printing&nbsp;this&nbsp;email.<br>
<br>
This&nbsp;email&nbsp;and&nbsp;any&nbsp;attachments&nbsp;may&nbsp;be&nbsp;confidential&nbsp;and&nbsp;contain&nbsp;privileged<br>
&nbsp;information.&nbsp;If&nbsp;you&nbsp;are&nbsp;not&nbsp;the&nbsp;intended&nbsp;recipient&nbsp;you&nbsp;must&nbsp;not&nbsp;use,&nbsp;<br>
disclose,&nbsp;copy&nbsp;or&nbsp;distribute&nbsp;this&nbsp;communication.&nbsp;If&nbsp;you&nbsp;have&nbsp;received&nbsp;<br>
this&nbsp;message&nbsp;in&nbsp;error&nbsp;please&nbsp;delete&nbsp;and&nbsp;notify&nbsp;the&nbsp;sender.&nbsp;When&nbsp;communicating&nbsp;<br>
by&nbsp;email&nbsp;you&nbsp;consent&nbsp;to&nbsp;the&nbsp;monitoring&nbsp;and&nbsp;recording&nbsp;of&nbsp;that&nbsp;correspondence.<br>
<br>
The&nbsp;Attorney&nbsp;General&#39;s&nbsp;Department&nbsp;of&nbsp;NSW&nbsp;promotes&nbsp;a&nbsp;Just&nbsp;and&nbsp;Safe&nbsp;Society.&nbsp;<br>
Visit&nbsp;us&nbsp;at&nbsp;http://www.lawlink.nsw.gov.au<br>
</td></tr></table>
--=_alternative 00198A59CA257176_=--