Re: Eclipse with tomcat and mysql

Mon, 10 Mar 2008 10:41:08 -0700 

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]























					Reply via email to