So you're putting the <webapp>.xml file into conf/Catalina yourself, right? That could be the problem because of the way Web Standard Tools copies files around (or doesn't) when you "Publish" the webapp. I don't know all the details, but some files in workspace/Servers/Tomcat v5.5 Server are copied to another directory deep under the workspace dir.
The usual place to put the <Context> declaration is inside the webapp, in the file META-INF/context.xml. Tomcat copies that file at startup to $CATALINA_HOME/conf/Catalina/localhost/<webapp>.xml. And that still works under Eclipse. Try doing it that way, unless you have a strong reason to keep the <Context> declaration outside of the webapp itself. -- Len On Mon, Mar 10, 2008 at 2:42 PM, <[EMAIL PROTECTED]> wrote: > This did not work either. > > There is a "<EclipseWorkspace>/Servers/Tomcat v5.5 Server at > localhost-config" directory which contains a copy of the tomcat conf files > such as server.xml. > I tried adding the DB driver context to this server.xml file but got the > same issue. > > For Tomcat 5.5 I had to add the database context to > <TOMCATDIR>/conf/Catalina/localhost/<webappname>.xml > It would not work in the <TOMCATDIR>/conf/server.xml > > So I also tried copying the <TOMCATDIR>/conf/Catalina to > "<EclipseWorkspace>/Servers/Tomcat v5.5 Server at localhost-config/Catalina" > > Neither of these worked. > > > Kevin > > > ----- Original Message ----- > From: "Len Popp" <[EMAIL PROTECTED]> > To: "Tomcat Users List" <users@tomcat.apache.org> > > > Sent: Monday, March 10, 2008 8:54 AM > Subject: Re: Eclipse with tomcat and mysql > > > > Web Standard Tools makes copies of some of the Tomcat config files, > > which might be causing your problem. In particular, if you've defined > > your JDBC resource in server.xml it might not be seen by Tomcat when > > you run it from Eclipse. If that's the case, update the copy of > > server.xml in your Eclipse workspace (it might be in > > workspace/Servers/Tomcat v5.5 Server @ localhost-config but I think > > that depends on settings and version). And remember to click "Publish" > > in the servers window. > > -- > > Len > > > > On Mon, Mar 10, 2008 at 11:49 AM, <[EMAIL PROTECTED]> wrote: > >> Eclipse (Eurpoa) version 3.1.1 > >> > >> I am using the Web Standard Tools. (The project I created is a Dynamic > >> Web > >> Project). > >> > >> I do NOT have the Sysdeo Tomcat plugin. Would this help? > >> > >> Thanks, > >> Kevin > >> > >> > >> > >> ----- Original Message ----- > >> From: "Len Popp" <[EMAIL PROTECTED]> > >> To: "Tomcat Users List" <users@tomcat.apache.org>; > >> <[EMAIL PROTECTED]> > >> Sent: Monday, March 10, 2008 6:42 AM > >> Subject: Re: Eclipse with tomcat and mysql > >> > >> > >> > What version of Eclipse are you using, and what extensions are you > >> > using for your webapp project (e.g. Web Standard Tools or Sysdeo > >> > Tomcat plug-in)? > >> > -- > >> > Len > >> > > >> > On Mon, Mar 10, 2008 at 11:32 AM, <[EMAIL PROTECTED]> > >> wrote: > >> >> Hello, > >> >> > >> >> I'm having trouble getting Eclipse to work with Mysql/Tomcat. > >> >> > >> >> In Eclipse, I have set up a project and have added a Tomcat server > >> and > >> >> added the project to the server. > >> >> The project consists of a simple example of a standard struts > >> >> architecture for the MVC. > >> >> > >> >> Model: Artist.java, ArtistSearchService.java > >> >> View: search.jsp, SearchForm.java > >> >> Controller: ArtistSearchAction.java > >> >> > >> >> The ArtistSearchSerview.java connects to mysql, searches for Artists > >> and > >> >> creates Artists objects. > >> >> > >> >> If I deploy this to Tomcat, every thing works fine. > >> >> > >> >> But when I run inside Eclipse it will not connect to the database. I > >> get > >> >> the errors listed below. > >> >> Funny thing is, in Eclipse I have also tried setting a data source > >> for > >> >> this database. > >> >> This also works fine and I can connect to the DB from the data > >> source, > >> >> but I still get the error. > >> >> > >> >> So how do you use Eclipse with Tomcat and MySQL? Any ideas? > >> >> > >> >> Thanks in advance for the help, > >> >> Kevin > >> >> > >> >> HTTP Status 500 - > >> >> > >> > >> >> > -------------------------------------------------------------------------------- > >> >> > >> >> type Exception report > >> >> > >> >> message > >> >> > >> >> description The server encountered an internal error () that > >> prevented > >> >> it from fulfilling this request. > >> >> > >> >> exception > >> >> > >> >> javax.servlet.ServletException: Cannot create JDBC driver of class > >> '' > >> >> for connect URL 'null' > >> >> > >> >> > >> > org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:286) > >> >> > >> >> > >> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) > >> >> > >> >> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) > >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:710) > >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > >> >> > >> >> root cause > >> >> > >> >> org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC > >> >> driver of class '' for connect URL 'null' > >> >> > >> >> > >> > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1150) > >> >> > >> >> > >> > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) > >> >> > >> >> model.ArtistSearchService.selectArtists(ArtistSearchService.java:30) > >> >> > >> controller.ArtistSearchAction.execute(ArtistSearchAction.java:34) > >> >> > >> >> > >> > org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) > >> >> > >> >> > >> > org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) > >> >> > >> >> > >> > org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) > >> >> > >> >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> >> > >> >> > >> > org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304) > >> >> > >> >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> >> > >> >> > >> > org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) > >> >> > >> >> > >> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) > >> >> > >> >> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) > >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:710) > >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > >> >> > >> >> root cause > >> >> > >> >> java.sql.SQLException: No suitable driver > >> >> java.sql.DriverManager.getDriver(Unknown Source) > >> >> > >> >> > >> > org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1143) > >> >> > >> >> > >> > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) > >> >> > >> >> model.ArtistSearchService.selectArtists(ArtistSearchService.java:30) > >> >> > >> controller.ArtistSearchAction.execute(ArtistSearchAction.java:34) > >> >> > >> >> > >> > org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) > >> >> > >> >> > >> > org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) > >> >> > >> >> > >> > org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) > >> >> > >> >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> >> > >> >> > >> > org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304) > >> >> > >> >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> >> > >> >> > >> > org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) > >> >> > >> >> > >> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) > >> >> > >> >> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) > >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:710) > >> >> javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > >> >> > >> >> note The full stack trace of the root cause is available in the > >> Apache > >> >> Tomcat/5.5.26 logs. > >> >> > >> >> > >> > >> >> > -------------------------------------------------------------------------------- > >> >> > >> >> Apache Tomcat/5.5.26 > >> >> > >> >> > >> >> > >> >> > >> >> > >> > >> > > > > > > --------------------------------------------------------------------- > > To start a new topic, e-mail: users@tomcat.apache.org > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
