Skip to content

TEXT column type is not supported (CLOB) #19

Description

@otoniel-isidoro

I got a problem. The column type TEXT (not varchar) on h2database is not supported by assertjdb too (It is mapped as object JdbcClob.class that implements the java.sql.CLOB).

Then I see that on AbstractDbData class is not mapped the CLOB type on the collectRowsFromResultSet method.
I suggest just add this type to get it as string as you can see below:

switch (type) {
        case Types.DATE:
          objectsList.add(resultSet.getDate(columnName));
          break;
        case Types.TIME:
          objectsList.add(resultSet.getTime(columnName));
          break;
        case Types.TIMESTAMP:
          objectsList.add(resultSet.getTimestamp(columnName));
          break;
        case Types.CLOB:
          objectsList.add(resultSet.getString(columnName));
          break;
        default:
          objectsList.add(resultSet.getObject(columnName));
          break;
        }

What do you think?

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions