Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 37935 invoked from network); 23 Aug 2005 17:52:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 23 Aug 2005 17:52:50 -0000 Received: (qmail 24372 invoked by uid 500); 23 Aug 2005 17:52:34 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 24358 invoked by uid 500); 23 Aug 2005 17:52:34 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 24345 invoked by uid 99); 23 Aug 2005 17:52:34 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 Aug 2005 10:52:34 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [216.81.251.1] (HELO mail.printtime.com) (216.81.251.1) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 23 Aug 2005 10:52:50 -0700 Received: from [216.243.225.47] (HELO [192.168.2.128]) by mail.printtime.com (Stalker SMTP Server 1.8b8) with ESMTP id S.0003480604 for ; Tue, 23 Aug 2005 12:56:11 -0500 Message-ID: <430B61E7.3030101@printtime.com> Date: Tue, 23 Aug 2005 12:50:31 -0500 From: Brian Cook Reply-To: bcook@printtime.com Organization: Print Time Inc. User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tomcat Users List Subject: Re: jndi question References: <5684A7E6FB10504393A2806C1F4C0210076CE383@orion.qas.com> <430B5F70.5060802@gmail.com> In-Reply-To: <430B5F70.5060802@gmail.com> Content-Type: multipart/mixed; boundary="------------040309050309090602050101" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --------------040309050309090602050101 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Do not need the screen shots. Just copy and paste the stack trace error of the exception(All the gobblay gook that shows up on screen or in catalina.out when an exception is thrown.), the details of which ever combination of config files you are using, the code actually calling the JNDI resource. Just as a future reference including all of those things in your posts will help get a solution to your problem faster and will increase the number of people that will respond to your posts. You may find these posting guild lines helpful too. http://jakarta.apache.org/site/mail.html Sean Rowe wrote: > I will try all 3 once again, and provide screen shots of the errors I > see. I have tried these methods before, but I will try them again for a > sanity check. > sean > > Allistair Crossley wrote: > >> Hi, >> >> He isn't using that method of configuration, that's just 1 option of >> 3. He is nesting his Context definition within the server.xml Host >> element. Although this is now scorned, it's still valid. The 2 other >> methods are contextname.xml as you say, and also META-INF/context.xml >> within the webapp itself. Allistair. >> >> >> >>> -----Original Message----- >>> From: Brian Cook [mailto:bcook@printtime.com] >>> Sent: 23 August 2005 17:23 >>> To: Tomcat Users List >>> Subject: Re: jndi question >>> >>> >>> >>> Ok but do you have the resource defined in context.xml? If you go to >>> <>/conf/Cataliana/localhost/ do you see a file with the >>> name of the module ending with .xml? If so is the resource defined >>> in that file? If not you need to add it. >>> >>> From the description it sounds like nothing in this set up has been >>> done as was show on the example page. >>> >>> http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resources >>> -howto.html >>> >>> If you use the code block that is shown, define that resource in >>> web.xml and context.xml it will work. But multiple postings latter >>> it still sounds like the JNDI resource is not defined in context.xml >>> and the code calling the JNDI resource differs greatly from the >>> example provided. >>> >>> >>> Sean Rowe wrote: >>> >>> >>>> The first post on this included the server.xml, and further >>> >>> down in the >>> >>>> page is the relevant part of web.xml ( i just double >>> >>> checked that ). as >>> >>>> for context.xml, i have listed it in my webapp.xml file, as well as >>>> server.xml as all other examples have suggested. i then >>> >>> tried it in the >>> >>>> admin module, where it then put it in server.xml for me. >>> >>> i'm willing to >>> >>>> try anything at this point, though, if you have any suggestions. >>>> >>>> as for my post not being jndi specific, i applogize if >>> >>> that's the case. >>> >>>> i'm not really familiar with jndi....but when I did a search for >>>> 'connection pooling', jndi seemed to be what everyone >>> >>> suggested i use. >>> >>>> what i want to do, if it's not clear, is to create a >>> >>> connection pool to >>> >>>> my MySql database. >>>> thanks, >>>> sean >>>> >>>> Brian Cook wrote: >>>> >>>> >>>> >>>>> Actually the files I listed are NOT in the first post. It >>> >>> shows the >>> >>>>> server.xml and the code calling it but does not show web.xml or >>>>> context.xml. >>>>> >>>>> The error you are getting just means that that the JNDI >>> >>> resource being >>> >>>>> called in the code is not defined in both web.xml and context.xml. >>>>> >>>>> In looking at the code snip it in the first post I am not >>> >>> following >>> >>>>> what you are trying to do. The post is for a JNDI >>> >>> question but in the >>> >>>>> code it looks like you are calling the DB URL directly. The whole >>>>> point of JDNI being to get specific URL, and configuration info >>>>> outside of the code base. I am not following what it is you are >>>>> trying to do here. >>>>> >>>>> >>>>> >>>>> Sean Rowe wrote: >>>>> >>>>> >>>>> >>>>>> Brian, thank you for replying. I was afraid my topic was >>> >>> dead. If >>> >>>>>> you could look at my first post, I listed all the files >>> >>> that you have >>> >>>>>> suggested I take a look at. I have done everything you have >>>>>> suggested, but am still getting errors. The error I am >>> >>> getting now is >>> >>> >>>>>> javax.naming.NameNotFoundException: Name java:comp is not >>> >>> bound in >>> >>>>>> this Context >>>>>> >>>>>> I can't find anything on the net or in any books I've >>> >>> looked at that >>> >>>>>> explains this. As far as I can tell, java:comp should just be >>>>>> there. Any ideas? Thanks again. >>>>>> >>>>>> Sean >>>>>> >>>>>> Brian Cook wrote: >>>>>> >>>>>> >>>>>> >>>>>>> Yes you can use JNDI with out using JSTL. But the only way to >>>>>>> configure it is to define the JNDI resources in the web.xml and >>>>>>> context.xml files. Technically you should be able to use the >>>>>>> globally defined JNDI resources in server.xml, and I have seen >>>>>>> configuration set ups doing it when googling. But could >>> >>> never get >>> >>>>>>> them to work. >>>>>>> >>>>>>> This highlights another area of seemingly unneeded >>> >>> complication in >>> >>>>>>> Java/Unix development. Using JNDI for data sources which was >>>>>>> supposed to help you save time requires that you >>> >>> redundantly define >>> >>>>>>> the JNDI resource in at lest 2 if not 3 places. >>>>>>> >>>>>>> The admin tool which was also supposed to help save time >>> >>> defines the >>> >>>>>>> JNDI resources in server.xml which does not really seem >>> >>> to be all >>> >>>>>>> that helpful. I am sure there is likely a reason for >>> >>> this but I am >>> >>>>>>> ignorant of it. The admin tool is also supposed to let >>> >>> you define >>> >>>>>>> JNDI resources per context but it errors out when ever >>> >>> I have tried >>> >>>>>>> it. >>>>>>> >>>>>>> My experience with the Tomcat Admin and Manager tools is >>> >>> that they >>> >>>>>>> are worthless. Of the few steps they try to help with >>> >>> more often >>> >>>>>>> that not they just return errors when you need to use >>> >>> it. I removed >>> >>>>>>> them both and have gone back to doing set ups manually >>> >>> and there has >>> >>>>>>> not been much of a time difference doing it this way. >>>>>>> >>>>>>> Any way for JNDI to work you will have to add the >>> >>> definition for it >>> >>>>>>> in both web.xml and context.xml in the <>>>>>> Folder>>/conf/Catalina/localhost/ folder. This seems counter >>>>>>> productive since it makes your app less portable having the data >>>>>>> base configuration details inside the context and by >>> >>> extent the WAR >>> >>>>>>> file but it is what you have to do to get it to work right now. >>>>>>> >>>>>>> I feel your pain I know it is frustrating spending hours >>> >>> debugging >>> >>>>>>> just the DB connection but todate that is the reality of >>> >>> Java web >>> >>>>>>> app development. It is why I fear we will all be .Net >>> >>> developers >>> >>>>>>> some day. >>>>>>> >>>>>>> >>>>>>> Example : >>>>>>> >>>>>>> >>> >>> http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resources >>> -howto.html >>> >>>>>>> >>>>>>> >>>>>>> Context initCtx = new InitialContext(); >>>>>>> Context envCtx = (Context) initCtx.lookup("java:comp/env"); >>>>>>> DataSource ds = (DataSource) >>>>>>> envCtx.lookup("jdbc/EmployeeDB"); >>>>>>> >>>>>>> Connection conn = ds.getConnection(); >>>>>>> ... use this connection to access the database ... >>>>>>> conn.close(); >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Resource reference to a factory for java.sql.Connection >>>>>>> instances that may be used for talking to a particular >>>>>>> database that is configured in the server.xml file. >>>>>>> >>>>>>> >>>>>>> jdbc/EmployeeDB >>>>>>> >>>>>>> >>>>>>> javax.sql.DataSource >>>>>>> >>>>>>> >>>>>>> Container >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> auth="Container" >>>>>>> type="javax.sql.DataSource" >>>>>>> username="dbusername" >>>>>>> password="dbpassword" >>>>>>> driverClassName="org.hsql.jdbcDriver" > >>>>>>> >>>> url="jdbc:HypersonicSQL:database" >>>>>>> maxActive="8" >>>>>>> maxIdle="4"/> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> Sean Rowe wrote: >>>>>>> >>>>>>> >>>>>>> >>>>>>>> Dirk, I'm sorry I didn't see the difference on the page >>>>>>>> >>> >>> you sent me >>> >>>>>>>> to. However, if there is a way I can do this without >>> >>> having to use >>> >>>>>>>> jstl, I would really like to know. I was hoping to put >>>>>>>> >>> >>> the code in >>> >>>>>>>> a class somewhere that my servlets could use. >>>>>>>> >>>>>>>> thanks, >>>>>>>> sean >>>>>>>> >>>>>>>> Dirk Weigenand wrote: >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>>> Sean, >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>>> --- Urspr�ngliche Nachricht --- >>>>>>>>>> Von: Sean Rowe >>>>>>>>>> An: Tomcat Users List >>>>>>>>>> Betreff: Re: jndi question >>>>>>>>>> Datum: Mon, 22 Aug 2005 09:24:10 -0500 >>>>>>>>>> >>>>>>>>>> Thanks for responding Dirk. I've practically memorized the >>>>>>>>>> documentation on the link you sent: >>>>>>>>>> >>>>>>>>>> // Obtain our environment naming context >>>>>>>>>> Context initCtx = new InitialContext(); >>>>>>>>>> Context envCtx = (Context) initCtx.lookup("java:comp/env"); >>>>>>>>>> >>>>>>>>>> // Look up our data source >>>>>>>>>> DataSource ds = (DataSource) >>>>>>>>>> envCtx.lookup("jdbc/EmployeeDB"); >>>>>>>>>> >>>>>>>>>> // Allocate and use a connection from the pool >>>>>>>>>> Connection conn = ds.getConnection(); >>>>>>>>>> ... use this connection to access the database ... >>>>>>>>>> conn.close(); >>>>>>>>>> >>>>>>>>>> Whenever I try this, here's what I get (which led me >>>>>>>>>> >>> >>> to trying it >>> >>>>>>>>>> the way >>>>>>>>>> I posted): >>>>>>>>>> >>>>>>>>>> javax.naming.NameNotFoundException: Name java:comp is >>>>>>>>>> >>> >>> not bound >>> >>>>>>>>>> in this >>>>>>>>>> Context >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> No. Did you look at >>>>>>>>> >>>>>>>>> >>> >>> http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasourc >>> e-examples-howto.html? >>> >>>>>>>>> I recommend putting the context definition in its own >>>>>>>>> >>> >>> content.xml. On >>> >>> >>>>>>>>> redeploying my application tomcat wouldn't find the >>> >>> driver class >>> >>>>>>>>> anymore. >>>>>>>>> >>>>>>>>> Mind you not the class itself but the definition of >>> >>> what class to >>> >>>>>>>>> load. >>>>>>>>> >>>>>>>>> This problem was solved by putting the context into >>> >>> context.xml. >>> >>> >>>>>>>>> regards >>>>>>>>> Dirk >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>> >>> --------------------------------------------------------------------- >>> >>> >>>>>>>> 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 >>> >>> >>>> >>> >>> --------------------------------------------------------------------- >>> >>> >>>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org >>>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org >>>> >>>> >>>> >>> >>> -- >>> Brian Cook >>> Digital Services Analyst >>> Print Time Inc. >>> bcook@printtime.com >>> 913.345.8900 >>> >>> >>> >> >> >> >> >> ------------------------------------------------------- >> QAS Ltd. >> Registered in England: No 2582055 >> Registered in Australia: No 082 851 474 >> ------------------------------------------------------- >> >> >> >> --------------------------------------------------------------------- >> 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 > > -- Brian Cook Digital Services Analyst Print Time Inc. bcook@printtime.com 913.345.8900 --------------040309050309090602050101 Content-Type: text/plain; charset=us-ascii --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org --------------040309050309090602050101--