VirtualDatabaseDynamicMetaData.java

/**
 * C-JDBC: Clustered JDBC.
 * Copyright (C) 2002-2005 French National Institute For Research In Computer
 * Science And Control (INRIA).
 * Contact: c-jdbc@objectweb.org
 * 
 * This library is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as published by the
 * Free Software Foundation; either version 2.1 of the License, or any later
 * version.
 * 
 * This library is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
 * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License
 * for more details.
 * 
 * You should have received a copy of the GNU Lesser General Public License
 * along with this library; if not, write to the Free Software Foundation,
 * Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
 *
 * Initial developer(s): Julie Marguerite.
 * Contributor(s): Emmanuel Cecchet, Nicolas Modrzyk.
 */

package org.objectweb.cjdbc.controller.virtualdatabase;

import java.sql.SQLException;
import java.sql.Types;
import java.util.ArrayList;

import org.objectweb.cjdbc.common.log.Trace;
import org.objectweb.cjdbc.common.sql.schema.DatabaseColumn;
import org.objectweb.cjdbc.common.sql.schema.DatabaseProcedure;
import org.objectweb.cjdbc.common.sql.schema.DatabaseProcedureParameter;
import org.objectweb.cjdbc.common.sql.schema.DatabaseSchema;
import org.objectweb.cjdbc.common.sql.schema.DatabaseTable;
import org.objectweb.cjdbc.common.users.VirtualDatabaseUser;
import org.objectweb.cjdbc.controller.authentication.AuthenticationManager;
import org.objectweb.cjdbc.controller.requestmanager.RequestManager;
import org.objectweb.cjdbc.driver.DriverResultSet;
import org.objectweb.cjdbc.driver.Field;

/**
 * Class that gathers the dynamic metadata for a virtual database, that means
 * all the metadata subject to changes during the lifetime of the application.
 * 
 * @author <a href="mailto:Julie.Marguerite@inria.fr">Julie.Marguerite </a>
 * @author <a href="mailto:Emmanuel.Cecchet@inria.fr">Emmanuel Cecchet </a>
 * @author <a href="mailto:Nicolas.Modrzyk@inrialpes.fr">Nicolas Modrzyk </a>
 */
public class VirtualDatabaseDynamicMetaData
{

  /** Detect a null valu for int */
  public static final int NULL_VALUE = -999;

  private String          vdbName;
  private RequestManager  requestManager;

  /** Logger instance. */
  private Trace           logger     = null;

  /**
   * Reference the database for this metadata. Do not fetch any data at this
   * time
   * 
   * @param database to link this metadata to
   */
  public VirtualDatabaseDynamicMetaData(VirtualDatabase database)
  {
    this.vdbName = database.getVirtualDatabaseName();
    requestManager = database.getRequestManager();
    if (requestManager == null)
      throw new RuntimeException(
          "Null request manager in VirtualDatabaseMetaData");

    this.logger = Trace
        .getLogger("org.objectweb.cjdbc.controller.virtualdatabase.VirtualDatabaseWorkerThread."
            + vdbName + ".metadata");
  }

  private DatabaseSchema getDatabaseSchema()
  {
    try
    { // Try to get a fresh schema
      return requestManager.getVirtualDatabase()
          .getDatabaseSchemaFromActiveBackendsAndRefreshDatabaseProductNames();
    }
    catch (SQLException e)
    { // Default to what we statically have in the RequestManager
      return requestManager.getDatabaseSchema();
    }
  }

  /**
   * Gets a description of a table's primary key columns. They are ordered by
   * COLUMN_NAME.
   * 
   * @see java.sql.DatabaseMetaData#getPrimaryKeys
   */
  public java.sql.ResultSet getPrimaryKeys(String catalog, String schema,
      String table)
  {
    if (logger.isDebugEnabled())
      logger.debug("Getting getPrimaryKeys for " + vdbName);
    DatabaseSchema dbs = this.getDatabaseSchema();
    if (dbs == null)
      return null;

    if (table == null)
      table = "%"; // if null is passed then
    // select all tables

    // Build the ResultSet
    ArrayList tables = dbs.getTables();
    int size = tables.size();
    ArrayList data = new ArrayList();

    for (int i = 0; i < size; i++)
    {
      DatabaseTable t = (DatabaseTable) tables.get(i);
      if (table.equals("%") || table.equals(t.getName()))
      {
        ArrayList columns = t.getColumns();
        for (int j = 0; j < columns.size(); j++)
        {
          DatabaseColumn c = (DatabaseColumn) columns.get(j);
          if (c.isUnique())
          {
            if (logger.isDebugEnabled())
              logger.debug("Found primary key" + c.getName());
            Object[] row = new Object[6];
            row[0] = vdbName; // TABLE_CAT
            row[1] = null; // TABLE_SCHEM
            row[2] = t.getName(); // TABLE_NAME
            row[3] = c.getName(); // COLUMN_NAME
            row[4] = new Integer(c.getType()); // KEY_SEQ
            row[5] = c.getName(); // PK_NAME
            data.add(row);
          }
          else
          {
            if (logger.isDebugEnabled())
              logger.debug("Key " + c.getName() + " is not unique");
          }
        }
      }
    }
    DriverResultSet rs = new DriverResultSet(getPrimaryKeysFields, data);
    return rs;
  }

  /**
   * @see java.sql.DatabaseMetaData#getColumns
   */
  public DriverResultSet getColumns(String catalog, String schemaPattern,
      String tableNamePattern, String columnNamePattern)
  {
    if (logger.isDebugEnabled())
      logger.debug("Getting columns for " + vdbName);
    DatabaseSchema dbs = this.getDatabaseSchema();
    if (dbs == null)
      return null;

    if (tableNamePattern == null)
      tableNamePattern = "%"; // if null is passed then select
    // all tables

    if (columnNamePattern == null)
      columnNamePattern = "%"; // if null is passed then

    // Build the ResultSet
    ArrayList tables = dbs.getTables();
    int size = tables.size();
    ArrayList data = new ArrayList();

    for (int i = 0; i < size; i++)
    {
      DatabaseTable t = (DatabaseTable) tables.get(i);

      if (tableNamePattern.equals("%") || tableNamePattern.equals(t.getName()))
      {
        if (logger.isDebugEnabled())
          logger.debug("Found table " + t.getName());
        ArrayList columns = t.getColumns();
        for (int j = 0; j < columns.size(); j++)
        {
          DatabaseColumn c = (DatabaseColumn) columns.get(j);
          if (columnNamePattern.equals("%")
              || columnNamePattern.equals(c.getName()))
          {
            if (logger.isDebugEnabled())
              logger.debug("Found column " + c.getName());
            Object[] row = new Object[18];
            row[0] = vdbName; // TABLE_CAT
            row[1] = null; // TABLE_SCHEM
            row[2] = t.getName(); // TABLE_NAME
            row[3] = c.getName(); // COLUMN_NAME
            row[4] = new Integer(c.getType()); // DATA_TYPE
            row[5] = null; // TYPE_NAME
            row[6] = null; // COLUMN_SIZE
            row[7] = null; // BUFFER_LENGTH
            row[8] = null; // DECIMAL_DIGITS
            row[9] = null; // NUM_PREC_RADIX
            row[10] = null; // NULLABLE
            row[11] = null; // REMARKS
            row[12] = null; // COLUMN_DEF
            row[13] = null; // SQL_DATA_TYPE
            row[14] = null; // SQL_DATETIME_SUB
            row[15] = null; // CHAR_OCTET_LENGTH
            row[16] = null; // ORDINAL_POSITION
            row[17] = ""; // IS_NULLABLE
            data.add(row);
          }
        }
      }
    }
    DriverResultSet rs = new DriverResultSet(getColumnsFields, data);
    return rs;
  }

  /**
   * @see java.sql.DatabaseMetaData#getSchemas()
   *      <p>
   *      TODO: what do we put in schemas ? The JDBC reference and API is
   *      somewhat unclear !
   */
  public Object getSchemas()
  {
    ArrayList data = new ArrayList();
    DriverResultSet rs = new DriverResultSet(getSchemasFields, data);
    return rs;
  }

  /**
   * @see org.objectweb.cjdbc.driver.DatabaseMetaData#getTables(String, String,
   *      String, String[])
   */
  public DriverResultSet getTables(String catalog, String schemaPattern,
      String tableNamePattern, String[] types)
  {
    DatabaseSchema dbs = this.getDatabaseSchema();
    if (dbs == null)
      return null;

    if (tableNamePattern == null)
      // if null is passed then select all tables
      tableNamePattern = "%";

    // Build the ResultSet
    ArrayList tables = dbs.getTables();
    int size = tables.size();
    ArrayList data = new ArrayList();
    for (int i = 0; i < size; i++)
    {
      DatabaseTable t = (DatabaseTable) tables.get(i);
      if (tableNamePattern.equals("%")
          || t.getName().indexOf(tableNamePattern) != -1)
      {
        if (logger.isDebugEnabled())
          logger.debug("Found table " + t.getName());
        Object[] row = new Object[10];
        row[0] = vdbName; // TABLE_CAT
        row[1] = null; // TABLE_SCHEM
        row[2] = t.getName(); // TABLE_NAME
        row[3] = "TABLE"; // TABLE_TYPE
        row[4] = null; // REMARKS
        row[5] = null; // TYPE_CAT
        row[6] = null; // TYPE_SCHEM
        row[7] = null; // TYPE_NAME
        row[8] = null; // SELF_REFERENCING_COL_NAME
        row[9] = "SYSTEM"; // REF_GENERATION
        data.add(row);
      }
    }
    DriverResultSet rs = new DriverResultSet(getTablesFields, data);
    return rs;
  }

  /**
   * @see org.objectweb.cjdbc.driver.DatabaseMetaData#getProcedures
   */
  public DriverResultSet getProcedures(String catalog, String schemaPattern,
      String procedureNamePattern)
  {
    DatabaseSchema dbs = this.getDatabaseSchema();
    if (dbs == null)
      return null;

    if (procedureNamePattern == null)
      procedureNamePattern = "%"; // if null is passed then
    // select all procedures

    // Build the ResultSet
    ArrayList procedures = dbs.getProcedures();
    int size = procedures.size();
    ArrayList data = new ArrayList();
    for (int i = 0; i < size; i++)
    {
      DatabaseProcedure t = (DatabaseProcedure) procedures.get(i);
      if (procedureNamePattern.equals("%")
          || procedureNamePattern.equals(t.getName()))
      {
        if (logger.isDebugEnabled())
          logger.debug("Found procedure " + t.getName());
        Object[] row = new Object[8];
        row[0] = vdbName; // PROCEDURE_CAT
        row[1] = null; // PROCEDURE_SCHEM
        row[2] = t.getName(); // PROCEDURE_NAME
        row[3] = null; // reserved for future use
        row[4] = null; // reserved for future use
        row[5] = null; // reserved for future use
        row[6] = t.getRemarks(); // REMARKS
        row[7] = new Integer(t.getProcedureType()); // PROCEDURE_TYPE
        data.add(row);
      }
    }
    DriverResultSet rs = new DriverResultSet(getProceduresFields, data);
    return rs;
  }

  /**
   * get list of Catalogs (database)
   * 
   * @param list of database from the controller
   * @return <code>ResultSet</code> with list of catalogs
   */
  public DriverResultSet getCatalogs(ArrayList list)
  {
    int size = list.size();
    ArrayList data = new ArrayList(size);
    for (int i = 0; i < size; i++)
    {
      Object[] row = new Object[1];
      row[0] = (String) list.get(i);
      data.add(row);
    }
    DriverResultSet rs = new DriverResultSet(getCatalogsFields, data);
    return rs;
  }

  /**
   * @see org.objectweb.cjdbc.driver.DatabaseMetaData#getTableTypes
   */
  public DriverResultSet getTableTypes()
  {
    ArrayList list = new ArrayList(1);
    Object[] row = new Object[1];
    row[0] = "TABLE";
    list.add(row);
    DriverResultSet rs = new DriverResultSet(getTableTypesFields, list);
    return rs;
  }

  /**
   * @see org.objectweb.cjdbc.driver.DatabaseMetaData#getTableTypes
   */
  public DriverResultSet getTablePrivileges(String catalog,
      String schemaPattern, String tableNamePattern)
  {
    AuthenticationManager manager = requestManager.getVirtualDatabase()
        .getAuthenticationManager();
    DatabaseSchema dbs = this.getDatabaseSchema();
    if (dbs == null)
      return null;

    if (tableNamePattern == null)
      // if null is passed then select all tables
      tableNamePattern = "%";

    ArrayList tables = dbs.getTables();
    int size = tables.size();
    ArrayList data = new ArrayList();

    ArrayList virtualLogins = manager.getVirtualLogins();
    int vsize = virtualLogins.size();
    VirtualDatabaseUser vu;

    for (int i = 0; i < size; i++)
    {
      DatabaseTable t = (DatabaseTable) tables.get(i);
      if (tableNamePattern.equals("%") || tableNamePattern.equals(t.getName()))
      {
        for (int j = 0; j < vsize; j++)
        {
          vu = (VirtualDatabaseUser) virtualLogins.get(0);

          if (logger.isDebugEnabled())
            logger.debug("Found privilege for user:" + vu.getLogin()
                + " on table:" + t.getName());
          Object[] row = new Object[7];
          row[0] = vdbName; // table cat
          row[1] = null; // table schema
          row[2] = t.getName(); // table name
          row[3] = null; // grantor
          row[4] = vu.getLogin(); // grantee
          row[5] = "UPDATE"; // privilege
          row[6] = "NO"; //IS_GRANTABLE
          data.add(row);
        }
      }
    }

    DriverResultSet rs = new DriverResultSet(getTablePrivilegesFields, data);
    return rs;
  }

  /**
   * @see org.objectweb.cjdbc.driver.DatabaseMetaData#getProcedureColumns
   */
  public DriverResultSet getProcedureColumns(String catalog,
      String schemaPattern, String procedureNamePattern,
      String columnNamePattern)
  {
    DatabaseSchema dbs = this.getDatabaseSchema();
    if (dbs == null)
      return null;

    if (procedureNamePattern == null)
      procedureNamePattern = "%";

    if (columnNamePattern == null)
      columnNamePattern = "%";

    //Build the ResultSet
    ArrayList procedures = dbs.getProcedures();
    int size = procedures.size();
    ArrayList data = new ArrayList();
    for (int i = 0; i < size; i++)
    {
      DatabaseProcedure t = (DatabaseProcedure) procedures.get(i);
      if (procedureNamePattern.equals("%")
          || procedureNamePattern.equals(t.getName()))
      {
        if (logger.isDebugEnabled())
          logger.debug("Found matching procedure " + t.getName());

        ArrayList params = t.getParameters();
        int sizep = params.size();
        DatabaseProcedureParameter param;
        for (int k = 0; k < sizep; k++)
        {
          param = (DatabaseProcedureParameter) params.get(k);
          if (columnNamePattern.equals("%")
              || columnNamePattern.equals(t.getName()))
          {
            if (logger.isDebugEnabled())
              logger.debug("Found matching procedure parameter"
                  + param.getName());

            Object[] row = new Object[13];
            row[0] = vdbName; // PROCEDURE_CAT
            row[1] = null; // PROCEDURE_SCHEM
            row[2] = t.getName(); // PROCEDURE_NAME
            row[3] = param.getName(); // COLUMN_NAME
            row[4] = new Integer(param.getColumnType()); // COLUMN_TYPE
            row[5] = new Integer(param.getDataType()); // DATA_TYPE
            row[6] = param.getTypeName(); // TYPE_NAME
            row[7] = new Float(param.getPrecision()); // PRECISION
            row[8] = new Integer(param.getLength()); // LENGTH
            row[9] = new Integer(param.getScale()); // SCALE
            row[10] = new Integer(param.getRadix()); // RADIX
            row[11] = new Integer(param.getNullable()); // NULLABLE
            row[12] = param.getRemarks();

            data.add(row);
          }
        }
      }
    }
    DriverResultSet rs = new DriverResultSet(getProcedureColumnsFields, data);
    return rs;
  }

  private static Field[] getSchemasFields          = new Field[]{new Field(
                                                       "TABLE_SCHEM",
                                                       "TABLE_SCHEM", 9,
                                                       Types.VARCHAR,
                                                       "VARCHAR", "String")};

  private static Field[] getProcedureColumnsFields = new Field[]{
      new Field("PROCEDURE_CAT", "PROCEDURE_CAT", 9, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("PROCEDURE_SCHEM", "PROCEDURE_SCHEM", 10, Types.VARCHAR,
          "VARCHAR", "String"),
      new Field("PROCEDURE_NAME", "PROCEDURE_NAME", 10, Types.VARCHAR,
          "VARCHAR", "String"),
      new Field("COLUMN_NAME", "COLUMN_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("COLUMN_TYPE", "COLUMN_TYPE", 10, Types.SMALLINT, "SMALLINT",
          "Short"),
      new Field("DATA_TYPE", "DATA_TYPE", 10, Types.SMALLINT, "SMALLINT",
          "Short"),
      new Field("TYPE_NAME", "TYPE_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("PRECISION", "PRECISION", 10, Types.FLOAT, "FLOAT", "Float"),
      new Field("LENGTH", "LENGTH", 10, Types.INTEGER, "INTEGER", "Integer"),
      new Field("SCALE", "SCALE", 10, Types.SMALLINT, "SMALLINT", "Short"),
      new Field("RADIX", "RADIX", 10, Types.SMALLINT, "SMALLINT", "Short"),
      new Field("NULLABLE", "NULLABLE", 10, Types.SMALLINT, "SMALLINT", "Short"),
      new Field("REMARKS", "REMARKS", 10, Types.VARCHAR, "VARCHAR", "String")};

  private static Field[] getCatalogsFields         = new Field[]{new Field(
                                                       "TABLE_CAT",
                                                       "TABLE_CAT", 9,
                                                       Types.VARCHAR,
                                                       "VARCHAR", "String")};

  private static Field[] getTableTypesFields       = new Field[]{new Field(
                                                       "TABLE_TYPE",
                                                       "TABLE_TYPE", 9,
                                                       Types.VARCHAR,
                                                       "VARCHAR", "String")};

  private static Field[] getTablePrivilegesFields  = new Field[]{
      new Field("TABLE_CAT", "TABLE_CAT", 9, Types.VARCHAR, "VARCHAR", "String"),
      new Field("TABLE_SCHEM", "TABLE_SCHEM", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("TABLE_NAME", "TABLE_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("GRANTOR", "GRANTOR", 10, Types.VARCHAR, "VARCHAR", "String"),
      new Field("GRANTEE", "GRANTEE", 10, Types.VARCHAR, "VARCHAR", "String"),
      new Field("PRIVILEGE", "PRIVILEGE", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("IS_GRANTABLE", "IS_GRANTABLE", 10, Types.VARCHAR, "VARCHAR",
          "String"),                               };

  //  # TABLE_CAT String => table catalog (may be null)
  //  # TABLE_SCHEM String => table schema (may be null)
  //  # TABLE_NAME String => table name
  //  # GRANTOR => grantor of access (may be null)
  //  # GRANTEE String => grantee of access
  //  # PRIVILEGE String => name of access (SELECT, INSERT, UPDATE, REFRENCES,
  // ...)
  //  # IS_GRANTABLE String => "YES" if grantee is permitted to grant to othe

  private static Field[] getProceduresFields       = new Field[]{
      new Field("PROCEDURE_CAT", "PROCEDURE_CAT", 9, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("PROCEDURE_SCHEM", "PROCEDURE_SCHEM", 10, Types.VARCHAR,
          "VARCHAR", "String"),
      new Field("PROCEDURE_NAME", "PROCEDURE_NAME", 10, Types.VARCHAR,
          "VARCHAR", "String"),
      new Field("", "", 0, Types.VARCHAR, "VARCHAR", "String"),
      new Field("", "", 0, Types.VARCHAR, "VARCHAR", "String"),
      new Field("", "", 0, Types.VARCHAR, "VARCHAR", "String"),
      new Field("REMARKS", "REMARKS", 10, Types.VARCHAR, "VARCHAR", "String"),
      new Field("PROCEDURE_TYPE", "PROCEDURE_TYPE", 10, Types.SMALLINT,
          "SMALLINT", "Short")                     };

  //
  //# TABLE_CAT String => table catalog (may be null)
  //# TABLE_SCHEM String => table schema (may be null)
  //# TABLE_NAME String => table name
  //# COLUMN_NAME String => column name
  //# KEY_SEQ short => sequence number within primary key
  //# PK_NAME String => primary key name (may be null)
  //

  private static Field[] getPrimaryKeysFields      = new Field[]{
      new Field("TABLE_CAT", "TABLE_CAT", 9, Types.VARCHAR, "VARCHAR", "String"),
      new Field("TABLE_SCHEM", "TABLE_SCHEM", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("TABLE_NAME", "TABLE_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("COLUMN_NAME", "COLUMN_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("KEY_SEQ", "KEY_SEQ", 10, Types.SMALLINT, "SMALLINT", "Short"),
      new Field("PK_NAME", "PK_NAME", 10, Types.VARCHAR, "VARCHAR", "String")};

  /** @see java.sql.DatabaseMetaData#getColumns */
  private static Field[] getColumnsFields          = new Field[]{
      new Field("TABLE_CAT", "TABLE_CAT", 9, Types.VARCHAR, "VARCHAR", "String"),
      new Field("TABLE_SCHEM", "TABLE_SCHEM", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("TABLE_NAME", "TABLE_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("COLUMN_NAME", "COLUMN_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("DATA_TYPE", "DATA_TYPE", 10, Types.SMALLINT, "SMALLINT",
          "Short"),
      new Field("TYPE_NAME", "TYPE_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("COLUMN_SIZE", "COLUMN_SIZE", 10, Types.INTEGER, "INTEGER",
          "Integer"),
      new Field("BUFFER_LENGTH", "BUFFER_LENGTH", 10, Types.INTEGER, "INTEGER",
          "Integer"),
      new Field("DECIMAL_DIGITS", "DECIMAL_DIGITS", 10, Types.INTEGER,
          "INTEGER", "Integer"),
      new Field("NUM_PREC_RADIX", "NUM_PREC_RADIX", 10, Types.INTEGER,
          "INTEGER", "Integer"),
      new Field("NULLABLE", "NULLABLE", 10, Types.INTEGER, "INTEGER", "Integer"),
      new Field("REMARKS", "REMARKS", 10, Types.VARCHAR, "VARCHAR", "String"),
      new Field("COLUMN_DEF", "COLUMN_DEF", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("SQL_DATA_TYPE", "SQL_DATA_TYPE", 10, Types.INTEGER, "INTEGER",
          "Integer"),
      new Field("SQL_DATETIME_SUB", "SQL_DATETIME_SUB", 10, Types.INTEGER,
          "INTEGER", "Integer"),
      new Field("CHAR_OCTET_LENGTH", "CHAR_OCTET_LENGTH", 10, Types.INTEGER,
          "INTEGER", "Integer"),
      new Field("ORDINAL_POSITION", "ORDINAL_POSITION", 10, Types.INTEGER,
          "INTEGER", "Integer"),
      new Field("IS_NULLABLE", "IS_NULLABLE", 10, Types.VARCHAR, "VARCHAR",
          "String")                                };

  /** @see java.sql.DatabaseMetaData#getTables(String, String, String, String[]) */
  private static Field[] getTablesFields           = new Field[]{
      new Field("TABLE_CAT", "TABLE_CAT", 9, Types.VARCHAR, "VARCHAR", "String"),
      new Field("TABLE_SCHEM", "TABLE_SCHEM", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("TABLE_NAME", "TABLE_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("TABLE_TYPE", "TABLE_TYPE", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("REMARKS", "REMARKS", 10, Types.VARCHAR, "VARCHAR", "String"),
      new Field("TYPE_CAT", "TYPE_CAT", 10, Types.VARCHAR, "VARCHAR", "String"),
      new Field("TYPE_SCHEM", "TYPE_SCHEM", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("TYPE_NAME", "TYPE_NAME", 10, Types.VARCHAR, "VARCHAR",
          "String"),
      new Field("SELF_REFERENCING_COL_NAME", "SELF_REFERENCING_COL_NAME", 25,
          Types.VARCHAR, "VARCHAR", "String"),
      new Field("REF_GENERATION", "REF_GENERATION", 15, Types.VARCHAR,
          "VARCHAR", "String")                     };

}

---