Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-809

SelectResultSet's (ResultSet)MetaData always indicates all columns to be readonly

Details

    Description

      org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet#getMetadata always returns a MariaDbResultSetMetaData which is not updatable, which results in isReadOnly(int column) to always return true

      JDBC state that https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/ResultSetMetaData.html#isReadOnly(int) Indicates whether the designated column is definitely not writable. Driver indicate that resultset not an updatable resultset and all its columns are readOnly.

      Instead only effectively readOnly-columns should return true

      PS: discussion leading to this Issue https://lists.launchpad.net/maria-discuss/msg05864.html

      Attachments

        Activity

          diego dupin Diego Dupin added a comment -

          this is due to https://jira.mariadb.org/browse/CONJ-788 introduced in last version, but writable value has been set incorrectly, based on column is updatable with an updatable resultset, not on the fact that column is read only.

          diego dupin Diego Dupin added a comment - this is due to https://jira.mariadb.org/browse/CONJ-788 introduced in last version, but writable value has been set incorrectly, based on column is updatable with an updatable resultset, not on the fact that column is read only.
          clemensdev Clemens added a comment -

          succesfully tested with 2.6.2!
          Thx!

          clemensdev Clemens added a comment - succesfully tested with 2.6.2! Thx!

          People

            diego dupin Diego Dupin
            clemensdev Clemens
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.