title: Struggling with a Java JDBC:sqlite connection using Intellij
body: <p>My full project is on Github.com/DSkilton</p>
  
  <p>I have tried dozens of ways to get this to work, I've read about classpaths, using Class.forName() and not using it, Xerials JDBC <a href="https://github.cm/xerial/sqlite-jdbc" rel="nofollow noreferrer">instructions</a> which suggests using / rather than escaping \ for the path String. I've read through some of Oracles suggestions, Stackoverflow and SQlites <a href="http://www.sqlitetutorial.net/sqlite-java/sqlite-jdbc-driver/" rel="nofollow noreferrer">tutorial</a> on how to set up. I've really <em>tried</em> to research this but am still coming up blank! </p>
  
  <p>Inside my src folder are the following folders: controller, images, lib, model, sample and view. </p>
  
  <p>In the controller folder is databaseConnect.java and in the lib folder is jdbc-api-1.4.jar.</p>
  
  <p>In my databaseConnect file I have the following:</p>
  
  <pre><code>public static void Connection() {
  
      final String connectionUrl = "jdbc:sqlite:D:\\Users\\IdeaProject\\modus\\src\\model\\modus.db";
  
      try {
          Connection con = DriverManager.getConnection(connectionUrl);
          System.out.println("Connected");
          //while(returnStatement.next()) {
          //System.out.println("rs.getString");
          //}
  
          } catch (SQLException e) {
          e.printStackTrace();
  }
  </code></pre>
  
  <p>The error I get is: </p>
  
  <pre><code>java.sql.SQLException: No suitable driver found for jdbc:sqlite:D:\\Users\\Duncan Skilton\\IdeaProject\\modus\\src\\model\\modus.db
  at java.sql.DriverManager.getConnection(DriverManager.java:689)
  at java.sql.DriverManager.getConnection(DriverManager.java:270)
  at controller.databaseConnect.Connection(databaseConnect.java:16)
  at sample.Main.main(Main.java:28)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at com.sun.javafx.application.LauncherImpl.launchApplicationWithArgs(LauncherImpl.java:389)
  at com.sun.javafx.application.LauncherImpl.launchApplication(LauncherImpl.java:328)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at sun.launcher.LauncherHelper$FXHelper.main(LauncherHelper.java:767)
  </code></pre>
  
  <p>Process finished with exit code -1</p>
  
  <p>Anything you can suggest will be massively appreciated!</p>