Tables named as database keywords

[sergey...@themidnightcoders.com]

I am trying to inspect my MySQL database tables and columns using SchemaCrawlerUtility.getCatalog( dataSource.getConnection(), options ) method.

I just mentioned that if a table is named as MySQL keyword, like DataBase, DATE, or insert, then the above method returns its name in quotes like `DataBase`. `DATE` or `insert`, while other table names are returned as-is, like SomeTableName or mytable.

Is there any option how I can get rid of those quotes? Otherwise I would have to iterate through results and remove them from names manually.

[Lukas Eder]

Hi Sergey,

How can we help you on the jOOQ user group? I suspect that SchemaCrawlerUtility is from a different library... jOOQ-meta and jOOQ's org.jooq.Meta APIs will not add any quotes around your database identifiers when you fetch them...

Best Regards,

Lukas

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[sergey...@themidnightcoders.com]

Oh, really, this library is not of yours.

Sorry for the inconvenience!