Timeout

[erick leal]

Hello, I'm trying to setup this driver with a simple query, but I'm having Wildfly timeouts.

Error:

11:56:21,626 INFO  [stdout] (ServerService Thread Pool -- 75) >>>>> Populando listas - Tue Sep 19 11:56:21 BRT 2017

11:56:22,086 INFO  [hsqldb.db.HSQLDB5E9AA3D631.ENGINE] (ServerService Thread Pool -- 75) Checkpoint start
11:56:22,086 INFO  [hsqldb.db.HSQLDB5E9AA3D631.ENGINE] (ServerService Thread Pool -- 75) checkpointClose start
11:56:22,123 INFO  [hsqldb.db.HSQLDB5E9AA3D631.ENGINE] (ServerService Thread Pool -- 75) checkpointClose end
11:56:22,126 INFO  [hsqldb.db.HSQLDB5E9AA3D631.ENGINE] (ServerService Thread Pool -- 75) Checkpoint end - txts: 1
11:56:22,439 INFO  [hsqldb.db.HSQLDB5E9AA3D631.ENGINE] (ServerService Thread Pool -- 75) dataFileCache open start
11:56:22,458 INFO  [hsqldb.db.HSQLDB5E9AA3D631.ENGINE] (ServerService Thread Pool -- 75) dataFileCache open end
11:58:57,166 ERROR [stderr] (ServerService Thread Pool -- 75) WARNING:Unknown expression: GenUniqueID() (default value of  column Int~lan table Dias Trabalhados)

11:58:57,288 ERROR [stderr] (ServerService Thread Pool -- 75) WARNING:Unknown expression: GenUniqueID() (default value of  column Int~lan table Folha de Ponto2)

11:58:57,975 ERROR [stderr] (ServerService Thread Pool -- 75) WARNING:Unknown expression: GenUniqueID() (default value of  column Int~lan table Folha de Ponto)

11:58:58,123 ERROR [stderr] (ServerService Thread Pool -- 75) WARNING:Unknown expression: GenUniqueID() (default value of  column Int~lan table Processos)

11:58:58,733 ERROR [stderr] (ServerService Thread Pool -- 75) WARNING:Unknown expression: GenUniqueID() (default value of  column Int~lan table INQUERITOS)

12:00:23,991 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0348: Timeout after [300] seconds waiting for service container stability. Operation will roll back. Step that first updated the service container was 'add' at address '[
    ("core-service" => "management"),
    ("management-interface" => "http-interface")`

Driver configuration:

Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
            String sql = "jdbc:ucanaccess://C:\\banco\\papuda.mdb;Skipindexes=true;memory=false";
            return DriverManager.getConnection(sql, "Admin", "pass");

Query:

public void testeSipen() throws SQLException {
        String sql = "select count(*) as cont from [INTERNO]";
        try (Connection con = ConnectionFactorySIpen.getConnection(); PreparedStatement stmt = con.prepareStatement(sql);) {
            try (ResultSet rs = stmt.executeQuery();) {
                while (rs.next()) {
                    System.out.println(rs.getString("cont"));
                }
            } catch (SQLException e1) {
                e1.printStackTrace();
            }
        }
    }

[Gord Thompson]

Are you able to open the database using plain JDBC in a simple method like this?

public static void main(String[] args) {
    String connUrl = "jdbc:ucanaccess://C:\\banco\\papuda.mdb;Skipindexes=true;memory=false";
    Long t0 = System.nanoTime();
    try (Connection conn = DriverManager.getConnection(connUrl)){
        System.out.printf("Database opened in %.3f seconds%n", 
                (System.nanoTime() - t0) / 1000000000.0);
    } catch (Exception e) {
        e.printStackTrace(System.err);
    }
}

 
If so, how long does it take?