title: sqlite jdbc Eclipse database relative path
body: <p>I'm trying to use Sqlite, jdbc under Eclipse Luna &amp; Windows 7.</p>
  
  <p>Everything works fine when I use absolute path to the Sqlite database but when relative path used I get this error:</p>
  
  <blockquote>
    <p>java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database.</p>
  </blockquote>
  
  <p>I spent some time Googling this problem and the answer is: Yes you can use relative path with jdbc connection. However it does not work for me.</p>
  
  <p><strong>My code:</strong></p>
  
  <pre><code>package PortiaMoxy;
  import static net.mindview.util.Print.*;
  String inPath; // incoming file
  String outPath; // converted file from incoming file
  public File() {
      // Connect to Sqlite db
      Connection c = null;
      Statement stmt = null;
      ResultSet rs = null;
      try {
          Class.forName("org.sqlite.JDBC");
          // 
          // This connection works fine
          // 
          //c = DriverManager.getConnection("jdbc:sqlite:/JavaProjects/workspace/Polymorphism/sources/PortiaMoxy/moxyimport.sqlite");
  
  
          //
          // This connection doesn't work. ???
          //
          c = DriverManager.getConnection("jdbc:sqlite:moxyimport.sqlite");
  
          c.setAutoCommit(false);
          print("File(): Opened database successfully.");
          stmt = c.createStatement();
  
  
          String query = "select ID \"id\", VALUE \"value\"";
          query += "from infiles;";
  
          rs = stmt.executeQuery(query);
  
          if (!rs.isBeforeFirst() ) {    
               System.out.println("No data"); 
              } 
  
  
          while(rs.next()) {
              String id = rs.getString(1);
              String value = rs.getString(2);
              print("   ID = " + id + " Value = " + value);
          } // end of while
          rs.close();
          stmt.close();
          c.close();
  
  
  
      } // end of try
      catch (SQLException ex) {
          print(ex.getClass().getName() + ": " + ex.getMessage());
          System.exit(0);
      }
      catch (Exception e ) {
          print(e.getClass().getName() + ": " + e.getMessage());
          System.exit(0);
      }
  
  
  
  } // end of class
  
  public int convert() {
      print(what());
  
      print("Generic convert");
      return 0;
  
  }
  
  public String what() {
      return "File";
  }
  
  }
  </code></pre>