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

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -