Package net.sourceforge.squirrel_sql.fw.sql

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

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
  }

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

    ISQLConnection conn = session.getSQLConnection();
        if (s_log.isDebugEnabled()) {
            s_log.debug("Running View Source SQL: "+SQL);
            s_log.debug("View Name="+doi.getSimpleName());
            s_log.debug("Schema Name="+doi.getSchemaName());
        }       
    PreparedStatement pstmt = conn.prepareStatement(SQL);
    pstmt.setString(1, doi.getSimpleName()); // view name
        pstmt.setString(2, doi.getSchemaName()); // schema name
    return pstmt;
  }
View Full Code Here
49
50
51
52
53
54
55
56
   * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues()
   */
  @Override
  protected String[] getBindValues()
  {
    final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    return new String[] { doi.getCatalogName(), doi.getSimpleName() };
  }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
  }

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

        if (s_log.isDebugEnabled()) {
            s_log.debug("Sequence details SQL: "+SQL);
            s_log.debug("Sequence schema: "+doi.getSchemaName());
            s_log.debug("Sequence 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
65
66
67
68
69
70
71
72
73
74
  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
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
99
100
101
   */
  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();
      ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());


      final PreparedStatement pstmt = conn.prepareStatement(SQL);
    try
    {
      pstmt.setString(1, schemaName);
      pstmt.setString(2, filterMatcher.getSqlLikeMatchString());
      ResultSet rs = pstmt.executeQuery();
      try
      {
        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));
               }
            }
      }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
 
  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 = ((ConstraintParentInfo)parentDbinfo).getTableInfo();
    final String schemaName = parentDbinfo.getSchemaName();
    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()) {
          DatabaseObjectInfo doi = new DatabaseObjectInfo(null,
                        schemaName,
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
    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();

    final PreparedStatement pstmt = conn.prepareStatement(isAdmin?SQL_ADMIN:SQL_USER);
    try
    {
      ResultSet rs = pstmt.executeQuery();
      try
      {
        while (rs.next())
        {
          IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, schemaName,
                        rs.getString(1), DatabaseObjectType.USER, md);
          childNodes.add(new ObjectTreeNode(session, doi));
        }
      }
      finally
View Full Code Here
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902
1903
1904
      return;
    }
    for (int colIdx = 0; colIdx < colInfoArr.length; colIdx++)
    {
      TableColumnInfo colInfo = colInfoArr[colIdx];
      IDatabaseObjectInfo selectedDestObj = prov.getDestSelectedDatabaseObject();
      String schema = selectedDestObj.getSimpleName();
      String catalog = selectedDestObj.getCatalogName();
      String tableName = getQualifiedObjectName(
         destSession, catalog, schema, TEST_TABLE_NAME, DialectFactory.DEST_TYPE);

      StringBuilder sql = new StringBuilder("CREATE TABLE ");
      sql.append(tableName);
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
            return;
        } else {
          // When the user pastes on a TABLE label which is located under a
          // schema/catalog, build the schema DatabaseObjectInfo.
          if (DatabaseObjectType.TABLE_TYPE_DBO.equals(dbObjs[0].getDatabaseObjectType())) {
            IDatabaseObjectInfo tableLabelInfo = dbObjs[0];
            ISQLConnection destCon = destSession.getSQLConnection();
            SQLDatabaseMetaData md = null;
            if (destCon != null) {
              md = destCon.getSQLMetaData();
            }
            IDatabaseObjectInfo schema =
              new DatabaseObjectInfo(null,
                           tableLabelInfo.getSchemaName(),
                           tableLabelInfo.getSchemaName(),
                           DatabaseObjectType.SCHEMA,
                           md);
            sessionInfoProv.setDestSelectedDatabaseObject(schema);
          } else {
            sessionInfoProv.setDestSelectedDatabaseObject(dbObjs[0]);
          }
           
        }
       
        try {
            IDatabaseObjectInfo info
                            = sessionInfoProv.getDestSelectedDatabaseObject();
            if (info == null || destSession == null) {
                return;
            }
            if (!checkSession(destSession, info)) {
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
   */
  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
    {
      if (s_log.isDebugEnabled()) {
        s_log.debug("createChildren: running SQL - "+SQL);
        s_log.debug("createChildren: with SYNONYM_NAME = "+filterMatcher.getSqlLikeMatchString());
        s_log.debug("createChildren: with schema = "+schemaName);
        s_log.debug("createChildren: with catalog = "+catalogName);
      }
     
      pstmt = conn.prepareStatement(SQL);
     
      pstmt.setString(1, filterMatcher.getSqlLikeMatchString());
      pstmt.setString(2, schemaName);
      pstmt.setString(3, catalogName);
     
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        IDatabaseObjectInfo si = new DatabaseObjectInfo(
           catalogName, schemaName, rs.getString(1), DatabaseObjectType.SYNONYM, md);

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

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

  • net.sourceforge.squirrel_sql.client.session.action.CopyObjectNameCommand
  • net.sourceforge.squirrel_sql.client.session.action.EditWhereColsAction
  • net.sourceforge.squirrel_sql.client.session.action.SQLFilterAction
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SchemaExpander
  • 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.ObjectTree$TreeLoader
  • net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab
  • net.sourceforge.squirrel_sql.plugins.mssql.gui.GenerateSqlDialog
    • Copyright © 2018 www.massapicom. 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.