Package net.sourceforge.squirrel_sql.fw.sql

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

67
68
69
70
71
72
73
74
75
  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(BIGVIEW_SQL);
    IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    pstmt.setString(1, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
  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
114
115
116
117
118
119
120
121
122
123
124
125
126
127
                        fw.write(MssqlIntrospector.generateUsersAndRolesScript(_session.getSQLConnection().getCatalog(),_session.getSQLConnection()));
                }
               
                ArrayList<IDatabaseObjectInfo> objs = dlog.getSelectedItems();
                for (int i = 0; i < objs.size(); i++) {
                    IDatabaseObjectInfo oi = objs.get(i);
                   
                    if (!dlog.getOneFile())
                        fw = new FileWriter(fc.getSelectedFile() + java.io.File.separator + MssqlIntrospector.getFixedVersionedObjectName(oi.getSimpleName()) + ".txt",false);
                   
                    if (dlog.getGenerateDrop())
                        fw.write(MssqlIntrospector.generateDropScript(oi));
                   
                    if (dlog.getGenerateCreate()) {
View Full Code Here
60
61
62
63
64
65
66
67
68
69
  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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
  }

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

    ISQLConnection conn = session.getSQLConnection();
    PreparedStatement pstmt = conn.prepareStatement(SQL);
    pstmt.setString(1, ObjectSourceTab.this._columnData);
    pstmt.setString(2, doi.getSchemaName());
    pstmt.setString(3, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
53
54
55
56
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
            if (_dbObjs.length > 0) {
                Connection conn = _session.getSQLConnection().getConnection();
                final StringBuffer buf = new StringBuffer();

                for (int i = 0; i < _dbObjs.length; i++) {
                    final IDatabaseObjectInfo oi = _dbObjs[i];
                   
                    if (!conn.getCatalog().equals(oi.getCatalogName()))
                        conn.setCatalog(oi.getCatalogName());
                   
                    if (oi.getSimpleName().endsWith(";0")) {
                        // this is a UDF, not a stored procedure.
                        buf.append("/* WILL NOT EXECUTE USER-DEFINED FUNCTION ");
                        buf.append(oi.getQualifiedName());
                        buf.append(" */\n\n");
                        continue;
                    }
                   
                    /* call sp_help on the stored procedure, then look at the second ResultSet for
                     * the parameter information. */

                    String useThisName = MssqlIntrospector.getFixedVersionedObjectName(oi.getSimpleName());
                    CallableStatement stmt = conn.prepareCall("{ call sp_help (?) }");
                    stmt.setString(1, useThisName);
                    ResultSet rs;
                   
                    StringBuffer procExec = new StringBuffer();
                    procExec.append("DECLARE @rc int\nEXECUTE @rc = [");
                    procExec.append(oi.getCatalogName());
                    procExec.append("].[");
                    procExec.append(oi.getSchemaName());
                    procExec.append("].[");
                    procExec.append(useThisName);
                    procExec.append("] ");

                    if (!stmt.execute())
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
59
60
    {
      final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator();
      final StringBuffer buf = new StringBuffer();
      for (int i = 0; i < _dbs.length; i++)
      {
        final IDatabaseObjectInfo ti = _dbs[i];
        buf.append("DBCC SHRINKDATABASE(");
                buf.append(ti.getSimpleName());
                buf.append(",TRUNCATEONLY)");
        buf.append("\n");
                buf.append(sqlSep);
                buf.append("\n");
      }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
  }

  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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
  }

  protected PreparedStatement createStatement() throws SQLException
  {
    ISession session = getSession();
        IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        if (s_log.isDebugEnabled()) {
            s_log.debug("Preparing SQL: "+SQL);
        }
    PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
        if (s_log.isDebugEnabled()) {
            s_log.debug("setString param: "+doi.getSimpleName());
        }               
        pstmt.setString(1, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
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
   */
  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.SEQUENCE, md);

               if(filterMatcher.matches(si.getSimpleName()))
               {
                  childNodes.add(new ObjectTreeNode(session, si));
               }
            }
    }
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.