title: how to solve java.sql.SQLException: No suitable driver found for jdbc:derby:
body: <p>Good Morning everyone,</p>
  
  <p>I have an issue trying to get my database working. I'm working with Eclipse and Apache Derby 10.12.1.1.
  When I'm in the Database Developement Perspective I have no trouble connecting to my database and editing my table.
  <a href="https://i.stack.imgur.com/0c10U.png" rel="nofollow noreferrer">Picture of Connected DB</a></p>
  
  <p>To connect to the Database I use the Derby Embedded JDBC Driver Version 10.2. But when I try to access my Database from a java program it gives me an SQLException: no suitable driver found.
  Here is my code:</p>
  
  <pre><code>public class Test3 {
  
      public static void main(String[] args) throws ClassNotFoundException, SQLException {
          Connection connection = DriverManager.getConnection("jdbc:derby:.../DB/db;create=false");
  
          Statement stmt = connection.createStatement();
          ResultSet rs = stmt.executeQuery("SELECT * FROM USERS WHERE USERS.USERID = 123456");
          int i = 1;
          while (rs.next()) {
              System.out.println(i + ": " + rs.getString(1) + ", " + rs.getString(2));
              i++;
          }
          stmt.close();
          connection.close();
      }
  }
  </code></pre>
  
  <p>and the ErrorMassage looks like this:</p>
  
  <pre><code>Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc:derby:.../DB/db;create=false
      at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
      at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:251)
      at scraping/other.Test3.main(Test3.java:12)
  </code></pre>
  
  <p>Can someone help me?</p>
  
  <p>Kind Regards,</p>
  
  <p>Patty23</p>