For some info about the Tomcat support in the Web Tools Platform of Eclipse, see this FAQ:
http://wiki.eclipse.org/WTP_Tomcat_FAQ If you happen to have put your mysql driver jar in shared/lib, then this question might explain the behavior: http://wiki.eclipse.org/WTP_Tomcat_FAQ#Why_are_classes_in_my_Tomcat_installation.27s_shared.2Flib_not_seen_by_my_Web_application.3F If your mysql server access depends on changes to the server.xml made after the Eclipse Tomcat server was created, see this question: http://wiki.eclipse.org/WTP_Tomcat_FAQ#When_I_create_my_first_Tomcat_server.2C_why_is_a_Servers_project_created_in_my_workspace.3F If neither of these covers your situation, check the other questions to see if any might explain what is different between your Tomcat installation and the Tomcat server in Eclipse. Cheers, Larry P.S. That FAQ page can be fairly slow to come up, perhaps because of its size. Be patient. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > enterprises.com] > Sent: Monday, March 10, 2008 11:50 AM > To: Len Popp; Tomcat Users List > Subject: Re: Eclipse with tomcat and mysql > > 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(ComposableRe > questProcessor.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(BasicDataS > ource.java:1150) > >> > >> > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSour > ce.java:880) > >> > >> model.ArtistSearchService.selectArtists(ArtistSearchService.java:30) > >> > controller.ArtistSearchAction.execute(ArtistSearchAction.java:34) > >> > >> > org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteA > ction.java:58) > >> > >> > org.apache.struts.chain.commands.AbstractExecuteAction.execute(Abstract > ExecuteAction.java:67) > >> > >> > org.apache.struts.chain.commands.ActionCommandBase.execute(ActionComman > dBase.java:51) > >> > >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> > >> > org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.ja > va:304) > >> > >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> > >> > org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRe > questProcessor.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(BasicDataS > ource.java:1143) > >> > >> > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSour > ce.java:880) > >> > >> model.ArtistSearchService.selectArtists(ArtistSearchService.java:30) > >> > controller.ArtistSearchAction.execute(ArtistSearchAction.java:34) > >> > >> > org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteA > ction.java:58) > >> > >> > org.apache.struts.chain.commands.AbstractExecuteAction.execute(Abstract > ExecuteAction.java:67) > >> > >> > org.apache.struts.chain.commands.ActionCommandBase.execute(ActionComman > dBase.java:51) > >> > >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> > >> > org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.ja > va:304) > >> > >> org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) > >> > >> > org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRe > questProcessor.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]
