Scheuraa

Thank u. With the 4.0.8 it works correctly

Hey, yes Text works, but DOUBLE and INT (Datatype.LONG) also didnt work

Yes the other one is the initial version. This is the broken one. I only changed the boolean and the String also changed to an empty String

Hello, i run the following Code: String url = "jdbc:ucanaccess://" + dbPath + ";openExclusive=true;immediatelyReleaseResources=true;singleconnection=true"; try { long startTime = new Date().toInstant().toEpochMilli(); UcanaccessConnection con = (UcanaccessConnection)DriverManager.getConnection(url); long endTime = new Date().toInstant().toEpochMilli(); System.out.println("Creating connection took: " + (endTime-startTime) + " ms"); startTime = new Date().toInstant().toEpochMilli(); Statement st =...

Hello, i run the following Code: String url = "jdbc:ucanaccess://" + dbPath + ";openExclusive=true;immediatelyReleaseResources=true;singleconnection=true"; try { long startTime = new Date().toInstant().toEpochMilli(); UcanaccessConnection con = (UcanaccessConnection)DriverManager.getConnection(url); long endTime = new Date().toInstant().toEpochMilli(); System.out.println("Creating connection took: " + (endTime-startTime) + " ms"); startTime = new Date().toInstant().toEpochMilli(); Statement st =...

Hello, i run the following Code: String url = "jdbc:ucanaccess://" + dbPath + ";openExclusive=true;immediatelyReleaseResources=true;singleconnection=true"; try { long startTime = new Date().toInstant().toEpochMilli(); UcanaccessConnection con = (UcanaccessConnection)DriverManager.getConnection(url); long endTime = new Date().toInstant().toEpochMilli(); System.out.println("Creating connection took: " + (endTime-startTime) + " ms"); startTime = new Date().toInstant().toEpochMilli(); Statement st =...

I am using Access 2021 and Jackcess 4.0.7

I tested the whole thing with an new Testdatabase which i created new and has only one table with 2 rows of data and then i run the following code: try { Database db = DatabaseBuilder.open(new File(Link to db)); Table test = db.getTable("TestTable"); ColumnBuilder cb = new ColumnBuilder("isRegressed"); cb.setType(DataType.BOOLEAN); cb.addToTable(test); db.close(); } catch (IOException e) { e.printStackTrace(); } After that i modify the database with Acces and then some fields in the modified row...