title: ERROR: No suitable driver found for jdbc:derby:CoffeeDB;create=true
body: <p>I have spent quite some time reading previous posts, but none of them seem to help me. I'm trying to run a simple Java app from NetBeans, here the simplest code:</p>
  
  <pre><code>final String DB_URL = "jdbc:derby:CoffeeDB;create=true";         
  try
    {
       // Create a connection to the database.
       Connection conn = DriverManager.getConnection(DB_URL);
  
       // If the DB already exists, drop the tables.
       dropTables(conn);
  
       // Build the Coffee table.
       buildCoffeeTable(conn);
  
       // Close the connection.
       conn.close();
    }
    catch (Exception ex)
    {
       System.out.println("ERROR: " + ex.getMessage());
    }
  </code></pre>
  
  <hr>
  
  <p>Usually is the environmental variables causing trouble, but I have checked that and they seem to be set up correctly:</p>
  
  <p>CLASSPATH:
  C:\Program Files\Java\jdk1.7.0_17\db\lib\derby.jar;C:\Program Files\Java\jdk1.7.0_17\db\lib\derbytools.jar;</p>
  
  <p>DERBY_HOME
  C:\Program Files\Java\jdk1.7.0_17\db</p>
  
  <p>PATH:   (only the part concerning jdbc )
  C:\Program Files\Java\jdk1.7.0_17\db\bin</p>
  
  <p>I already created a table using ij from the command prompt and it worked, is when I try to run it through Netbeans when I get this error. Something interesting though, is when I run the sysinfo from the command prompt, it comes up like this:</p>
  
  <p>------------------ Java Information ------------------</p>
  
  <p>Java Version:    1.7.0_17</p>
  
  <p>Java Vendor:     Oracle Corporation</p>
  
  <p>Java home:       C:\Program Files\Java\jre7</p>
  
  <p>Java classpath:  C:\Program Files\Java\jdk1.7.0_17\db\lib\derby.jar;C:\Program Files\Java\jdk1.7.0_17\db\lib\derbytools.jar;C:\Program Files\Java\jdk1.7.0_17\db/lib/derby.jar;C:\Program Files\Java\jdk1.7.0_17\db/lib/derbynet.jar;C:\Program Files\Java\jdk1.7.0_17\db/lib/derbyclient.jar;C:\Program Files\Java\jdk1.7.0_17\db/lib/derbytools.jar</p>
  
  <p>OS name:         Windows Vista</p>
  
  <p>OS architecture: amd64</p>
  
  <p>OS version:      6.0</p>
  
  <p>---> As you can see, somehow more information is added to the previous classpath, and the derbytools.jar and derby.jar appear twice?? combined with inverted slashes??</p>
  
  <p>When debugging through NetBeans, the exception comes from this line in the DriverManager.java file:</p>
  
  <pre><code>    Connection con = aDriver.driver.connect(url, info);     &lt;--------------- here
      if (con != null) {
            // Success!
            println("getConnection returning " + aDriver.driver.getClass().getName());
            return (con);
      }
  </code></pre>
  
  <p>the url is correct: jdbc:derby:CoffeeDB;create=true    but the connection comes back null and throws the SQLexception.  Any ideas?</p>