https://bugs.documentfoundation.org/show_bug.cgi?id=145205
--- Comment #5 from Alex Thurgood <[email protected]> --- @Alexander That error message is thrown when the connector is incapable of recognizing a field data type. Below are the currently defined/recognized field types : case MYSQL_TYPE_TINY returns getByte(nColumnIndex); case MYSQL_TYPE_SHORT returns getShort(nColumnIndex); case MYSQL_TYPE_LONG and case MYSQL_TYPE_INT24 returns getInt(nColumnIndex); case MYSQL_TYPE_LONGLONG returns getLong(nColumnIndex); case MYSQL_TYPE_FLOAT returns getFloat(nColumnIndex); case MYSQL_TYPE_DOUBLE returns getDouble(nColumnIndex); case MYSQL_TYPE_TIMESTAMP and case MYSQL_TYPE_DATETIME returns getTimestamp(nColumnIndex); case MYSQL_TYPE_DATE returns getDate(nColumnIndex); case MYSQL_TYPE_TIME returns getTime(nColumnIndex); case MYSQL_TYPE_STRING and case MYSQL_TYPE_VAR_STRING and case MYSQL_TYPE_DECIMAL and case MYSQL_TYPE_NEWDECIMAL all return getString(nColumnIndex); case MYSQL_TYPE_BLOB throws an SQLException("Column with type BLOB cannot be converted", *this, "22000", 1, Any()). I don't see a specific "BIT" data type in the list above, which would probably explain why the error is thrown. If confirmed, this could be made into a RequestForEnhancement for someone to add support for the BIT datatype. As a comparison, did you try the same thing over a JDBC connector (msyql JDBC connector or the mariadb JDBC connector) ? -- You are receiving this mail because: You are the assignee for the bug.
