title: netbeans with glassfish have no suitable driver found for mysql:jdbc
body: <p>I am a noob in java ee</p>
  
  <p>But to learn it I should connect to mysql!</p>
  
  <p>I have googled about a day:</p>
  
  <pre><code>Class.forName("com.mysql.jdbc.Driver").newInstance();
  Connection connection = DriverManager.getConnection("mysql:jdbc://127.0.0.1:3036/shedule", "root", "12345");
  </code></pre>
  
  <p>said:</p>
  
  <p><strong>java.sql.SQLException: No suitable driver found for mysql:jdbc://127.0.0.1:3036/shedule</strong></p>
  
  <p>0) mysql -h 127.0.0.1 -P 3306 -u root -p works</p>
  
  <p>2) netstat said that mysqld listened to 0.0.0.0:3306</p>
  
  <p>3) lastest netbeans 6.9.1 + glassfish 3.0.1</p>
  
  <p>4) I have ONLY mysql-connector-java-5.1.6-bin.jar no other jars! searched at all hard drives before and after deploy!</p>
  
  <p>it seat at:
  D:\Program Files\NetBeans 6.9\ide\modules\ext and
  D:\NetBeansProjects\MyProject\build\web\WEB-INF\lib</p>
  
  <p>5) I have selected "add Library" and mysql-connector-java-5.1.6-bin.jar</p>
  
  <p>6) people said that netbeans deploy this jar to
  D:\Program Files\glassfish-3.0.1\glassfish\domains\domain1\lib
  But after deploy there are no mysql-connector-java-5.1.6-bin.jar</p>
  
  <p><strong>7) I have unpacked source of this connector (5.1.14) to my src/java folder</strong></p>
  
  <p><strong>added libraries ant-contrib.jar c3p0-0.9.1-pre6.jar and jboss-common-jdbc-wrapper.jar</strong></p>
  
  <p><strong>My project builds and deploys normaly but work with this exception!</strong></p>
  
  <p>Finaly:
  <img src="https://i.stack.imgur.com/5dPD8.png" alt="alt text"></p>