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:INFORMIXSERVER=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]
