UCanAccess Initializer Error (compile/run without IDE)

by

If you are not using an IDE then you need to specify the CLASSPATH entries for the JAR files of UCanAccess and all of its dependencies (HSQLDB, Jackcess, etc.). One way to do that is to use the -cp option of the java command when you run your code.

For example, after I compile the following code in “UcaNoIde.java” …

import java.sql.*;

public class UcaNoIde {

    public static void main(String[] args) {
        String dbFileSpec = "C:/Users/Public/UCanAccessTest.accdb";
        String connStr = "jdbc:ucanaccess://" + dbFileSpec;
        try (Connection conn = DriverManager.getConnection(connStr)) {
            System.out.println("Connection established.");
        } catch (Exception e) {
            e.printStackTrace(System.err);
        }
    }

}

… into a “UcaNoIde.class” file I can run it using the following command at my Windows command prompt:

java -cp .;C:/Users/Public/Downloads/UCanAccess/ucanaccess-3.0.3.jar;C:/Users/Public/Downloads/UCanAccess/lib/commons-lang-2.6.jar;C:/Users/Public/Downloads/UCanAccess/lib/commons-logging-1.1.1.jar;C:/Users/Public/Downloads/UCanAccess/lib/hsqldb.jar;C:/Users/Public/Downloads/UCanAccess/lib/jackcess-2.1.3.jar UcaNoIde

(For Linux, et. al. the -cp entries will be separated by colons (:) instead of semicolons (;) and the file paths will be a bit different.)

Another possibility is to define a CLASSPATH environment variable with the same entries as in the -cp option above so you don’t have to use -cp every time.

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. ClassNotFoundException com.mysql.jdbc.Driver [duplicate]
  4. Efficient way to do batch INSERTS with JDBC
  5. What is the actual use of Class.forName(“oracle.jdbc.driver.OracleDriver”) while connecting to a database?
  6. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  7. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  8. java.sql.SQLException: Exhausted Resultset
  9. java.util.stream with ResultSet
  10. handling DATETIME values 0000-00-00 00:00:00 in JDBC
  11. JDBC ResultSet get columns with table alias
  12. How to start a transaction in JDBC?
  13. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  14. Driver JDBC PostgreSQL with Android [duplicate]
  15. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  16. oracle.jdbc.driver.OracleDriver ClassNotFoundException
  17. Populating jTable using database data
  18. How to simulate a DB for testing (Java)?
  19. is there a standard way to define a JDBC Datasource for Java EE containers?
  20. I’m getting a java.lang.classnotfoundexception: com.mysql.jdbc.Driver
  21. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  22. How to get *everything* back from a stored procedure using JDBC
  23. Using a prepared statement and variable bind Order By in Java with JDBC driver
  24. How do I unit test jdbc code in java? [closed]
  25. Java 7 Automatic Resource Management JDBC (try-with-resources statement)
  26. How to map a ResultSet with unknown amount of columns to a List and display it in a HTML table?
  27. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  28. MyBatis executing multiple sql statements in one go, is that possible?
  29. A persistent connection with JDBC to MySQL
  30. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR

Leave a Comment