Package net.sourceforge.squirrel_sql.fw.sql

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

58
59
60
61
62
63
64
65
66
67
68
69
70
71
  }

  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
       
        String sql = "SELECT CAST('" + doi.getSimpleName() + "' AS VARCHAR(31)) as generator_name, " +
            "gen_id(" + doi.getSimpleName() + ", 0) as current_value " +
            "from rdb$database";
       
        if (s_log.isDebugEnabled()) {
            s_log.debug("Preparing SQL: "+sql);
        }
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
     *         child nodes for the passed node.
     */
    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();

        PreparedStatement pstmt = conn.prepareStatement(SQL);
        try {
            ResultSet rs = pstmt.executeQuery();
            while (rs.next()) {
                IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName,
                        schemaName, rs.getString(1),
                        DatabaseObjectType.SEQUENCE, md);
                childNodes.add(new ObjectTreeNode(session, si));
            }
        } finally {
View Full Code Here
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
  }

  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("schema="+doi.getSchemaName());
            s_log.debug("trigname="+doi.getSimpleName());
        }
    ISQLConnection conn = session.getSQLConnection();
    PreparedStatement pstmt = conn.prepareStatement(SQL);
        pstmt.setString(1, doi.getSchemaName());
    pstmt.setString(2, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
49
50
51
52
53
54
55
56
57
   * @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
86
87
88
89
90
91
92
93
94
95
96
97
    ISession session = getSession();
        if (s_log.isDebugEnabled()) {
            s_log.debug("Preparing SQL: "+SQL);
        }       
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
    IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        if (s_log.isDebugEnabled()) {
            s_log.debug("setString param: "+doi.getSimpleName());
        }       
        pstmt.setString(1, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
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
   */
  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());


      String sql = SQL;
    if (isOS400) {
        sql = OS_400_SQL;
    }
    final PreparedStatement pstmt = conn.prepareStatement(sql);
        ResultSet rs = null;
    try
    {
      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.UDF, md);
               if(filterMatcher.matches(si.getSimpleName()))
               {
                  childNodes.add(new ObjectTreeNode(session, si));
               }
            }
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
  }

  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        String sql = getSQL();
        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);
    return pstmt;
  }
View Full Code Here
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
   */
  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();

    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      pstmt = conn.prepareStatement(SQL);
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        IDatabaseObjectInfo si = new DatabaseObjectInfo(
           catalogName, schemaName, rs.getString(1), DatabaseObjectType.DATATYPE, md);
        childNodes.add(new ObjectTreeNode(session, si));
      }
    } finally
    {
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(sql);
    return pstmt;
  }
   
    private String getSQL() {
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        StringBuffer result = new StringBuffer();
        result.append(SQL);
        result.append(doi.getSchemaName());
        result.append(".");
        result.append(doi.getSimpleName());
        return result.toString();
    }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
      pstmt = conn.prepareStatement(SQL);
      pstmt.setString(1, doi.getSimpleName());
      rs = pstmt.executeQuery();
      if (rs.next())
      {
        return new IndexInfo(
           rs.getString(1), rs.getString(2), rs.getInt(3), rs.getString(4), rs.getInt(5), rs.getInt(6),
           rs.getInt(7), rs.getInt(8), rs.getString(9), rs.getString(10));
      }
      String msg = s_stringMgr.getString("IndexInfoTab.err.noindex", doi.getSimpleName());
      throw new DataSetException(msg);
    } catch (SQLException ex)
    {
      throw new DataSetException(ex);
    } 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.