ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ilya Kasnacheev (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-8948) Allow checking of LOGGING status via SQL/JDBC
Date Fri, 06 Jul 2018 12:13:00 GMT
Ilya Kasnacheev created IGNITE-8948:

             Summary: Allow checking of LOGGING status via SQL/JDBC
                 Key: IGNITE-8948
                 URL: https://issues.apache.org/jira/browse/IGNITE-8948
             Project: Ignite
          Issue Type: New Feature
          Components: jdbc, sql
            Reporter: Ilya Kasnacheev

It is now possible to enable/disable WAL via ALTER TABLE tblName {LOGGING|NOLOGGING};

However, it's not possible to check current LOGGING status. It is desired that this is available.

The suggested method is via [JDBC metadata table|https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[])]
info: right now we return null as REMARKS, but we could return the WITH "..." string in REMARKS.
Which will allow more introspection to JDBC clients. We could store this line somewhere, or
reconstruct it from scratch. And, we can allow WITH "logging={true|false}" and return the
current logging status in the same fashion.

The problem here is that non-JDBC SQL clients still can't do that. So maybe we need a dedicated
statements for this eventually.

This message was sent by Atlassian JIRA

View raw message