i am trying to get a connection with my database but i get the following error:<\/p>\n
java.sql.SQLException: No suitable driver found for jdbc:mysql:\/\/localhost\/sondazh\n at java.sql.DriverManager.getConnection(Unknown Source)\n at java.sql.DriverManager.getConnection(Unknown Source)\n at admin.ConnectionManager.openConnection(ConnectionManager.java:31)\n at admin.ConnectionManager.getConnection(ConnectionManager.java:44)\n at admin.DatabaseObject.(DatabaseObject.java:12)\n at org.apache.jsp.test_jsp._jspService(test_jsp.java:85)\n at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)\n at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)\n at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\n at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)\n at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)\n at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)\n at java.lang.Thread.run(Unknown Source)\nnull\n<\/code><\/pre>\ni have created a code in java for connection with mysql database.<\/p>\n
package admin;<\/p>\n
import java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.SQLException;\n\n\npublic class ConnectionManager {\n private static ConnectionManager instance = null;\n\n private static final String USERNAME = \"root\";\n private static final String PASSWORD = \"\";\n private static final String CONN_STRING =\n \"jdbc:mysql:\/\/localhost\/sondazh\";\n\n private Connection conn = null;\n\n private ConnectionManager() {\n }\n\n public static ConnectionManager getInstance() {\n if (instance == null) {\n instance = new ConnectionManager();\n }\n return instance;\n }\n\n private boolean openConnection() {\n try {\n\n conn = DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);\n return true;\n } catch (SQLException e) {\n e.printStackTrace();\n }\n\n return false;\n\n }\n\n public Connection getConnection() {\n if (conn == null) {\n try {\n if (openConnection()) {\n return conn;\n } else {\n return null;\n }\n } catch (Exception e) {\n \/\/ TODO Auto-generated catch block\n throw new Error(e);\n }\n }\n return conn;\n }\n\n public void close() {\n try {\n conn.close();\n conn = null;\n } catch (Exception e) {\n }\n }\n\n}\n<\/code><\/pre>\ni also searched in google for that prob but the URL is ok and i dont know what may be the problem!<\/p>\n
Originally posted 2013-11-09 23:31:35. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
i am trying to get a connection with my database but i get the following error: java.sql.SQLException: No suitable driver found for jdbc:mysql:\/\/localhost\/sondazh at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at admin.ConnectionManager.openConnection(ConnectionManager.java:31) at admin.ConnectionManager.getConnection(ConnectionManager.java:44) at admin.DatabaseObject.(DatabaseObject.java:12) at org.apache.jsp.test_jsp._jspService(test_jsp.java:85) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1135","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1135"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1135\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}