Search code examples
javamysqljdbc

java.sql.SQLException: No suitable driver found for jdbc:mysql:localhost:3306/androiddb


I am developing an Androip application that is intended to be integrated with some web services(jsp)For this,i am using Intellij Idea 11.1.3 to develop and my web server is Apache Tomcat 7(for the web service).When i try to load mysql driver as Class.forName("com.mysql.jdbc.Driver"); it is ok(no exception)but when i do

java.sql.Connection con = DriverManager.getConnection(DatabaseUrl,"root","root");

some exceptions are thrown as this:

java.sql.SQLException: No suitable driver found for jdbc:mysql:localhost:3306/androiddb at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.apache.jsp.add_jsp._jspService(add_jsp.java:78) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662)

As saying No suitable Driver found.But mysql driver(jar file)is attached to my module from Project Structure->Libraries->New Project Library.What can be the problem?


Solution

  • Your url is wrong; it should be jdbc:mysql://localhost:3306/androiddb (note the addition of // between jdbc:mysql: and localhost).

    See also Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J