ok, figured I'd reply to this post one more time because I think this issue is directly related to the context descriptor and anyone who is using MySQL and upgrading from tomcat 5.0.28 to 5.5.16, and likely other versions. You need to configure the resource factory differently than how the docs direct for 5.0.28. While it is clearly documented under 5.5 docs in the JNDI section, I did not notice it in any update/changes notes.
ok, in 5.0.28 I set up my resource factory in my context.xml a <Resource name="jdbc/yadayada" type="javax.sql.datasource" auth="Container" /> tag followed by a ResourceParams element with various nested <parameter> elements mapping <name>, <value> pairs. This did not work for me in 5.5.16 and (error msg is copied below). Instead I needed to include all my parameter names and values within the <Resource /> tag itself - no <ResourceParams> element. So, along with name, type, auth, I also included driverClassName, username, password, url, etc right in the <Resource> tag of the context.xml. dig? Eric On 4/3/06, Eric Wulff <[EMAIL PROTECTED]> wrote: > ok, I solved the problem for my configuration and perhaps my solution > will help you. I'm running tomcat 5.5.16 on win XP and java 1.5_06. > > I have my webapp sitting in a directory titled ROOT instead of appName > as I had it in tomcat 5.0.28 (of course I renamed the original ROOT > directory to something else). I have no context at Catlina/localhost. > Instead, I have context.xml in a META-INF directory -> > ROOT/META-INF/context.xml. > > <Context path="" docBase="ROOT" debug="0" reloadable="true" > antiResourceLocking="false" antiJARLocking="false" > > > Now my webapp is recognized by tomcat exactly how I want - at the > ROOT. Hopefully this helps you. > > > and now for something completely different - I'm having problems with > mysql db connection now ... > > "ERROR cims.FilterDispatcher - EXCEPTION: getConnectionFromPool(): > attempting to get connection from db: MysqlSf: > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC > driver of class '' for connect URL 'null'" > > perhaps this is due to the fact that my app is now in a directory > called ROOT instead of appName. Anyway, I'm off to check into this > some more. > > Eric > > > On 4/3/06, Eric Wulff <[EMAIL PROTECTED]> wrote: > > I'm having the exact same problem and have followed a similar path > > looking for a solution - but no success yet. I'll keep the list > > posted if I find anything. I eagerly await suggestions here too of > > course. > > > > thx > > Eric > > > > > > On 4/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > I'm migrating web applications from Tomcat v.4 to v.5.5 and having some > > > trouble adapting my old virtual hosts setup with the 5.5 recommended > > > methods. > > > > > > According to http://tomcat.apache.org/tomcat-5.5-doc/config/context.html > > > "In addition to nesting Context elements inside a Host element, you can > > > also store them: in individual files (with a ".xml" extension) in the > > > $CATALINA_HOME/conf/[enginename]/[hostname]/ directory" > > > > > > So to make sure I know what I'm doing, I used a server.xml with this: > > > > > > <Engine name="Catalina" defaultHost="localhost"> > > > <Realm className="org.apache.catalina.realm.UserDatabaseRealm" > > > resourceName="UserDatabase"/> > > > <Host name="localhost" appBase="webapps" unpackWARs="true" > > > autoDeploy="true" xmlValidation="false" xmlNamespaceAware="false"> > > > </Host> > > > </Engine> > > > > > > And then created a file $CATALINA_HOME/conf/Catalina/localhost/sean.xml > > > with my Context element, which reads, > > > > > > <Context path="" docBase="ROOT"></Context> > > > > > > But when I start Tomcat, I get surprising errors. First... > > > > > > Apr 3, 2006 3:05:13 PM org.apache.catalina.startup.HostConfig > > > deployDescriptor > > > WARNING: A docBase /var/tomcat5/webapps/ROOT inside the host appBase > > > has been specified, and will be ignored > > > > > > Although Tomcat seems to be trying to read my docBase param, something is > > > not right. It thinks "appBase" is a host.[?] Then I get... > > > > > > Apr 3, 2006 3:05:13 PM org.apache.catalina.core.StandardContext > > > resourcesStart > > > SEVERE: Error starting static Resources > > > java.lang.IllegalArgumentException: Document base > > > /var/tomcat5/webapps/sean does not exist or is not a readable directory > > > > > > Tomcat seems to be looking for a web app by the name of "sean" from the > > > filename "sean.xml." But according to > > > http://tomcat.apache.org/tomcat-5.5-doc/deployer-howto.html "If a Context > > > Descriptor is... ...manually created, the filename need not match the web > > > application name as Tomcat is concerned only with the Context > > > configuration contained within the Context Descriptor file(s)." > > > > > > With Tomcat 4 I had my Context Descriptors outside of server.xml and > > > separated by virtual hosts in individual files very similar to v5.5's > > > $CATALINA_HOME/conf/[enginename]/[hostname]/ approach, but now I can't > > > seem to get grasp how exactly v.5.5. wants it done. > > > > > > What am I missing? > > > > > > Thanks in advance, > > > > > > > > > > > > S e a n H a r r i s o n > > > - - - > > > Internet Services Administrator > > > Lincoln, Nebraska > > > > > > --------------------------------------------------------------------- > > > 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]
