Eric said: > Also, I noticed in many solutions the suggestion was made to edit the > myapp.xml file located at CATALINA_HOME/conf/Catalina/localhost/. > However, there is no myapp.xml in that directory on my server. Just 2 > .xml's related to other applications and a manager.xml which I'm not > sure what it's related to.
when you deploy a "mywebapp" from a warfile that includes a META-INF/context.xml, TC copies that file to conf/Catalina/localhost/mywebapp.xml. having said that there appear to be situations where TC does and does not copy that file. all I can say is that it works for me (5.0.28). Or, you can create that file yourself. whichever way it's created, its contents are taken as though they were inserted as a context under the Catalina/localhost host in server.xml. this is the preferred way to config a context since v5.x (rather than putting it in server.xml). manager.xml is for the manager webapp. > -----Original Message----- > From: Nick Pellow [mailto:[EMAIL PROTECTED] > Sent: Friday 05 November 2004 07:40 > To: Tomcat Users List > Subject: AW: {an alternative}Re: connection pooling > > > HI Eric, > > > I have seen the same error your are getting. I am using tomcat 5.0.28. > Make sure that you have removed the expanded war directories, from > "webapps" and ${CATALINA_HOME}/work before restarting. > > Also look inside > those other context.xmls inside > ${CATALINA_HOME}/conf/Catalina/localhost > and make sure that they do not define a context with path="/wms". > > Cheers, > nick. > > >-----Ursprungliche Nachricht----- > >Von: Eric Wulff [mailto:[EMAIL PROTECTED] > >Gesendet: Freitag, 5. November 2004 07:35 > >An: Atishay Kumar > >Cc: Tomcat Users List > >Betreff: Re: {an alternative}Re: connection pooling > > > > > >Atishay, the DefaultContext does work once I comment out the other > >Engine element. You mentioned that means something is wrong with my > >Context? So what next? > > > >many thx > >Eric > > > > > >On Thu, 4 Nov 2004 22:21:57 -0800, Eric Wulff > <[EMAIL PROTECTED]> wrote: > >> This did not work. In looking for the Engine element you > speak of I > >> didn't find it exactly. I did find it with it with an > extra attribute > >> <Engine name="Standalone"... jvmRoute="jvm1">. Furthermore, this > >> element was nested within the <Service> element and there > is another > >> <Engine name="Catalina"...> element. I tried with and without the > >> jvmRoute element. No success. Same exception. > >> > >> Eric > >> > >> On Fri, 5 Nov 2004 11:20:26 +0530, Atishay Kumar > >> > >> > >> <[EMAIL PROTECTED]> wrote: > >> > If adding <Resouce name ......./> did not work..then try > following > >> > > >> > On Thu, 4 Nov 2004 19:46:30 -0800, Eric Wulff > <[EMAIL PROTECTED]> wrote: > >> > > Hi all, I'm returning to a problem I couldn't solve > the first time, > >> > > about two months ago, and still can't seem to figure out. I > >can't get > >> > > a db connection using connection pools. I get the > exception listed > >> > > below, same as so many have previously, but nothing > I've found seems > >> > > to works. Below are my specs. Anyone with concrete > advise/direction > >> > > on how to get > >> > > this working? > >> > > > >> > > Also, I noticed in many solutions the suggestion was > made to edit the > >> > > myapp.xml file located at > CATALINA_HOME/conf/Catalina/localhost/. > >> > > However, there is no myapp.xml in that directory on my > server. Just 2 > >> > > .xml's related to other applications and a manager.xml > which I'm not > >> > > sure what it's related to. > >> > > > >> > > OS: FC2 > >> > > Tomcat 5.0.28 > >> > > > >> > > exception: org.apache.commons.dbcp.SWLNestedException: > Cannot create > >> > > JDBC driver class '' for connect URL 'null' > >> > > > >> > > WEB-INF web xml: code inserted AFTER all servlet mappings... > >> > the following shld be in > >> > <web-app> > >> > > <resource-ref> > >> > <description>My Datasource</description> > >> > > <res-ref-name>jdbc/wms</res-ref-name> > >> > > <res-type>javax.sql.DataSource</res-type> > >> > > <res-auth>Container</res-auth> > >> > > </resource-ref> > >> > </web-app> <!-- I am sure u have this right--> > >> > > > >> > > server xml(tried this with and without a Resource name)... > >> > The following shld be under > >> > <Engine name="Standalone" defaultHost="localhost" debug="0"> > >> > > >> > REplace > >> > <Context path="/wms" docBase="wms" debug="0" reloadable="true"> > >> > with > >> > <DefaultContext> > >> > <Resource name="jdbc/wms" auth="Container" > >type="javax.sql.DataSource"/> > >> > > <ResourceParams name="jdbc/wms"> > >> > > <parameter> > >> > > <name>username</name> > >> > > <value>whatever</value> > >> > > </parameter> > >> > > <parameter> > >> > > <name>password</name> > >> > > <value>whatever</value> > >> > > </parameter> > >> > > <parameter> > >> > > <name>driverClassName</name> > >> > > <value>com.informix.jdbc.IfxDriver</value> > >> > > </parameter> > >> > > <parameter> > >> > > <name>url</name> > >> > > > ><value>jdbc:informix-sqli://foo.bar.com:somePort/dbName:INFORMIXSER > >VER=serverName</value> > >> > > </parameter> > >> > > </ResourceParams> > >> > replace > >> > </Context> > >> > with > >> > </DefaultContext> > >> > <!-- > >> > If this works them there is something wrong with your context. we > >> > shall figure that out later but first <DefaultContext> > should work!! > >> > restart tommy after making changes. > >> > hope it works!! > >> > --> > >> > > > >> > > I have the following jars in my > <CATALINA_HONE>/common/lib and I also > >> > > tried putting the db driver and commons-collections, dbcp, > >and pool in > >> > > my WEB-INF/lib with no success. They are all mode 644. > >> > > > >> > > ant.jar > >> > > ant-launcher.jar > >> > > commons-collections-3.1.jar > >> > > commons-dbcp-1.2.1.jar > >> > > commons-el.jar > >> > > commons-pool-1.2.jar > >> > > ifxjdbc.jar (the necessary informix driver) > >> > > jar.txt > >> > > jasper-compiler.jar > >> > > jasper-runtime.jar > >> > > jsp-api.jar > >> > > mysql-connector-java-3.0.15-ga-bin.jar > >> > > naming-common.jar > >> > > naming-factory.jar > >> > > naming-java.jar > >> > > naming-resources.jar > >> > > servlet-api.jar > >> > > > >> > > On Fri, 8 Oct 2004 11:45:59 +0530, Atishay Kumar > >> > > <[EMAIL PROTECTED]> wrote: > >> > > > hi, > >> > > > i am not sure but you may try downloading latest > jar files for > >> > > > following froom tomcat site and try them out. copy the old > >jar files > >> > > > somewhere else and try using the latest jar files. > >> > > > 1) Commons Collections > >> > > > 2)Commons DBCP > >> > > > 3)Commons Pool > >> > > > > >> > > > > >> > > > > >> > > > > >> > > > On Thu, 7 Oct 2004 15:29:40 -0700, Eric Wulff > ><[EMAIL PROTECTED]> wrote: > >> > > > > Except that the driver works for connecting if I'm not > >utilizing a > >> > > > > connection pool, i.e., I am able to connect to the db > >and manipulate > >> > > > > data via DriverManager.getConnection(url, db, pwd). > >> > > > > > >> > > > > The driver is located in CATALINA_HOME/commons/lib > >> > > > > > >> > > > > Eric > >> > > > > > >> > > > > On Thu, 7 Oct 2004 18:22:45 -0400, Phillip Qin > >> > > > > <[EMAIL PROTECTED]> wrote: > >> > > > > > No, you don't need that many params. I think your > >problem might be the > >> > > > > > >> > > > > > >> > > > > > driver. Where did you drop off your informix jdbc jar? > >> > > > > > > >> > > > > > > >> > > > > > -----Original Message----- > >> > > > > > From: Eric Wulff [mailto:[EMAIL PROTECTED] > >> > > > > > Sent: October 7, 2004 5:56 PM > >> > > > > > To: Tomcat Users List > >> > > > > > Subject: Re: connection pooling > >> > > > > > > >> > > > > > Yes, I have added <Resource name=... >. Now different > >errors are reported > >> > > > > > via stack trace as I posted in response to Atishay's > >suggestion that I add > >> > > > > > this. I'll try adding your suggestions and see what > >happens. Also, you > >> > > > > > suggest adding many parameters. Are they necessary > >for simply making a > >> > > > > > connection? If so, the tutorial I'm following, > >'Tomcat Kick Start' left all > >> > > >> > -- > >> > :) > >> > Atishay Kumar > >> > Btech, SEM VII > >> > DA-IICT > >> > Gandhinagar - 382009 > >> > India > >> > ph: +91 9825383948 > >> > > >/****************************************************************** > >********** > >> > * Learn the rules as you would need them to break them > properly * > >> > > >******************************************************************* > >*********/ > >> > > >> > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
