java - Unable to connect to mySQL database using JSP -
i'm trying establish connection database using following servlet: (the work done in doget method)
package demo; import java.io.ioexception; import java.io.printwriter; import java.sql.connection; import java.sql.drivermanager; import java.sql.sqlexception; import javax.servlet.servletexception; import javax.servlet.annotation.webservlet; import javax.servlet.http.httpservlet; import javax.servlet.http.httpservletrequest; import javax.servlet.http.httpservletresponse; @webservlet("/connect") public class connect extends httpservlet { private static final long serialversionuid = 1l; /** * @see httpservlet#httpservlet() */ public connect() { super(); // todo auto-generated constructor stub } protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { printwriter out = response.getwriter(); try { class.forname("com.mysql.jdbc.driver"); } catch (classnotfoundexception e) { out.println("unable load database."); return; } connection conn = null; try { conn = drivermanager.getconnection("jdbc.mysql://localhost:3306/jakesdb", "root", "sixteen58"); } catch (sqlexception e) { out.println("unable connect database."); return; } //// connected database. work here //////////// out.println("connected database!"); /////////////////////////////////////////////////////////// try { conn.close(); } catch (sqlexception e) { out.println("unable close connection database."); } } }
however, getting hung at
try { conn = drivermanager.getconnection("jdbc.mysql://localhost:3306/jakesdb", "root", "sixteen58"); } catch (sqlexception e) { out.println("unable connect database."); return; }
i have verified using sql workbench username (root) , password (sixteen58) correct, , port indeed 3306. have mysql-connector-java-5.1.36.zip in libraries , it's linked properly. i'm not sure going on every time see "unable connect database" when run page.
any idea i'm doing wrong?
you did minor mistake. need colon :
instead of .
@ database url of getconnection
method. change like:
"jdbc:mysql://localhost:3306/jakesdb" // use : instead of .
Comments
Post a Comment