Hello, Thanks for reporting this. It appears that some database columns are reported to be of column type NULL through your combination of MySQL / MariaDB JDBC and JDBC DatabaseMetaData.
I wasn't aware of such a data type from MySQL itself, so I'm surprised to find this through the MariaDB JDBC driver. Can you provide me with a sample table (DDL) that will allow to reproduce this problem? Cheers Lukas 2013/8/7 <[email protected]> > *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. > > > -- 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.
