*Versions* JOOQ 3.1.0 MySQL 5.1.70 MariaDB JDBC 1.1.3 Java 1.7.0_21 *Description* Calling DSLContext.getTables() causes the warning: "Not supported by dialect : Type NULL is not supported in dialect MYSQL"
The warning is output for each column that is NULL. The results from DatabaseMetaData.getTables() are passed to org.jooq.impl.MetaDataFieldProvider in the method MetaImpl.getTables() In my case a call using DatabaseMetaData .getTables() returned the following: getColumnName():getColumnTypeName() TABLE_SCHEMA:VARCHAR TABLE_SCHEM:NULL TABLE_NAME:VARCHAR TABLE_TYPE:VARCHAR TABLE_COMMENT:VARCHAR TYPE_CAT:NULL TYPE_SCHEM:NULL TYPE_NAME:NULL SELF_REFERENCING_COL_NAME:NULL REF_GENERATION:NULL The Java JDBC API says that some of the columns returned from DatabaseMetaData.getTables() can be NULL: http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTables%28java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[]%29 *Impact* Apart from filling logs with lines of code, none that I noticed. *Workaround* - Turn off the logger for "org.jooq.impl.MetaDataFieldProvider" when calling getTables(). - Cache the results so that getTables() isn't called again. -- 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]. For more options, visit https://groups.google.com/groups/opt_out.
