tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sneha Manohar <sneha_hams...@yahoo.co.in>
Subject unable to connect to mysql on remote server
Date Thu, 12 Feb 2009 23:47:45 GMT
Hi ,
I am trying to connect to mysql on remote server using following code 
Class.forName("com.mysql.jdbc.Driver").newInstance();
        
 String connectionURL = "jdbc:mysql://remoteHostIp:3306/test"; 
       
        
 Connection connection = DriverManager.getConnection(connectionURL, "root", "");
 
I get following errorjavax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure

Last packet sent to the server was 0 ms ago.
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
	org.apache.jasper.runtime.PageContextImpl.access$1100(PageContextImpl.java:71)
	org.apache.jasper.runtime.PageContextImpl$12.run(PageContextImpl.java:768)
	java.security.AccessController.doPrivileged(Native Method)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:766)
	org.apache.jsp.test_jsp._jspService(test_jsp.java:75)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:616)
	org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:244)
	java.security.AccessController.doPrivileged(Native Method)
	javax.security.auth.Subject.doAsPrivileged(Subject.java:537)
	org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:276)
	org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:162)



--- On Fri, 13/2/09, Pid <p@pidster.com> wrote:

From: Pid <p@pidster.com>
Subject: Re: deploying web application on remote server
To: "Tomcat Users List" <users@tomcat.apache.org>
Date: Friday, 13 February, 2009, 4:52 AM

Sneha Manohar wrote:
> Hi ,
> Thanks for your reply ,  remote server is on ubuntu Operating system . 
> Version of tomcat - 6
> Version of java - jdk1.6.
>  
> I  try to load driver ""com.mysql.jdbc.Driver" , I have put
"mysql-connector-java-5.1.5-bin" in WEB-INF /lib folder , I get class
not found exception error . 
>  
> I wish to know how tomcat locate libraries . Do I need to add anything in
the path .
> It works on local ,I use net beans , I add the libraries  by clicking
'Add library'-> Global library ->mysql driver. How do I achieve
this on remote server .

You're adding it to the Global libraries for what purpose?

If *Tomcat* needs DB access then the jars go in tomcat/lib.

If *your app* needs DB access then the jars go in WEB-INF/lib, (unless
there's already a copy in tomcat/lib).


p




> sneha
>  
>  
> 
> 
> --- On Thu, 12/2/09, Pid <p@pidster.com> wrote:
> 
> From: Pid <p@pidster.com>
> Subject: Re: deploying web application on remote server
> To: "Tomcat Users List" <users@tomcat.apache.org>
> Date: Thursday, 12 February, 2009, 11:57 PM
> 
> Sneha Manohar wrote:
>> Hi ,
>>  
>> I have developed web application using netbeans , I wish to deploy on
> remote server .
>> I have placed files under / webapps  directory of remote server.
Tomcat is
> unable to locate libraries .  how do I make tomcat locate libraries which
are
> under WEB-INF/lib folder
>>  
>> sneha
>>
>>
>>       Connect with friends all over the world. Get Yahoo! India
Messenger
> at http://in.messenger.yahoo.com/?wm=n/
> 
> 
> to the tune of "Humpty Dumpty"
> 
> The Original Poster sent an email
> The Original Poster had a vague FAIL
> All the list members and all of the devs
> Couldn't put Tomcat together again.
> 
> 
> because you didn't tell us what operating system you're using,
what
> version of tomcat, java etc, or what your log error messages said.
> 
> ?
> 
> p
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
> 
> 
> 
> 
>       Unlimited freedom, unlimited storage. Get it now, on
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org




      Add more friends to your messenger and enjoy! Go to http://messenger.yahoo.com/invite/
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message