0

I have this code to connect to Access Database with UCanAcess library.

      public Visualizzazioni_Access() {
        try {
            log=new MyLog4J();

            File dbFile = new File("CassaGestionale.accdb");
            String path = dbFile.getAbsolutePath();
            db=DriverManager.getConnection("jdbc:ucanaccess://"+path);
            connesso=true;
            System.out.println("Connection Succesfull");


        } catch (Exception e) {
            connesso=false;
            log.logStackTrace(e);
        }
    }

The code works, so when I try to connect I have this debug message? It's an error or not?

DEBUG [AWT-EventQueue-0] (DatabaseImpl.java:831) - Finished reading system catalog.  Tables: [CodScontrini, Scontrini]
WARNING:Error in the metadata of the table CodScontrini: table's row count in the metadata is 373 but 374 records have been found and loaded by UCanAccess. All will work fine, but it's better to repair your database.
 WARN [AWT-EventQueue-0] (IndexData.java:328) - unsupported data type BINARY for index, making read-only
Connection Succesfull
bircastri
  • 2,169
  • 13
  • 50
  • 119

1 Answers1

1

It's because an inconsistency has been detected between the number of records actually found and the number of records registered in the metadata for the table named "CodScontrini". This doesn't cause issues but by using the Compact and Repair Database feature in Access you can easily restore the table metadata into a correct state from the previous state which had some degree of corruption.

Gord Thompson
  • 116,920
  • 32
  • 215
  • 418
jamadei
  • 1,700
  • 9
  • 8