Re: Eclipse with tomcat and mysql

Mon, 10 Mar 2008 18:53:35 -0700

For the most part -- just remember case matters. It's Context, not context. Same is true for Logger and Resource as well.
See http://tomcat.apache.org/tomcat-5.5-doc/config/index.html for further information regarding tomcat config. BTW, what about the 5.5 docs specifically doesn't seem correct? 

--David

[EMAIL PROTECTED] wrote:



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]




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