Hi Ahmed, The default MetaProvider uses JDBC DatabaseMetaData and doesn't cache itself. You can implement your own MetaProvider, where you cache the results e.g. using Meta.snapshot(), or you can use another implementation, e.g. a DDL based one: https://www.jooq.org/doc/latest/manual/sql-execution/meta-data/
There's indeed a missing feature where our lookups are capable of being case-insensitive: https://github.com/jOOQ/jOOQ/issues/9239 Until then, it will be necessary to have a MetaProvider that provides the identifiers in the correct case I hope this helps, Lukas On Wed, May 1, 2024 at 11:43 AM Ahmed Ghanmi <[email protected]> wrote: > We are trying to test parsing with meta lookups. However, we had two > issues : > - jOOQ was attempting to fetch metadata with every connection even when > the DSLContext is reused. Are we missing something in the settings? > - it seems that jOOQ isn't identifying tables/columns unless the > identifiers were quoted (examples in the java file provided). It would be > helpful if it could apply some transformations on the results of the lookup > (similar to identifier styling rules RenderQuotedNames RenderNameCase). > > > -------- > > jOOQ Version > org.jooq.pro-java-8:3.19.6 > > > Database product and version > Oracle Database 11g Release 11.2.0.4.0 - 64bit Production > > PostgreSQL 14.5 > > Java Version > OpenJDK Runtime Environment Temurin jdk8u402-b06 > > OS Version > OpenSUSE Leap 42.3 > > JDBC driver name and version (include name if unofficial driver) > com.oracle.jdbc:12.2.0.1 > org.postgresql:42.2.18 > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/bb3c8f6e-f508-477b-ba9d-752190434618n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/bb3c8f6e-f508-477b-ba9d-752190434618n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6SSQ4FsRTLuPkd8LPnYpL6s72YQuXYTQQ%3D65YMfNRApQ%40mail.gmail.com.
