Steven Cooke - 2020-10-01

I have ucanaccess 4.0.4, jackcess 2.1.11 and hsqldb.jar . I was under the impression that these versions supported creation of indexes but I get an error saying its unsupported. Maybe its my syntax although it looks correct to me. I'm using MS Access 2010

This is part of the code

st.execute("CREATE TABLE tblTemp (reqno TEXT, technique TEXT)");
System.out.println("tblTemp table created");

When I check the table is there with the columns I expected. I then run this immediatley after

st.execute("CREATE INDEX tech ON tblTemp(reqno)");

but I get this error

net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.4 net.ucanaccess.jdbc.FeatureNotSupportedException: Feature not supported yet.
at net.ucanaccess.jdbc.UcanaccessStatement.execute(UcanaccessStatement.java:159)

yet the ucanaccess website says version 4.0.4 does support it so Im a little confused as to what the issue is.

I'm assuming the index name can be anything?

Steve