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]