java - No suitable driver found for jdbc:mysql -


trying connect free mysql database host permits remote connections error:

no suitable driver found jdbc:mysql://xx2-23-x1-2x1-172.compuxe-1.xmazonaws.com:3306

i use code below.

 try{       class.forname("com.mysql.jdbc.driver");     system.out.println("driver loaded");     }     catch(classnotfoundexception e){         system.out.println(e.getmessage());     }     try{        string host = "jdbc:mysql://xx2-23-x1-2x1-172.compuxe-1.xmazonaws.com:3306/xxxxx";         conn = drivermanager.getconnection(host,"xxxxx","xxxxx");         system.out.println("connection established");     }

thanks in advance.

edit

stack trace appears below:

java.sql.sqlexception: no suitable driver found jdbc:mysql://xx2-23-x1-2x1-172.compuxe-1.xmazonaws.com:3306     @ java.sql.drivermanager.getconnection(drivermanager.java:604)     @ java.sql.drivermanager.getconnection(drivermanager.java:221)     @ databaseconnectivitymodule.(databaseconnectivitymodule.java:21)     @ userfrontend.(userfrontend.java:34)     @ userfrontend$8.run(userfrontend.java:399)     @ java.awt.event.invocationevent.dispatch(invocationevent.java:251)     @ java.awt.eventqueue.dispatcheventimpl(eventqueue.java:701)     @ java.awt.eventqueue.access$000(eventqueue.java:102)     @ java.awt.eventqueue$3.run(eventqueue.java:662)     @ java.awt.eventqueue$3.run(eventqueue.java:660)     @ java.security.accesscontroller.doprivileged(native method)     @ java.security.protectiondomain$1.dointersectionprivilege(protectiondomain.java:76)     @ java.awt.eventqueue.dispatchevent(eventqueue.java:671)     @ java.awt.eventdispatchthread.pumponeeventforfilters(eventdispatchthread.java:244)     @ java.awt.eventdispatchthread.pumpeventsforfilter(eventdispatchthread.java:163)     @ java.awt.eventdispatchthread.pumpeventsforhierarchy(eventdispatchthread.java:151)     @ java.awt.eventdispatchthread.pumpevents(eventdispatchthread.java:147)     @ java.awt.eventdispatchthread.pumpevents(eventdispatchthread.java:139)     @ java.awt.eventdispatchthread.run(eventdispatchthread.java:97)

you should make code follow:

try {     class.forname("com.mysql.jdbc.driver");     string host = "jdbc:mysql://xx2-23-x1-2x1-172.compuxe-1.xmazonaws.com:3306/xxxxx";     conn = drivermanager.getconnection(host,"xxxxx","xxxxx"); } catch (exception e) {     e.printstacktrace(); }

also verify mysql jdbc library in classpath. library can downloaded here.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

jquery - How would i go about shortening this code? And to cancel the previous click on click of new section? -

my code below changes image people in team sector, can see theres alot of repeated code; there way shorten it? also currently, allows click on sections without turning off clicked one; assume toggle() function, couldn't work other way! still quite new jquery coding, grand!! cheers in advance! $("#team_client_services").click(function () { if ($(".team_client_services").hasclass("team_hide")) { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); } else { $(".team_client_services").toggleclass("team_hide"); $(".team_client_services2").toggleclass("team_show"); }; }); $("#team_management").click(function () { if ($(".team_management").hasclass("team_hide")) { $(".team_management").toggleclass("team_hide"); $(".team_management2...
Read more