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

mariadb-java-client-1.1.8 shows no tables in OpenOffice Base

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • all
    • 1.4.5
    • Other
    • None
    • Windows 7 64-bit, OpenOffice 4.1.1, mariadb-java-client-1.1.8

    Description

      Connecting with the jdbc driver to a database will not show any table, only views.
      Querying of Tables with sql statements is possible, but only if you know the tables name.
      Using the OpenOffice Query Designer is not possible, because it can not see any table.

      If I use the mysql odbc or the mysql jdbc (mysql-connector-java-5.1.34) the tables will show.
      I didn't test with mariadb odbc.

      Cheers JJ

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. CONJ-218 MariaDbDatabaseMetaData wrong TABLE_TYPE values in getTables() method

          • Major - Major loss of function.
          • Closed

          Activity

            diego dupin Diego Dupin added a comment -

            This problem is corrected with CONJ-218 (correction in 1.4.5).
            Driver was using mariadb/mysql tables type, so "BASE TABLE" for table.
            JDBC is only making recommendation about DatabaseMetaData.getTableTypes() to use "TABLE".

            Since a lot of tools are implementing type "TABLE", Driver has improved to use JDBC recommendation.

            diego dupin Diego Dupin added a comment - This problem is corrected with CONJ-218 (correction in 1.4.5). Driver was using mariadb/mysql tables type, so "BASE TABLE" for table. JDBC is only making recommendation about DatabaseMetaData.getTableTypes() to use "TABLE". Since a lot of tools are implementing type "TABLE", Driver has improved to use JDBC recommendation.

            People

              diego dupin Diego Dupin
              der-jj Joerg Junge
              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.