ignite-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sboi...@apache.org
Subject [14/50] [abbrv] incubator-ignite git commit: Merge branch 'sprint-1' into ignite-188
Date Mon, 09 Feb 2015 06:31:56 GMT
http://git-wip-us.apache.org/repos/asf/incubator-ignite/blob/b08492a5/modules/core/src/main/java/org/apache/ignite/internal/jdbc/JdbcDatabaseMetadata.java
----------------------------------------------------------------------
diff --cc modules/core/src/main/java/org/apache/ignite/internal/jdbc/JdbcDatabaseMetadata.java
index e6d838a,0000000..c5d9079
mode 100644,000000..100644
--- a/modules/core/src/main/java/org/apache/ignite/internal/jdbc/JdbcDatabaseMetadata.java
+++ b/modules/core/src/main/java/org/apache/ignite/internal/jdbc/JdbcDatabaseMetadata.java
@@@ -1,1313 -1,0 +1,1313 @@@
 +/*
 + * Licensed to the Apache Software Foundation (ASF) under one or more
 + * contributor license agreements.  See the NOTICE file distributed with
 + * this work for additional information regarding copyright ownership.
 + * The ASF licenses this file to You under the Apache License, Version 2.0
 + * (the "License"); you may not use this file except in compliance with
 + * the License.  You may obtain a copy of the License at
 + *
 + *      http://www.apache.org/licenses/LICENSE-2.0
 + *
 + * Unless required by applicable law or agreed to in writing, software
 + * distributed under the License is distributed on an "AS IS" BASIS,
 + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 + * See the License for the specific language governing permissions and
 + * limitations under the License.
 + */
 +
 +package org.apache.ignite.internal.jdbc;
 +
 +import org.apache.ignite.client.*;
 +import org.apache.ignite.internal.util.typedef.internal.*;
 +
 +import java.sql.*;
 +import java.util.*;
 +
 +import static java.sql.Connection.*;
 +import static java.sql.ResultSet.*;
 +import static java.sql.RowIdLifetime.*;
 +
 +/**
 + * JDBC database metadata implementation.
 + */
 +@SuppressWarnings("RedundantCast")
 +public class JdbcDatabaseMetadata implements DatabaseMetaData {
 +    /** Task name. */
 +    private static final String TASK_NAME =
 +        "org.apache.ignite.internal.processors.cache.query.jdbc.GridCacheQueryJdbcMetadataTask";
 +
 +    /** Connection. */
 +    private final JdbcConnection conn;
 +
 +    /** Metadata. */
 +    private Map<String, Map<String, Map<String, String>>> meta;
 +
 +    /** Index info. */
 +    private Collection<List<Object>> indexes;
 +
 +    /**
 +     * @param conn Connection.
 +     */
 +    JdbcDatabaseMetadata(JdbcConnection conn) {
 +        this.conn = conn;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean allProceduresAreCallable() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean allTablesAreSelectable() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getURL() throws SQLException {
 +        return conn.url();
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getUserName() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean isReadOnly() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean nullsAreSortedHigh() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean nullsAreSortedLow() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean nullsAreSortedAtStart() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean nullsAreSortedAtEnd() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getDatabaseProductName() throws SQLException {
-         return "GridGain Cache";
++        return "Ignite Cache";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getDatabaseProductVersion() throws SQLException {
 +        return "4.1.0";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getDriverName() throws SQLException {
-         return "GridGain JDBC Driver";
++        return "Ignite JDBC Driver";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getDriverVersion() throws SQLException {
 +        return "1.0";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getDriverMajorVersion() {
 +        return 1;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getDriverMinorVersion() {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean usesLocalFiles() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean usesLocalFilePerTable() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsMixedCaseIdentifiers() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean storesUpperCaseIdentifiers() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean storesLowerCaseIdentifiers() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean storesMixedCaseIdentifiers() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean storesUpperCaseQuotedIdentifiers() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean storesLowerCaseQuotedIdentifiers() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean storesMixedCaseQuotedIdentifiers() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getIdentifierQuoteString() throws SQLException {
 +        return " ";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getSQLKeywords() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getNumericFunctions() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getStringFunctions() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getSystemFunctions() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getTimeDateFunctions() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getSearchStringEscape() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getExtraNameCharacters() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsAlterTableWithAddColumn() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsAlterTableWithDropColumn() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsColumnAliasing() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean nullPlusNonNullIsNull() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsConvert() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsConvert(int fromType, int toType) throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsTableCorrelationNames() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsDifferentTableCorrelationNames() throws SQLException
{
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsExpressionsInOrderBy() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsOrderByUnrelated() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsGroupBy() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsGroupByUnrelated() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsGroupByBeyondSelect() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsLikeEscapeClause() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsMultipleResultSets() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsMultipleTransactions() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsNonNullableColumns() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsMinimumSQLGrammar() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsCoreSQLGrammar() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsExtendedSQLGrammar() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsANSI92EntryLevelSQL() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsANSI92IntermediateSQL() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsANSI92FullSQL() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsIntegrityEnhancementFacility() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsOuterJoins() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsFullOuterJoins() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsLimitedOuterJoins() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getSchemaTerm() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getProcedureTerm() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getCatalogTerm() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean isCatalogAtStart() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public String getCatalogSeparator() throws SQLException {
 +        return "";
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSchemasInDataManipulation() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSchemasInProcedureCalls() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSchemasInTableDefinitions() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSchemasInIndexDefinitions() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsCatalogsInDataManipulation() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsCatalogsInProcedureCalls() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsCatalogsInTableDefinitions() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsCatalogsInIndexDefinitions() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsPositionedDelete() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsPositionedUpdate() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSelectForUpdate() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsStoredProcedures() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSubqueriesInComparisons() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSubqueriesInExists() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSubqueriesInIns() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSubqueriesInQuantifieds() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsCorrelatedSubqueries() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsUnion() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsUnionAll() throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsOpenCursorsAcrossCommit() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsOpenCursorsAcrossRollback() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsOpenStatementsAcrossCommit() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsOpenStatementsAcrossRollback() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxBinaryLiteralLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxCharLiteralLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxColumnNameLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxColumnsInGroupBy() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxColumnsInIndex() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxColumnsInOrderBy() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxColumnsInSelect() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxColumnsInTable() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxConnections() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxCursorNameLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxIndexLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxSchemaNameLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxProcedureNameLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxCatalogNameLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxRowSize() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean doesMaxRowSizeIncludeBlobs() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxStatementLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxStatements() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxTableNameLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxTablesInSelect() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getMaxUserNameLength() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getDefaultTransactionIsolation() throws SQLException {
 +        return TRANSACTION_NONE;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsTransactions() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsTransactionIsolationLevel(int level) throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsDataDefinitionAndDataManipulationTransactions() throws
SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsDataManipulationTransactionsOnly() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean dataDefinitionCausesTransactionCommit() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean dataDefinitionIgnoredInTransactions() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getProcedures(String catalog, String schemaPtrn,
 +        String procedureNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("PROCEDURE_CAT", "PROCEDURE_SCHEM", "PROCEDURE_NAME",
 +                "REMARKS", "PROCEDURE_TYPE", "SPECIFIC_NAME"),
 +            Arrays.<String>asList(String.class.getName(), String.class.getName(),
String.class.getName(),
 +                String.class.getName(), Short.class.getName(), String.class.getName()),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getProcedureColumns(String catalog, String schemaPtrn, String
procedureNamePtrn,
 +        String colNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("PROCEDURE_CAT", "PROCEDURE_SCHEM", "PROCEDURE_NAME",
 +                "COLUMN_NAME", "COLUMN_TYPE", "DATA_TYPE", "TYPE_NAME", "PRECISION",
 +                "LENGTH", "SCALE", "RADIX", "NULLABLE", "REMARKS", "COLUMN_DEF",
 +                "SQL_DATA_TYPE", "SQL_DATETIME_SUB", "CHAR_OCTET_LENGTH",
 +                "ORDINAL_POSITION", "IS_NULLABLE", "SPECIFIC_NAME"),
 +            Arrays.<String>asList(String.class.getName(), String.class.getName(),
String.class.getName(),
 +                String.class.getName(), Short.class.getName(), Integer.class.getName(),
String.class.getName(),
 +                Integer.class.getName(), Integer.class.getName(), Short.class.getName(),
Short.class.getName(),
 +                Short.class.getName(), String.class.getName(), String.class.getName(), Integer.class.getName(),
 +                Integer.class.getName(), Integer.class.getName(), Integer.class.getName(),
String.class.getName(),
 +                String.class.getName()),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getTables(String catalog, String schemaPtrn, String tblNamePtrn,
 +        String[] tblTypes) throws SQLException {
 +        updateMetaData();
 +
 +        List<List<Object>> rows = new LinkedList<>();
 +
 +        if (tblTypes == null || Arrays.asList(tblTypes).contains("TABLE"))
 +            for (Map.Entry<String, Map<String, Map<String, String>>> schema
: meta.entrySet())
 +                if (matches(schema.getKey(), schemaPtrn))
 +                    for (String tbl : schema.getValue().keySet())
 +                        if (matches(tbl, tblNamePtrn))
 +                            rows.add(tableRow(schema.getKey(), tbl));
 +
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "TABLE_TYPE", "REMARKS",
"TYPE_CAT",
 +                "TYPE_SCHEM", "TYPE_NAME", "SELF_REFERENCING_COL_NAME", "REF_GENERATION"),
 +            Arrays.<String>asList(String.class.getName(), String.class.getName(),
String.class.getName(),
 +                String.class.getName(), String.class.getName(), String.class.getName(),
String.class.getName(),
 +                String.class.getName(), String.class.getName(), String.class.getName()),
 +            rows
 +        );
 +    }
 +
 +    /**
 +     * @param schema Schema name.
 +     * @param tbl Table name.
 +     * @return Table metadata row.
 +     */
 +    private List<Object> tableRow(String schema, String tbl) {
 +        List<Object> row = new ArrayList<>(10);
 +
 +        row.add((String)null);
 +        row.add(schema);
 +        row.add(tbl.toUpperCase());
 +        row.add("TABLE");
 +        row.add((String)null);
 +        row.add((String)null);
 +        row.add((String)null);
 +        row.add((String)null);
 +        row.add((String)null);
 +        row.add((String)null);
 +
 +        return row;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getSchemas() throws SQLException {
 +        return getSchemas(null, "%");
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getCatalogs() throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("TABLE_CAT"),
 +            Arrays.<String>asList(String.class.getName()),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getTableTypes() throws SQLException {
 +        return new JdbcResultSet(conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.singletonList("TABLE_TYPE"),
 +            Collections.<String>singletonList(String.class.getName()),
 +            Collections.singletonList(Collections.<Object>singletonList("TABLE")));
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getColumns(String catalog, String schemaPtrn, String tblNamePtrn,
 +        String colNamePtrn) throws SQLException {
 +        updateMetaData();
 +
 +        List<List<Object>> rows = new LinkedList<>();
 +
 +        int cnt = 0;
 +
 +        for (Map.Entry<String, Map<String, Map<String, String>>> schema
: meta.entrySet())
 +            if (matches(schema.getKey(), schemaPtrn))
 +                for (Map.Entry<String, Map<String, String>> tbl : schema.getValue().entrySet())
 +                    if (matches(tbl.getKey(), tblNamePtrn))
 +                        for (Map.Entry<String, String> col : tbl.getValue().entrySet())
 +                            rows.add(columnRow(schema.getKey(), tbl.getKey(), col.getKey(),
 +                                JdbcUtils.type(col.getValue()), JdbcUtils.typeName(col.getValue()),
 +                                JdbcUtils.nullable(col.getKey(), col.getValue()), ++cnt));
 +
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "COLUMN_NAME", "DATA_TYPE",
 +                "TYPE_NAME", "COLUMN_SIZE", "DECIMAL_DIGITS", "NUM_PREC_RADIX", "NULLABLE",
 +                "REMARKS", "COLUMN_DEF", "CHAR_OCTET_LENGTH", "ORDINAL_POSITION", "IS_NULLABLE",
 +                "SCOPE_CATLOG", "SCOPE_SCHEMA", "SCOPE_TABLE", "SOURCE_DATA_TYPE", "IS_AUTOINCREMENT"),
 +            Arrays.<String>asList(String.class.getName(), String.class.getName(),
String.class.getName(),
 +                String.class.getName(), Integer.class.getName(), String.class.getName(),
Integer.class.getName(),
 +                Integer.class.getName(), Integer.class.getName(), Integer.class.getName(),
String.class.getName(),
 +                String.class.getName(), Integer.class.getName(), Integer.class.getName(),
String.class.getName(),
 +                String.class.getName(), String.class.getName(), String.class.getName(),
Short.class.getName(),
 +                String.class.getName()),
 +            rows
 +        );
 +    }
 +
 +    /**
 +     * @param schema Schema name.
 +     * @param tbl Table name.
 +     * @param col Column name.
 +     * @param type Type.
 +     * @param typeName Type name.
 +     * @param nullable Nullable flag.
 +     * @param pos Ordinal position.
 +     * @return Column metadata row.
 +     */
 +    private List<Object> columnRow(String schema, String tbl, String col, int type,
String typeName,
 +        boolean nullable, int pos) {
 +        List<Object> row = new ArrayList<>(20);
 +
 +        row.add((String)null);
 +        row.add(schema);
 +        row.add(tbl);
 +        row.add(col);
 +        row.add(type);
 +        row.add(typeName);
 +        row.add((Integer)null);
 +        row.add((Integer)null);
 +        row.add(10);
 +        row.add(nullable ? columnNullable : columnNoNulls);
 +        row.add((String)null);
 +        row.add((String)null);
 +        row.add(Integer.MAX_VALUE);
 +        row.add(pos);
 +        row.add("YES");
 +        row.add((String)null);
 +        row.add((String)null);
 +        row.add((String)null);
 +        row.add((Short)null);
 +        row.add("NO");
 +
 +        return row;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getColumnPrivileges(String catalog, String schema, String
tbl,
 +        String colNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getTablePrivileges(String catalog, String schemaPtrn,
 +        String tblNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getBestRowIdentifier(String catalog, String schema, String
tbl, int scope,
 +        boolean nullable) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getVersionColumns(String catalog, String schema, String tbl)
throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getPrimaryKeys(String catalog, String schema, String tbl)
throws SQLException {
 +        updateMetaData();
 +
 +        List<List<Object>> rows = new LinkedList<>();
 +
 +        for (Map.Entry<String, Map<String, Map<String, String>>> s : meta.entrySet())
 +            if (schema == null || schema.toUpperCase().equals(s.getKey()))
 +                for (Map.Entry<String, Map<String, String>> t : s.getValue().entrySet())
 +                    if (tbl == null || tbl.toUpperCase().equals(t.getKey()))
 +                        rows.add(Arrays.<Object>asList((String)null, s.getKey().toUpperCase(),
 +                            t.getKey().toUpperCase(), "_KEY", 1, "_KEY"));
 +
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "COLUMN_NAME", "KEY_SEQ",
"PK_NAME"),
 +            Arrays.asList(String.class.getName(), String.class.getName(), String.class.getName(),
 +                String.class.getName(), Short.class.getName(), String.class.getName()),
 +            rows
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getImportedKeys(String catalog, String schema, String tbl)
throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getExportedKeys(String catalog, String schema, String tbl)
throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getCrossReference(String parentCatalog, String parentSchema,
String parentTbl,
 +        String foreignCatalog, String foreignSchema, String foreignTbl) throws SQLException
{
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getTypeInfo() throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getIndexInfo(String catalog, String schema, String tbl, boolean
unique,
 +        boolean approximate) throws SQLException {
 +        Collection<List<Object>> rows = new ArrayList<>(indexes.size());
 +
 +        for (List<Object> idx : indexes) {
 +            String idxSchema = (String)idx.get(0);
 +            String idxTbl = (String)idx.get(1);
 +
 +            if ((schema == null || schema.equals(idxSchema)) && (tbl == null ||
tbl.equals(idxTbl))) {
 +                List<Object> row = new ArrayList<>(13);
 +
 +                row.add((String)null);
 +                row.add(idxSchema);
 +                row.add(idxTbl);
 +                row.add((Boolean)idx.get(2));
 +                row.add((String)null);
 +                row.add((String)idx.get(3));
 +                row.add((int)tableIndexOther);
 +                row.add((Integer)idx.get(4));
 +                row.add((String)idx.get(5));
 +                row.add((Boolean)idx.get(6) ? "D" : "A");
 +                row.add(0);
 +                row.add(0);
 +                row.add((String)null);
 +
 +                rows.add(row);
 +            }
 +        }
 +
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("TABLE_CAT", "TABLE_SCHEM", "TABLE_NAME", "NON_UNIQUE", "INDEX_QUALIFIER",
 +                "INDEX_NAME", "TYPE", "ORDINAL_POSITION", "COLUMN_NAME", "ASC_OR_DESC",
"CARDINALITY",
 +                "PAGES", "FILTER_CONDITION"),
 +            Arrays.asList(String.class.getName(), String.class.getName(), String.class.getName(),
 +                Boolean.class.getName(), String.class.getName(), String.class.getName(),
Short.class.getName(),
 +                Short.class.getName(), String.class.getName(), String.class.getName(), Integer.class.getName(),
 +                Integer.class.getName(), String.class.getName()),
 +            rows
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsResultSetType(int type) throws SQLException {
 +        return true;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsResultSetConcurrency(int type, int concurrency) throws
SQLException {
 +        return concurrency == CONCUR_READ_ONLY;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean ownUpdatesAreVisible(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean ownDeletesAreVisible(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean ownInsertsAreVisible(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean othersUpdatesAreVisible(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean othersDeletesAreVisible(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean othersInsertsAreVisible(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean updatesAreDetected(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean deletesAreDetected(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean insertsAreDetected(int type) throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsBatchUpdates() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getUDTs(String catalog, String schemaPtrn, String typeNamePtrn,
 +        int[] types) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public Connection getConnection() throws SQLException {
 +        return conn;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsSavepoints() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsNamedParameters() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsMultipleOpenResults() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsGetGeneratedKeys() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getSuperTypes(String catalog, String schemaPtrn,
 +        String typeNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getSuperTables(String catalog, String schemaPtrn,
 +        String tblNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getAttributes(String catalog, String schemaPtrn, String typeNamePtrn,
 +        String attributeNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsResultSetHoldability(int holdability) throws SQLException
{
 +        return holdability == HOLD_CURSORS_OVER_COMMIT;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getResultSetHoldability() throws SQLException {
 +        return HOLD_CURSORS_OVER_COMMIT;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getDatabaseMajorVersion() throws SQLException {
 +        return 1;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getDatabaseMinorVersion() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getJDBCMajorVersion() throws SQLException {
 +        return 1;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getJDBCMinorVersion() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public int getSQLStateType() throws SQLException {
 +        return 0;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean locatorsUpdateCopy() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsStatementPooling() throws SQLException {
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public RowIdLifetime getRowIdLifetime() throws SQLException {
 +        return ROWID_UNSUPPORTED;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getSchemas(String catalog, String schemaPtrn) throws SQLException
{
 +        updateMetaData();
 +
 +        List<List<Object>> rows = new ArrayList<>(meta.size());
 +
 +        for (String schema : meta.keySet())
 +            if (matches(schema, schemaPtrn))
 +                rows.add(Arrays.<Object>asList(schema, (String)null));
 +
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("TABLE_SCHEM", "TABLE_CATALOG"),
 +            Arrays.<String>asList(String.class.getName(), String.class.getName()),
 +            rows
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean autoCommitFailureClosesAllResultSets() throws SQLException
{
 +        return false;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getClientInfoProperties() throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getFunctions(String catalog, String schemaPtrn,
 +        String functionNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("FUNCTION_CAT", "FUNCTION_SCHEM", "FUNCTION_NAME",
 +                "REMARKS", "FUNCTION_TYPE", "SPECIFIC_NAME"),
 +            Arrays.<String>asList(String.class.getName(), String.class.getName(),
String.class.getName(),
 +                String.class.getName(), Short.class.getName(), String.class.getName()),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getFunctionColumns(String catalog, String schemaPtrn, String
functionNamePtrn,
 +        String colNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Arrays.asList("FUNCTION_CAT", "FUNCTION_SCHEM", "FUNCTION_NAME",
 +                "COLUMN_NAME", "COLUMN_TYPE", "DATA_TYPE", "TYPE_NAME", "PRECISION",
 +                "LENGTH", "SCALE", "RADIX", "NULLABLE", "REMARKS", "CHAR_OCTET_LENGTH",
 +                "ORDINAL_POSITION", "IS_NULLABLE", "SPECIFIC_NAME"),
 +            Arrays.<String>asList(String.class.getName(), String.class.getName(),
String.class.getName(),
 +                String.class.getName(), Short.class.getName(), Integer.class.getName(),
String.class.getName(),
 +                Integer.class.getName(), Integer.class.getName(), Short.class.getName(),
Short.class.getName(),
 +                Short.class.getName(), String.class.getName(), Integer.class.getName(),
Integer.class.getName(),
 +                String.class.getName(), String.class.getName()),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public <T> T unwrap(Class<T> iface) throws SQLException {
 +        if (!isWrapperFor(iface))
 +            throw new SQLException("Database meta data is not a wrapper for " + iface.getName());
 +
 +        return (T)this;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean isWrapperFor(Class<?> iface) throws SQLException {
 +        return iface != null && iface == DatabaseMetaData.class;
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public ResultSet getPseudoColumns(String catalog, String schemaPtrn, String
tblNamePtrn,
 +        String colNamePtrn) throws SQLException {
 +        return new JdbcResultSet(
 +            conn.createStatement0(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<String>emptyList(),
 +            Collections.<List<Object>>emptyList()
 +        );
 +    }
 +
 +    /** {@inheritDoc} */
 +    @Override public boolean generatedKeyAlwaysReturned() throws SQLException {
 +        return false;
 +    }
 +
 +    /**
 +     * Updates meta data.
 +     *
 +     * @throws SQLException In case of error.
 +     */
 +    private void updateMetaData() throws SQLException {
 +        if (conn.isClosed())
 +            throw new SQLException("Connection is closed.");
 +
 +        try {
 +            byte[] packet = conn.client().compute().execute(TASK_NAME, conn.cacheName());
 +
 +            byte status = packet[0];
 +            byte[] data = new byte[packet.length - 1];
 +
 +            U.arrayCopy(packet, 1, data, 0, data.length);
 +
 +            if (status == 1)
 +                throw JdbcUtils.unmarshalError(data);
 +            else {
 +                List<Object> res = JdbcUtils.unmarshal(data);
 +
 +                meta = (Map<String, Map<String, Map<String, String>>>)res.get(0);
 +                indexes = (Collection<List<Object>>)res.get(1);
 +            }
 +        }
 +        catch (GridClientException e) {
-             throw new SQLException("Failed to get meta data from GridGain.", e);
++            throw new SQLException("Failed to get meta data from Ignite.", e);
 +        }
 +    }
 +
 +    /**
 +     * Checks whether string matches SQL pattern.
 +     *
 +     * @param str String.
 +     * @param ptrn Pattern.
 +     * @return Whether string matches pattern.
 +     */
 +    private boolean matches(String str, String ptrn) {
 +        return str != null && (ptrn == null ||
 +            str.toUpperCase().matches(ptrn.toUpperCase().replace("%", ".*").replace("_",
".")));
 +    }
 +}


Mime
View raw message