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

Package net.sourceforge.squirrel_sql.fw.sql

Examples of net.sourceforge.squirrel_sql.fw.sql.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

  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    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();


    // Add package node to contain standalone procedures.
    IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(null, schemaName,
                        "", IObjectTypes.PACKAGE, md);

View Full Code Here

    customDialog.addShowSQLListener(new ShowSQLListener(i18n.SHOWSQL_DIALOG_TITLE, customDialog));
    customDialog.setLocationRelativeTo(_session.getApplication().getMainFrame());
    customDialog.setMultiSelection();
    customDialog.setTableName(ti.getQualifiedName());


    SQLDatabaseMetaData md = _session.getSQLConnection().getSQLMetaData();
    PrimaryKeyInfo[] infos = md.getPrimaryKey(ti);
    String pkName = infos[0].getSimpleName();
    customDialog.setPrimaryKeyName(pkName);
    customDialog.setVisible(true);
  }

View Full Code Here

  private List<ObjectTreeNode> createNodes(ISession session, String catalogName,
                      String schemaName)
    throws SQLException
  {
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = conn.getSQLMetaData();
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
      ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());


      // Add node for each object.
    PreparedStatement pstmt = conn.prepareStatement(SQL);

View Full Code Here

    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 catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();
      final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());


        String sql = SQL;

View Full Code Here

            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 catalogName = parentDbinfo.getCatalogName();
        final String schemaName = parentDbinfo.getSchemaName();


        PreparedStatement pstmt = conn.prepareStatement(SQL);

View Full Code Here

    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 catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();
      final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());

View Full Code Here

        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 catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();


    PreparedStatement pstmt = null;
    ResultSet rs = null;

View Full Code Here

                                               ObjectTreeNode parentNode)
        throws SQLException
    {
        final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
        final ISQLConnection conn = session.getSQLConnection();
        final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();


        PreparedStatement pstmt = null;
        


        try

View Full Code Here

   */
  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,

View Full Code Here

     *          nodes for the passed node.
     */
    public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    {
        final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
        final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();


        final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
        final String catalogName = parentDbinfo.getCatalogName();
        final String schemaName = parentDbinfo.getSimpleName();
        ObjectTreeNode node;

View Full Code Here

0 1 2 3 4 5 6 7

TOP

Related Classes of net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData

net.sourceforge.squirrel_sql.client.session.action.DeleteTablesCommand$DeleteExecuter

net.sourceforge.squirrel_sql.client.session.action.DumpSessionCommand

net.sourceforge.squirrel_sql.client.session.DataSetUpdateableTableModelImpl

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.IndexParentExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SchemaExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SequenceParentExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableWithChildNodesExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TriggerParentExpander

net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTreePanel

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.