org.xenei.jdbc4sparql.J4SDatabaseMetaData.java Source code

Introduction

Here is the source code for org.xenei.jdbc4sparql.J4SDatabaseMetaData.java

Source

/*
 * 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.xenei.jdbc4sparql;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.RowIdLifetime;
import java.sql.SQLException;
import java.util.Iterator;

import org.apache.commons.lang3.StringUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.xenei.jdbc4sparql.iface.Catalog;
import org.xenei.jdbc4sparql.iface.Key;
import org.xenei.jdbc4sparql.iface.KeySegment;
import org.xenei.jdbc4sparql.iface.NameFilter;
import org.xenei.jdbc4sparql.iface.Schema;
import org.xenei.jdbc4sparql.iface.Table;
import org.xenei.jdbc4sparql.iface.TableDef;
import org.xenei.jdbc4sparql.impl.DataTable;
import org.xenei.jdbc4sparql.impl.rdf.RdfTable;
import org.xenei.jdbc4sparql.meta.MetaCatalogBuilder;
import org.xenei.jdbc4sparql.sparql.SparqlQueryBuilder;
import org.xenei.jdbc4sparql.sparql.SparqlResultSet;
import org.xenei.jdbc4sparql.sparql.parser.SparqlParser;
import org.xenei.jdbc4sparql.sparql.parser.jsqlparser.SparqlParserImpl;

public class J4SDatabaseMetaData implements DatabaseMetaData {
    private final J4SConnection connection;
    private final J4SDriver driver;
    private final Catalog metaCatalog;
    private final Schema metaSchema;
    // private final Map<String, Catalog> catalogs;
    private static Logger LOG = LoggerFactory.getLogger(J4SDatabaseMetaData.class);
    private final SparqlParser parser = new SparqlParserImpl();

    public J4SDatabaseMetaData(final J4SConnection connection, final J4SDriver driver) {
        this.connection = connection;
        this.driver = driver;
        // this.catalogs = new HashMap<String,
        // Catalog>(connection.getCatalogs());
        metaCatalog = connection.getCatalogs().get(MetaCatalogBuilder.LOCAL_NAME);
        metaSchema = metaCatalog.getSchema(MetaCatalogBuilder.SCHEMA_NAME);
        if (metaSchema == null) {
            throw new IllegalStateException(
                    String.format("Metadata schema '%s' not defined", MetaCatalogBuilder.SCHEMA_NAME));
        }
    }

    @Override
    public boolean allProceduresAreCallable() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean allTablesAreSelectable() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean autoCommitFailureClosesAllResultSets() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean dataDefinitionCausesTransactionCommit() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean dataDefinitionIgnoredInTransactions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean deletesAreDetected(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean doesMaxRowSizeIncludeBlobs() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    private String escapeString(final String s) {
        return s.replace("\\'", "'").replace("'", "\\'");
    }

    @Override
    public boolean generatedKeyAlwaysReturned() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public ResultSet getAttributes(final String catalog, final String schemaPattern, final String typePattern,
            final String attributeNamePattern) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.ATTRIBUTES_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public ResultSet getBestRowIdentifier(final String arg0, final String arg1, final String arg2, final int arg3,
            final boolean arg4) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.BEST_ROW_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    // TODO remvoe this
    public Catalog getCatalog(final String name) {
        return connection.getCatalogs().get(name);
    }

    private String getCatalogName(final String pattern) {
        if (pattern == null) {
            throw new IllegalArgumentException("Catalog name may not be null");
        }
        if (StringUtils.isBlank(pattern)) {
            return escapeString("");
        }
        return escapeString(pattern);
    }

    @Override
    public ResultSet getCatalogs() throws SQLException {
        if (LOG.isDebugEnabled()) {
            J4SDatabaseMetaData.LOG.debug("Getting catalogs");
        }
        final RdfTable table = (RdfTable) metaSchema.getTable(MetaCatalogBuilder.CATALOGS_TABLE);

        return table.getResultSet(connection.getCatalogs(), parser);
    }

    @Override
    public String getCatalogSeparator() throws SQLException {
        return ".";
    }

    @Override
    public String getCatalogTerm() throws SQLException {
        return "Catalog";
    }

    @Override
    public ResultSet getClientInfoProperties() throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.CLIENT_INFO_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public ResultSet getColumnPrivileges(final String arg0, final String arg1, final String arg2, final String arg3)
            throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.COLUMN_PRIVILIGES_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public ResultSet getColumns(final String catalogPattern, final String schemaPattern,
            final String tableNamePattern, final String columnNamePattern) throws SQLException {
        if (J4SDatabaseMetaData.LOG.isDebugEnabled()) {
            J4SDatabaseMetaData.LOG.debug(String.format("Getting columns %s.%s.%s.%s", catalogPattern,
                    schemaPattern, tableNamePattern, columnNamePattern));
        }
        final RdfTable table = (RdfTable) metaSchema.getTable(MetaCatalogBuilder.COLUMNS_TABLE);
        if ((catalogPattern != null) || (schemaPattern != null) || (tableNamePattern != null)
                || (columnNamePattern != null)) {

            boolean hasWhere = false;
            final StringBuilder query = new StringBuilder()
                    .append(String.format("SELECT * FROM %s WHERE ", table.getSQLName()));
            if (catalogPattern != null) {
                query.append(String.format("TABLE_CAT LIKE '%s'", getCatalogName(catalogPattern)));
                hasWhere = true;
            }
            if (schemaPattern != null) {
                query.append(hasWhere ? " AND " : "")
                        .append(String.format("TABLE_SCHEM LIKE '%s'", getSchemaName(schemaPattern)));
                hasWhere = true;
            }
            if (tableNamePattern != null) {
                query.append(hasWhere ? " AND " : "")
                        .append(String.format("TABLE_NAME LIKE '%s'", escapeString(tableNamePattern)));
                hasWhere = true;
            }
            if (columnNamePattern != null) {
                query.append(hasWhere ? " AND " : "")
                        .append(String.format("COLUMN_NAME LIKE '%s'", escapeString(columnNamePattern)));
                hasWhere = true;
            }

            final SparqlQueryBuilder sqb = parser
                    .parse(connection.getCatalogs(), table.getCatalog(), table.getSchema(), query.toString())
                    .setKey(table.getKey());
            return new SparqlResultSet(table, sqb.build());
        } else {
            return table.getResultSet(connection.getCatalogs(), parser);
        }
    }

    @Override
    public Connection getConnection() throws SQLException {
        return connection;
    }

    @Override
    public ResultSet getCrossReference(final String parentCatalog, final String parentSchema,
            final String parentTable, final String foreignCatalog, final String foreignSchema,
            final String foreignTable) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.XREF_TABLE));

        // TODO populate table here.
        return table.getResultSet();

    }

    @Override
    public int getDatabaseMajorVersion() throws SQLException {
        return 1;
    }

    @Override
    public int getDatabaseMinorVersion() throws SQLException {
        return 0;
    }

    @Override
    public String getDatabaseProductName() throws SQLException {
        return "JDBC4SPARQL";
    }

    @Override
    public String getDatabaseProductVersion() throws SQLException {
        return "1";
    }

    @Override
    public int getDefaultTransactionIsolation() throws SQLException {
        return java.sql.Connection.TRANSACTION_NONE;
    }

    @Override
    public int getDriverMajorVersion() {
        return driver.getMajorVersion();
    }

    @Override
    public int getDriverMinorVersion() {
        return driver.getMinorVersion();
    }

    @Override
    public String getDriverName() throws SQLException {
        return driver.getName();
    }

    @Override
    public String getDriverVersion() throws SQLException {
        return String.format("%s v%s.%s", driver.getName(), driver.getMajorVersion(), driver.getMinorVersion());
    }

    @Override
    public ResultSet getExportedKeys(final String arg0, final String arg1, final String arg2) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.EXPORTED_KEYS_TABLE));
        // TODO populate table here.
        return table.getResultSet();

    }

    @Override
    public String getExtraNameCharacters() throws SQLException {
        return "";
    }

    @Override
    public ResultSet getFunctionColumns(final String arg0, final String arg1, final String arg2, final String arg3)
            throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.FUNCTION_COLUMNS_TABLE));
        // TODO populate table here.
        return table.getResultSet();

    }

    @Override
    public ResultSet getFunctions(final String arg0, final String arg1, final String arg2) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.FUNCTIONS_TABLE));
        // TODO populate table here.
        return table.getResultSet();

    }

    @Override
    public String getIdentifierQuoteString() throws SQLException {
        return " ";
    }

    @Override
    public ResultSet getImportedKeys(final String arg0, final String arg1, final String arg2) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.IMPORTED_KEYS_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public ResultSet getIndexInfo(final String arg0, final String arg1, final String arg2, final boolean arg3,
            final boolean arg4) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.INDEXINFO_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public int getJDBCMajorVersion() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getJDBCMinorVersion() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxBinaryLiteralLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxCatalogNameLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxCharLiteralLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxColumnNameLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxColumnsInGroupBy() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxColumnsInIndex() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxColumnsInOrderBy() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxColumnsInSelect() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxColumnsInTable() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxConnections() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxCursorNameLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxIndexLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxProcedureNameLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxRowSize() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxSchemaNameLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxStatementLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxStatements() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxTableNameLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxTablesInSelect() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public int getMaxUserNameLength() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public String getNumericFunctions() throws SQLException {
        return makeString(parser.getSupportedNumericFunctions().iterator());
    }

    @Override
    public ResultSet getPrimaryKeys(final String catalogPattern, final String schemaPattern,
            final String tableNamePattern) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.PRIMARY_KEY_TABLE));
        for (final Catalog catalog : new NameFilter<Catalog>(catalogPattern, connection.getCatalogs().values())) {
            for (final Schema schema : new NameFilter<Schema>(schemaPattern, catalog.getSchemas())) {
                for (final Table tbl : new NameFilter<Table>(tableNamePattern, schema.getTables())) {
                    final TableDef tableDef = tbl.getTableDef();
                    if (tableDef.getPrimaryKey() != null) {
                        final Key<?> pk = tableDef.getPrimaryKey();
                        for (final KeySegment seg : pk.getSegments()) {
                            final Object[] data = { catalog.getName(), // TABLE_CAT
                                    schema.getName(), // TABLE_SCHEM
                                    tbl.getName(), // TABLE_NAME
                                    tbl.getColumn(seg.getIdx()).getName(), // COLUMN_NAME
                                    new Short((short) (seg.getIdx() + 1)), // KEY_SEQ
                                    pk.getKeyName()
                                    // PK_NAME
                            };
                            table.addData(data);
                        }
                    }
                }
            }
        }
        return table.getResultSet();
    }

    @Override
    public ResultSet getProcedureColumns(final String arg0, final String arg1, final String arg2, final String arg3)
            throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.PROCEDURE_COLUMNS_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public ResultSet getProcedures(final String arg0, final String arg1, final String arg2) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.PROCEDURES_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public String getProcedureTerm() throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public ResultSet getPseudoColumns(final String arg0, final String arg1, final String arg2, final String arg3)
            throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public int getResultSetHoldability() throws SQLException {
        return ResultSet.HOLD_CURSORS_OVER_COMMIT;
    }

    @Override
    public RowIdLifetime getRowIdLifetime() throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    private String getSchemaName(final String pattern) {
        if (pattern == null) {
            throw new IllegalArgumentException("Schema name may not be null");
        }
        if (StringUtils.isBlank(pattern)) {
            return escapeString("");
        }
        return escapeString(pattern);
    }

    @Override
    public ResultSet getSchemas() throws SQLException {
        return getSchemas(null, null);
    }

    @Override
    public ResultSet getSchemas(final String catalogPattern, final String schemaPattern) throws SQLException {
        if (J4SDatabaseMetaData.LOG.isDebugEnabled()) {
            J4SDatabaseMetaData.LOG.debug(String.format("getting schemas %s.%s", catalogPattern, schemaPattern));
        }
        final RdfTable table = (RdfTable) metaSchema.getTable(MetaCatalogBuilder.SCHEMAS_TABLE);
        if ((catalogPattern != null) || (schemaPattern != null)) {
            boolean hasWhere = false;
            final StringBuilder query = new StringBuilder()
                    .append(String.format("SELECT * FROM %s WHERE ", table.getSQLName()));
            if (catalogPattern != null) {
                query.append(String.format("TABLE_CATALOG LIKE '%s'", getCatalogName(catalogPattern)));
                hasWhere = true;
            }
            if (schemaPattern != null) {
                query.append(hasWhere ? " AND " : "")
                        .append(String.format("TABLE_SCHEM LIKE '%s'", getSchemaName(schemaPattern)));
                hasWhere = true;
            }

            final SparqlQueryBuilder sqb = parser
                    .parse(connection.getCatalogs(), table.getCatalog(), table.getSchema(), query.toString())
                    .setKey(table.getKey());
            return new SparqlResultSet(table, sqb.build());
        } else {
            return table.getResultSet(connection.getCatalogs(), parser);
        }
    }

    @Override
    public String getSchemaTerm() throws SQLException {
        return "schema";
    }

    @Override
    public String getSearchStringEscape() throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public String getSQLKeywords() throws SQLException {
        return "";
    }

    @Override
    public int getSQLStateType() throws SQLException {
        // TODO Auto-generated method stub
        return 0;
    }

    @Override
    public String getStringFunctions() throws SQLException {
        return makeString(parser.getSupportedStringFunctions().iterator());
    }

    @Override
    public ResultSet getSuperTables(final String catalogP, final String schemaP, final String tableNameP)
            throws SQLException {
        String catalogPattern = catalogP;
        String schemaPattern = schemaP;
        String tableNamePattern = tableNameP;
        if (tableNameP.contains(".")) {
            final String[] parts = tableNameP.split("\\.");
            if (parts.length > 3) {
                throw new SQLException(String.format("Invalid tableName: %s", tableNameP));
            }
            if (parts.length == 3) {
                catalogPattern = parts[0];
                schemaPattern = parts[1];
                tableNamePattern = parts[2];
            }
            if (parts.length == 2) {
                schemaPattern = parts[0];
                tableNamePattern = parts[1];
            }
        }
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.SUPER_TABLES_TABLE));

        for (final Catalog catalog : new NameFilter<Catalog>(catalogPattern, connection.getCatalogs().values())) {
            for (final Schema schema : new NameFilter<Schema>(schemaPattern, catalog.getSchemas())) {
                for (final Table tbl : new NameFilter<Table>(tableNamePattern, schema.getTables())) {
                    if (tbl.getSuperTable() != null) {
                        final Object[] data = { catalog.getName(), // TABLE_CAT
                                schema.getName(), // TABLE_SCHEM
                                tbl.getName(), // TABLE_NAME
                                tbl.getSuperTable().getName(), // SUPERTABLE_NAME
                        };
                        table.addData(data);
                    }
                }
            }
        }
        return table.getResultSet();
    }

    @Override
    public ResultSet getSuperTypes(final String arg0, final String arg1, final String arg2) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.SUPER_TYPES_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public String getSystemFunctions() throws SQLException {
        return makeString(parser.getSupportedSystemFunctions().iterator());
    }

    @Override
    public ResultSet getTablePrivileges(final String catalogPattern, final String schemaPattern,
            final String tablePattern) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.TABLE_PRIVILEGES_TABLE));
        for (final Catalog catalog : new NameFilter<Catalog>(catalogPattern, connection.getCatalogs().values())) {
            for (final Schema schema : new NameFilter<Schema>(schemaPattern, catalog.getSchemas())) {
                for (final Table tbl : new NameFilter<Table>(tablePattern, schema.getTables())) {
                    // TODO populate table here.
                }
            }
        }

        return table.getResultSet();
    }

    @Override
    public ResultSet getTables(final String catalogPattern, final String schemaPattern,
            final String tableNamePattern, final String[] types) throws SQLException {
        if (J4SDatabaseMetaData.LOG.isDebugEnabled()) {
            J4SDatabaseMetaData.LOG.debug(String.format("getting tables %s.%s.%s types %s", catalogPattern,
                    schemaPattern, tableNamePattern, types));
        }
        final RdfTable table = (RdfTable) metaSchema.getTable(MetaCatalogBuilder.TABLES_TABLE);
        if ((catalogPattern != null) || (schemaPattern != null) || (tableNamePattern != null) || (types != null)) {
            boolean hasWhere = false;
            final StringBuilder query = new StringBuilder()
                    .append(String.format("SELECT * FROM %s WHERE ", table.getSQLName()));
            if (catalogPattern != null) {
                query.append(String.format("TABLE_CAT LIKE '%s'", getCatalogName(catalogPattern)));
                hasWhere = true;
            }
            if (schemaPattern != null) {
                query.append(hasWhere ? " AND " : "")
                        .append(String.format("TABLE_SCHEM LIKE '%s'", getSchemaName(schemaPattern)));
                hasWhere = true;
            }
            if (tableNamePattern != null) {
                query.append(hasWhere ? " AND " : "")
                        .append(String.format("TABLE_NAME LIKE '%s'", escapeString(tableNamePattern)));
                hasWhere = true;
            }
            if ((types != null) && (types.length > 0)) {
                query.append(hasWhere ? " AND (" : "(");
                for (int i = 0; i < types.length; i++) {
                    query.append(i > 0 ? " OR " : "").append(types.length > 1 ? "(" : "")
                            .append(String.format("TABLE_TYPE LIKE '%s'", escapeString(types[i])))
                            .append(types.length > 1 ? ")" : "");
                }
                query.append(")");

                hasWhere = true;
            }

            final SparqlQueryBuilder sqb = parser
                    .parse(connection.getCatalogs(), table.getCatalog(), table.getSchema(), query.toString())
                    .setKey(table.getKey());
            return new SparqlResultSet(table, sqb.build());
        } else {
            return table.getResultSet(connection.getCatalogs(), parser);
        }
    }

    @Override
    public ResultSet getTableTypes() throws SQLException {
        return ((RdfTable) metaSchema.getTable(MetaCatalogBuilder.TABLE_TYPES_TABLE))
                .getResultSet(connection.getCatalogs(), parser);
    }

    @Override
    public String getTimeDateFunctions() throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public ResultSet getTypeInfo() throws SQLException {
        return ((RdfTable) metaSchema.getTable(MetaCatalogBuilder.TYPEINFO_TABLE))
                .getResultSet(connection.getCatalogs(), parser);
    }

    @Override
    public ResultSet getUDTs(final String catalog, final String schemaPattern, final String typeNamePattern,
            final int[] types) throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.UDT_TABLES));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public String getURL() throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public String getUserName() throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public ResultSet getVersionColumns(final String arg0, final String arg1, final String arg2)
            throws SQLException {
        final DataTable table = new DataTable(metaSchema.getTable(MetaCatalogBuilder.VERSION_COLUMNS_TABLE));
        // TODO populate table here.
        return table.getResultSet();
    }

    @Override
    public boolean insertsAreDetected(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean isCatalogAtStart() throws SQLException {
        return true;
    }

    @Override
    public boolean isReadOnly() throws SQLException {
        return true;
    }

    @Override
    public boolean isWrapperFor(final Class<?> iface) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean locatorsUpdateCopy() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    private String makeString(final Iterator<String> strings) {
        final StringBuilder sb = new StringBuilder();
        while (strings.hasNext()) {
            if (sb.length() > 0) {
                sb.append(",");
            }
            sb.append(strings.next());
        }
        return sb.toString();
    }

    @Override
    public boolean nullPlusNonNullIsNull() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean nullsAreSortedAtEnd() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean nullsAreSortedAtStart() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean nullsAreSortedHigh() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean nullsAreSortedLow() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean othersDeletesAreVisible(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean othersInsertsAreVisible(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean othersUpdatesAreVisible(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean ownDeletesAreVisible(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean ownInsertsAreVisible(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean ownUpdatesAreVisible(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean storesLowerCaseIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean storesLowerCaseQuotedIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean storesMixedCaseIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean storesMixedCaseQuotedIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean storesUpperCaseIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean storesUpperCaseQuotedIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsAlterTableWithAddColumn() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsAlterTableWithDropColumn() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsANSI92EntryLevelSQL() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsANSI92FullSQL() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsANSI92IntermediateSQL() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsBatchUpdates() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsCatalogsInDataManipulation() throws SQLException {
        return false;
    }

    @Override
    public boolean supportsCatalogsInIndexDefinitions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsCatalogsInProcedureCalls() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsCatalogsInTableDefinitions() throws SQLException {
        return true;
    }

    @Override
    public boolean supportsColumnAliasing() throws SQLException {
        return true;
    }

    @Override
    public boolean supportsConvert() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsConvert(final int arg0, final int arg1) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsCoreSQLGrammar() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsCorrelatedSubqueries() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsDataManipulationTransactionsOnly() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsDifferentTableCorrelationNames() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsExpressionsInOrderBy() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsExtendedSQLGrammar() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsFullOuterJoins() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsGetGeneratedKeys() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsGroupBy() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsGroupByBeyondSelect() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsGroupByUnrelated() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsIntegrityEnhancementFacility() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsLikeEscapeClause() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsLimitedOuterJoins() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsMinimumSQLGrammar() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsMixedCaseIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsMultipleOpenResults() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsMultipleResultSets() throws SQLException {
        return true;
    }

    @Override
    public boolean supportsMultipleTransactions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsNamedParameters() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsNonNullableColumns() throws SQLException {
        return true;
    }

    @Override
    public boolean supportsOpenCursorsAcrossCommit() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsOpenCursorsAcrossRollback() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsOpenStatementsAcrossCommit() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsOpenStatementsAcrossRollback() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsOrderByUnrelated() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsOuterJoins() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsPositionedDelete() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsPositionedUpdate() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsResultSetConcurrency(final int arg0, final int arg1) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsResultSetHoldability(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsResultSetType(final int arg0) throws SQLException {
        switch (arg0) {
        case ResultSet.TYPE_FORWARD_ONLY:
        case ResultSet.CONCUR_READ_ONLY:
        case ResultSet.TYPE_SCROLL_INSENSITIVE:
        case ResultSet.HOLD_CURSORS_OVER_COMMIT:
            return true;

        case ResultSet.CLOSE_CURSORS_AT_COMMIT:
        case ResultSet.CONCUR_UPDATABLE:
        case ResultSet.TYPE_SCROLL_SENSITIVE:
        default:
            return false;
        }
    }

    @Override
    public boolean supportsSavepoints() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSchemasInDataManipulation() throws SQLException {
        J4SDatabaseMetaData.LOG.debug("supportsSchemasInDataManipulation: true ");
        return true;
    }

    @Override
    public boolean supportsSchemasInIndexDefinitions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSchemasInProcedureCalls() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSchemasInTableDefinitions() throws SQLException {
        J4SDatabaseMetaData.LOG.debug("supportsSchemasInTableDefinitions: true ");
        return true;
    }

    @Override
    public boolean supportsSelectForUpdate() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsStatementPooling() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsStoredFunctionsUsingCallSyntax() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsStoredProcedures() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSubqueriesInComparisons() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSubqueriesInExists() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSubqueriesInIns() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsSubqueriesInQuantifieds() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsTableCorrelationNames() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsTransactionIsolationLevel(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsTransactions() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsUnion() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean supportsUnionAll() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public <T> T unwrap(final Class<T> iface) throws SQLException {
        // TODO Auto-generated method stub
        return null;
    }

    @Override
    public boolean updatesAreDetected(final int arg0) throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean usesLocalFilePerTable() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

    @Override
    public boolean usesLocalFiles() throws SQLException {
        // TODO Auto-generated method stub
        return false;
    }

}