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 <[email protected]> wrote:
From: Pid <[email protected]>
Subject: Re: deploying web application on remote server
To: "Tomcat Users List" <[email protected]>
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 <[email protected]> wrote:
>
> From: Pid <[email protected]>
> Subject: Re: deploying web application on remote server
> To: "Tomcat Users List" <[email protected]>
> 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: [email protected]
> For additional commands, e-mail: [email protected]
>
>
>
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
