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

 

 

1 comment
Comment actions Permalink

@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.

0

Please sign in to leave a comment.