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]
