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

Be able to filter system tables and views

    XMLWordPrintable

Details

    Description

      To list the tables and views offered by a connection, LibreOffice and / or OpenOffice Base uses the method DatabaseMetaData.getTables().

      This method offers a fourth parameter that allows you to filter the tables according to their type.
      The documentation says about it: a list of table types, which must be from the list of table types returned from getTableTypes(),to include; null returns all types.

      The values returned by the getTableTypes() method are not precise enough (or numerous) to be able to filter the system tables and views (tables and views contained in information_schema, mysql, performance_schema and sys) from the tables and views of the user.

      This does not allow to list or not the system tables and views to the user, according to his choice, in the graphic interface of LibreOffice / OpenOffice Base.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            prrvchr prrvchr
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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