Problems with UCanAccess 4.0.3 and SQL Workbench/J Build 123

[mauromol]

Hello,
I just set up SQL Workbench/J Build 123 by adding UCanAccess jar file (and its dependencies) to access a MDB database. The same setup procedure was followed to let OpenOffice 4.1.5 to access the same database with no problem, but OpenOffice doesn't let me edit the mdb directly, it rather creates an odf linked to the mdb. Instead, I would need to change the mdb directly.

So, I tried SQL Workbench/J. However, when I try to opent he Database Explorer, I get this error:

UCAExc:::4.0.3 invalid schema name: UCA_METADATA [SQL State=3F000, DB Errorcode=-4850]

Then, I try to make a direct query from a table named FORUM_TOPICS that I know for sure exists:
SELECT * FROM FORUM_TOPICS;
but another error message is given:

UCAExc:::4.0.3 user lacks privilege or object not found: FORUM_TOPICS [SQL State=42501, DB Errorcode=-5501]

Any help would be greatly appreciated.

Thanks in advance,
Mauro

[Gord Thompson]

Perhaps try adding ;showSchema=true to the end of your JDBC connection URL.

[mauromol]

Indeed, this fixes both errors I was seeing, thank you very much!!