Sproketboy

This is occurring for me when I change my HSQLDB dependency from 2.5.1 to 2.7.1 - I need to do this becuase of CVEs on the older version. Here's the error I get when I make a connection: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: net.ucanaccess.converters.Functions at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown...

Cool thanks!

Hi I'm using 5.0.1 with hsqldb 2.5.1

CREATE TABLE Customers ( [Customer ID] varchar(10) PRIMARY KEY NOT NULL, [Company Name] VARCHAR(30) NULL, [Contact Name] VARCHAR(30) NULL, [Contact Title] VARCHAR(10) NULL, [Address] VARCHAR(40) NULL, [City] VARCHAR(30) NULL, [Region] VARCHAR(10) NULL, [Postal Code] VARCHAR(10) NULL, [Country] VARCHAR(2) DEFAULT 'US', [Phone] VARCHAR(30) NULL, [Fax] VARCHAR(30) NULL, [Status] CHAR(1) NULL, [Date Registered] Timestamp DEFAULT NOW(), [Date Of Last Order] DATE, [Test Local Date] date, [Test Local DateTime]...

So you can't reproduce? Just try it and let me know. I'll check with ucanaccess.

Column name incorrect after create table.

Hi Marco. My fault. I also use HSQLDB for my project (https://sproket.github.io/Persism/) - I just need to use the same version you do for my unit tests - then it worked fine.

No answer? No upgrade path to Java 16 yet?