title: Java: ucanaccess hsqldb java.lang.NoSuchMethodError:
body: <p>I downloaded and installed the uCanAccess jars by following instructions from here:
  <a href="https://stackoverflow.com/questions/21955256/manipulating-an-access-database-from-java-without-odbc">Manipulating an Access database from Java without ODBC</a>
  I'm learning how to use the microsoft access db for java and this is the coding I used</p>
  
  <pre><code>package Main.Net;
  
  import java.sql.*;
  
  
  public class DataBase {
  
      Connection con;
      Statement st;
      ResultSet rs;
  
  
  
      public DataBase() {
  
      }
  
      private void connect() {
  
          try {
              //String driver = "sun.jdbc.odbc.jdbcodbcdriver";
              //Class.forName(driver);
  
              String db = "jdbc:ucanaccess://C:/Users/MyUser/workspace/Connectors_DB.accdb";
              con = DriverManager.getConnection(db);
              st = con.createStatement();
              String sql = "select * from Table";
              rs = st.executeQuery(sql);
  
              while(rs.next()) {
  
                  String username = rs.getString("Username");
                  String password = rs.getString("Password");
  
                  System.out.println(username + "\t" + password);
              }
  
          } catch(Exception e) {
              e.printStackTrace();
          }
      }
  
      public static void main(String[] args) {
          new DataBase().connect();
      }
  }
  </code></pre>
  
  <p>and when I run the java program, it comes with this error</p>
  
  <pre><code>Exception in thread "main" java.lang.NoSuchMethodError: org.hsqldb.DatabaseURL.parseURL(Ljava/lang/String;ZZ)Lorg/hsqldb/persist/HsqlProperties;
  at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
  at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at net.ucanaccess.jdbc.DBReference.getHSQLDBConnection(DBReference.java:354)
  at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:206)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at Main.Net.DataBase.connect(DataBase.java:23)
  at Main.Net.DataBase.main(DataBase.java:42)
  </code></pre>
  
  <p>error is at this code:</p>
  
  <pre><code>String db = "jdbc:ucanaccess://C:/Users/MyUser/workspace/Connectors_DB.accdb";
  con = DriverManager.getConnection(db);
  </code></pre>
  
  <p>does it have something to do with the version of the hsqldb? because if it does I already tried downloading other versions of hsqldb and the same error appears</p>
  
  <p>here are the jars I'm using:</p>
  
  <p>ucanaccess-2.0.9.3.jar</p>
  
  <p>commons-lang-2.6.jar</p>
  
  <p>commons-logging-1.1.1.jar</p>
  
  <p>hsqldb.jar</p>
  
  <p>jackcess-2.0.8.jar</p>
  
  <p>so... how can I fix this?</p>