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

        Issue Links

          Activity

            People

              diego dupin Diego Dupin
              prrvchr prrvchr
              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.