Re: Eclipse with tomcat and mysql

Mon, 10 Mar 2008 18:27:08 -0700
So I found this out the hard way. Eclipse overwrote my $CATALINA_HOME/conf/Catalina/localhost/<webapp>.xml 


Now I can't see to get the DB connected outside of Eclipse either. I can't 
remember what the syntax on the context was since I had to try many 
different suggestions I found on the web before one worked. The TC docs 
don't seems to be correct for version 5.5.


Is thie the correct syntax?


<context reloadable="true" path="/musicDB" debug="5" crosscontext="true" 
docbase="musicDB">



     <logger timestamp="true" suffix=".txt" prefix="localhost_musicDB_log." 
classname="org.apache.catalina.logger.FileLogger">


     <resource username="javauser" password="javadude"

           url="jdbc:mysql://localhost:3306/musicDB?autoReconnect=true"

           type="javax.sql.DataSource" auth="Container" name="jdbc/musicDB"

           driverclassname="com.mysql.jdbc.Driver" maxwait="5000"

           maxactive="4" maxidle="2"/>

</context>



Thanks

Kevin




----- Original Message ----- 
From: "Len Popp" <[EMAIL PROTECTED]>

To: "Tomcat Users List" <users@tomcat.apache.org>
Sent: Monday, March 10, 2008 4:42 PM
Subject: Re: Eclipse with tomcat and mysql



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]




---------------------------------------------------------------------
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