Jefferson Poe

Hello, When trying to open this MS Access file (file too large to share on forum), we're getting the following exception: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.0 unexpected token: VARCHAR required: FOR at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:231) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at Runner.testOpenProblemAccessFile(Runner.java:20) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native...

UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (myID counter PRIMARY KEY, myCurrency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column...

UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (myID counter PRIMARY KEY, myCurrency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column...

UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (myID counter PRIMARY KEY, myCurrency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column...

UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLE mytable1 (ID counter PRIMARY KEY, currency currency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROM mytable1 WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column will...

UCanAccess version: 5.0.0 JDK: 8 and 11 (tested on both) Steps to repro: 1. create a new table that has a "Currency" type column: CREATE TABLEmytable1(IDcounter PRIMARY KEY,currencycurrency) 2. read the schema of the table using ResultSetMetadata of the following statement: SELECT * FROMmytable1WHERE 1=0 3. inspect the precision and display width of the "Currency" column Result: Sometimes, the created column will have precision = 8, and display size = 10 Other times, the created column will have...

thanks for confirming that Marco!

hello, from reading a couple threads around the "NOT NULL" constraint for UCanAccess, I come to the conclusion that there is a fundamental difference between HSQLDB and MS Access, in which HSQLDB forces users to deal with nulls before a NOT NULL constraint can be applied to a column. Is the team currently considering to implement ALTER COLUMN NOT NULL ? or is this feature unplanned for the reasonable future?