disable quotes for database fields
i configured ucanaccess library to be able to read an access database in datagrip
and it partially works but the problem is that when i do anything datagrip uses quotes for the tables and fields
for example double clicking a table will give this error :
UCAExc:::4.0.4 unexpected token: MyTable
the log shows this query failed when opening the table :
SELECT t.* FROM "MyTable" t
if i just remove the quotes it works but i cant find a way to configure it at database level so it can open the table normally by just double clicking it or doing any other action
Please sign in to leave a comment.
@Contacto,
What JDBC driver do you use?
As a temporary workaround you can write SQL query in console, execute it and work with Result set.
I am using the UCanAccess 5.0.1. bin version of the jar. When adding a custom driver connection to access in the datagrid, I double-click on the table name under public, and it prompts [42582] [-5582] UCAExc:.: 5.0.1 unknown token: PUBLIC, is this a bug
This is likely caused due to incorrect JDBC driver implementation resulting in this issue. Have you tested the connection with older driver versions (v5 / v4)? Please also let me know your current DataGrip IDE version.