Examples of IDatabaseObjectInfo

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

67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
        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());

    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      pstmt = conn.prepareStatement(SQL);
      pstmt.setString(1, schemaName);
      pstmt.setString(2, filterMatcher.getSqlLikeMatchString());
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        IDatabaseObjectInfo si = new DatabaseObjectInfo(
           catalogName, schemaName, rs.getString(1), DatabaseObjectType.SEQUENCE, md);

        if (filterMatcher.matches(si.getSimpleName()))
        {
          childNodes.add(new ObjectTreeNode(session, si));
        }
      }
    } finally
View Full Code Here

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

90
91
92
93
94
95
96
97
98
99
  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
    IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    pstmt.setString(1, doi.getSchemaName());
    pstmt.setString(2, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here

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

70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
  }

  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        if (s_log.isDebugEnabled()) {
            s_log.debug("Trigger details SQL: "+SQL);
            s_log.debug("Trigger schema: "+doi.getSchemaName());
            s_log.debug("Trigger name: "+doi.getSimpleName());
        }
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
        pstmt.setString(1, doi.getSchemaName());
    pstmt.setString(2, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here

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

67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
    throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final String schemaName = parentDbinfo.getSchemaName();

    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      pstmt = conn.prepareStatement(SQL);
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        // There is a reason that we don't want to use DatabaseObjectType.SESSION here.  The "session"
        // nodes that this expander is creating should not be confused with the SQuirreL session.  These
        // session nodes are Oracle sessions that an administrator has the privileges to see.  So we
        // must not use DatabaseObjectType.SESSION, or else these nodes get expanded with the database
        // DefaultdatabasExpander.
        IDatabaseObjectInfo doi =
          new DatabaseObjectInfo(null, schemaName, rs.getString(1), IObjectTypes.SESSION, md);
        childNodes.add(new ObjectTreeNode(session, doi));
      }
    }
    finally
View Full Code Here

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

57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
   *      nodes for the passed node.
   */
  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 dbinfo = new DatabaseObjectInfo(catalogName,
                      schemaName, "PACKAGE",
                      IObjectTypes.PACKAGE_PARENT, md);
    ObjectTreeNode child = new ObjectTreeNode(session, dbinfo);
    child.addExpander(new PackageParentExpander());
    childNodes.add(child);

    ObjectType objType;
    objType = new ObjectType(IObjectTypes.CONSUMER_GROUP_PARENT, "CONSUMER GROUP",
                    IObjectTypes.CONSUMER_GROUP);
    childNodes.add(createObjectTypeNode(session, catalogName, schemaName,
                      md, objType));

    objType = new ObjectType(IObjectTypes.FUNCTION_PARENT, "FUNCTION",
                  DatabaseObjectType.FUNCTION);
    childNodes.add(createObjectTypeNode(session, catalogName, schemaName,
                      md, objType));

    objType = new ObjectType(IObjectTypes.INDEX_PARENT, "INDEX", DatabaseObjectType.INDEX);
    childNodes.add(createObjectTypeNode(session, catalogName, schemaName,
                      md, objType));

    objType = new ObjectType(IObjectTypes.LOB_PARENT, "LOB", IObjectTypes.LOB);
    childNodes.add(createObjectTypeNode(session, catalogName, schemaName,
                      md, objType));

    IDatabaseObjectInfo seqInfo = new DatabaseObjectInfo(catalogName,
                    schemaName, "SEQUENCE",
                    IObjectTypes.SEQUENCE_PARENT, md);
    ObjectTreeNode node = new ObjectTreeNode(session, seqInfo);
    node.addExpander(new SequenceParentExpander());
    childNodes.add(node);
View Full Code Here

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

106
107
108
109
110
111
112
113
114
115
116
  private ObjectTreeNode createObjectTypeNode(ISession session,
                    String catalogName, String schemaName,
                    SQLDatabaseMetaData md, ObjectType objType)
  {
    IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(catalogName,
                    schemaName, objType._objectTypeColumnData,
                    objType._dboType, md);
    ObjectTreeNode node = new ObjectTreeNode(session, dbinfo);
    node.addExpander(new ObjectTypeExpander(objType));
    return node;
View Full Code Here

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

86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
  }

  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        if (s_log.isDebugEnabled()) {
            s_log.debug("Trigger details SQL: "+SQL);
            s_log.debug("Trigger name: "+doi.getSimpleName());
            s_log.debug("Trigger schema: "+doi.getSchemaName());
        }
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
    pstmt.setString(1, doi.getSimpleName());
        pstmt.setString(2, doi.getSchemaName());
    return pstmt;
  }
View Full Code Here

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

64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    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 IDatabaseObjectInfo tableInfo = ((TriggerParentInfo)parentDbinfo).getTableInfo();
    final PreparedStatement pstmt = conn.prepareStatement(SQL);
    try
    {
      pstmt.setString(1, tableInfo.getSchemaName());
      pstmt.setString(2, tableInfo.getSimpleName());
      ResultSet rs = pstmt.executeQuery();
      try
      {
        while (rs.next())
        {
View Full Code Here

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

75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
  }

  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        if (s_log.isDebugEnabled()) {
            s_log.debug("Trigger details SQL: "+SQL);
            s_log.debug("Trigger catalog: "+doi.getCatalogName());
            s_log.debug("Trigger name: "+doi.getSimpleName());
        }
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
    pstmt.setString(1, doi.getCatalogName());
        pstmt.setString(2, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here

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

63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
  }

  protected PreparedStatement createStatement() throws SQLException
  {
    final ISession session = getSession();
    final IDatabaseObjectInfo doi = getDatabaseObjectInfo();

    if (s_log.isDebugEnabled())
    {
      s_log.debug("Running SQL: " + SQL);
      s_log.debug("Trigger Name=" + doi.getSimpleName());
      s_log.debug("Schema Name=" + doi.getSchemaName());
    }
    ISQLConnection conn = session.getSQLConnection();
    PreparedStatement pstmt = conn.prepareStatement(SQL);
    pstmt.setString(1, doi.getSimpleName());
    pstmt.setString(2, doi.getSchemaName());
    return pstmt;
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.