Examples of SQLDatabaseMetaData

net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData
This class represents the metadata for a database. It is essentially a wrapper around java.sql.DatabaseMetaData.
Some data can be cached on the first retrieval in order to speed up subsequent retrievals. To clear this cache call clearCache().
From the JavaDoc for java.sql.DatabaseMetaData. "Some methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the search pattern are returned. If a search pattern argument is set to null, that argument's criterion will be dropped from the search."
Additionally, it should be noted that some JDBC drivers (like Oracle) do not handle multi-threaded access to methods that return ResultSets very well. It is therefore highly recommended that methods in this class that return a ResultSet, should not be called outside of this class where this class' monitor has no jurisdiction. Furthermore, methods that are meant to be called externally that create a ResultSet should package the data in some container object structure for use by the caller, and should always be synchronized on this class' monitor. @author Colin Bell

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

  /**
   * Create the <TT>IDataSet</TT> to be displayed in this tab.
   */
  protected IDataSet createDataSet() throws DataSetException
  {
    final SQLDatabaseMetaData md = 
            getSession().getSQLConnection().getSQLMetaData();
    return md.getVersionColumnsDataSet(getTableInfo()); 
  }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

        throws SQLException 
    {
        final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
        final IDatabaseObjectInfo parentDbinfo = parentNode
                .getDatabaseObjectInfo();
        final SQLDatabaseMetaData md = session.getSQLConnection()
                .getSQLMetaData();
        final String schemaName = parentDbinfo.getSchemaName();


        if (triggerExtractor != null) {
            IDatabaseObjectInfo triggerParentInfo =

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSimpleName();


    IDatabaseObjectInfo seqInfo =
      new DatabaseObjectInfo(catalogName, schemaName, _inodeFactory.getParentLabelForType(_dbObjType),

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    throws SQLException
  {
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = conn.getSQLMetaData();


    boolean supportsCatalogs = false;
    try
    {
      supportsCatalogs = md.supportsCatalogs();
    }
    catch (SQLException ex)
    {
      s_log.debug("DBMS doesn't support 'supportsCatalogs()", ex);
    }


    boolean supportsSchemas = false;
    try
    {
      supportsSchemas = md.supportsSchemas();
    }
    catch (SQLException ex)
    {
      s_log.debug("DBMS doesn't support 'supportsSchemas()", ex);
    }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

    final List<ObjectTreeNode> list = new ArrayList<ObjectTreeNode>();


    if (session.getProperties().getLoadSchemasCatalogs())
    {
      final ISQLConnection conn = session.getSQLConnection();
      final SQLDatabaseMetaData md = conn.getSQLMetaData();


      // Add table types to list.
      if (_tableTypes.length > 0)
      {
        for (int i = 0; i < _tableTypes.length; ++i)
        {
          IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName,
                          schemaName, _tableTypes[i],
                          DatabaseObjectType.TABLE_TYPE_DBO, md);
          ObjectTreeNode child = new ObjectTreeNode(session, dbo);
          list.add(child);
        }
      }
      else
      {
        s_log.debug("List of table types is empty so trying null table type to load all tables");
        IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName,
                        schemaName, null,
                        DatabaseObjectType.TABLE_TYPE_DBO, md);
        ObjectTreeNode child = new ObjectTreeNode(session, dbo);
        child.setUserObject("TABLE");
        list.add(child);
      }


      // Add stored proc parent node.
      boolean supportsStoredProcs = false;
      try
      {
        supportsStoredProcs = md.supportsStoredProcedures();
      }
      catch (SQLException ex)
      {
        s_log.debug("DBMS doesn't support 'supportsStoredProcedures()'", ex);
      }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

        throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String schemaName = parentDbinfo.getSchemaName();
    final String catalogName = parentDbinfo.getCatalogName();
    final IDatabaseObjectInfo tableInfo = ((TriggerParentInfo) parentDbinfo).getTableInfo();
    PreparedStatement pstmt = null;
    ResultSet rs = null;

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

  protected IDataSet createDataSet() throws DataSetException
  {
    final ISession session = getSession();
    try
    {
      final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
      return new ObjectArrayDataSet(md.getSystemFunctions());
    }
    catch (SQLException ex)
    {
      throw new DataSetException(ex);
    }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

  protected IDataSet createDataSet() throws DataSetException
  {
    final ISession session = getSession();
    try
    {
      final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
      return new ObjectArrayDataSet(md.getTimeDateFunctions());
    }
    catch (SQLException ex)
    {
      throw new DataSetException(ex);
    }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

   */
  protected IDataSet createDataSet() throws DataSetException
  {
    final ISQLConnection conn = getSession().getSQLConnection();
        IDataSet result = null;
        SQLDatabaseMetaData md = conn.getSQLMetaData();
        result = md.getPrimaryKey(getTableInfo(),
                                  new int[] { 6, 5, 4 },
                                  true);
        return result;
  }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

  protected IDataSet createDataSet() throws DataSetException
  {
    final ISession session = getSession();
    try
    {
      final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
      return new ObjectArrayDataSet(md.getSQLKeywords());
    }
    catch (SQLException ex)
    {
      throw new DataSetException(ex);
    }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.