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]
