Package net.sourceforge.squirrel_sql.client.session

Examples of net.sourceforge.squirrel_sql.client.session.ISession

54
55
56
57
58
59
60
61
62
63
64
65
66
67
  /**
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BaseDataSetTab#createDataSet()
     */
    @Override
    protected IDataSet createDataSet() throws DataSetException {
        final ISession session = getSession();
        try
        {
            ISQLConnection con = session.getSQLConnection();
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(QUERY);
            ResultSetDataSet rsds = new ResultSetDataSet();
            rsds.setResultSet(rs, DialectType.POSTGRES);
            return rsds;
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    super(hint);
  }

  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());
        }       
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
    super(i18n.TITLE, i18n.HINT, true);
  }

  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
63
64
65
66
67
68
69
70
71
72
73
74
    super(i18n.TITLE, i18n.HINT, true);
  }

  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
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
      boolean result = true;
      String createPlanTableSQL =
          getCreatePlanTableSQL(getPlanTableName());
      Statement stmt = null;
      try {
          ISession session = getSession();
          ISQLConnection con = session.getSQLConnection();
          stmt = con.createStatement();
          stmt.execute(createPlanTableSQL);
          SchemaInfo schemaInfo = session.getSchemaInfo();
          schemaInfo.refershCacheForSimpleTableName("PLAN_TABLE");
      } catch (SQLException ex) {
          result = false;
          getSession().showErrorMessage(ex);
          s_log.error(ex);
View Full Code Here
221
222
223
224
225
226
227
228
229
230
231
          log.debug(msg);
        }
        continue;
      }

      ISession destSession = prov.getCopyDestSession();
      String destSchema = prov.getDestSelectedDatabaseObject().getSimpleName();
      String destCatalog = prov.getDestSelectedDatabaseObject().getCatalogName();
      if (tableHasForeignKey(destCatalog, destSchema, ti.getSimpleName(), fkInfo, prov))
      {
        if (log.isInfoEnabled())
View Full Code Here
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
1423
1424
1425
1426
1427
1428
  public static String getCreateTableSql(SessionInfoProvider prov, ITableInfo ti) throws SQLException,
        MappingException, UserCancelledOperationException
  {

    ISession sourceSession = prov.getCopySourceSession();
    String sourceSchema = prov.getSourceSelectedDatabaseObjects()[0].getSchemaName();
    String sourceCatalog = prov.getSourceSelectedDatabaseObjects()[0].getCatalogName();
    String sourceTableName = getQualifiedObjectName(
       sourceSession, sourceCatalog, sourceSchema, ti.getSimpleName(), DialectFactory.SOURCE_TYPE);
    ISession destSession = prov.getCopyDestSession();
    String destSchema = prov.getDestSelectedDatabaseObject().getSimpleName();
    String destCatalog = prov.getDestSelectedDatabaseObject().getCatalogName();
    String destinationTableName = getQualifiedObjectName(
       destSession, destCatalog, destSchema, ti.getSimpleName(), DialectFactory.DEST_TYPE);
    StringBuilder result = new StringBuilder("CREATE TABLE ");
View Full Code Here
1537
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
    if (notNullable)
    {
      result.append(" NOT NULL");
    } else
    {
      ISession destSession = prov.getCopyDestSession();
      HibernateDialect d = DialectFactory.getDialect(
         DialectFactory.DEST_TYPE, destSession.getApplication().getMainFrame(), destSession.getMetaData());
      String nullString = d.getNullColumnString().toUpperCase();
      result.append(nullString);
    }
    return result.toString();
  }
View Full Code Here
1617
1618
1619
1620
1621
1622
1623
1624
1625
1626
1627
        throws SQLException, UserCancelledOperationException
  {
    StringBuilder result = new StringBuilder("select ");
    result.append(columnList);
    result.append(" from ");
    ISession sourceSession = prov.getCopySourceSession();

    String tableName = getQualifiedObjectName(
       sourceSession, ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName(),
       DialectFactory.SOURCE_TYPE);
    result.append(tableName);
View Full Code Here
1641
1642
1643
1644
1645
1646
1647
1648
1649
1650
1651
  {
    StringBuilder result = new StringBuilder();
    result.append("insert into ");
    String destSchema = prov.getDestSelectedDatabaseObject().getSimpleName();
    String destCatalog = prov.getDestSelectedDatabaseObject().getCatalogName();
    ISession destSession = prov.getCopyDestSession();
    result.append(getQualifiedObjectName(
       destSession, destCatalog, destSchema, ti.getSimpleName(), DialectFactory.DEST_TYPE));
    result.append(" ( ");
    result.append(columnList);
    result.append(" ) values ( ");
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.client.session.ISession

  • net.sourceforge.squirrel_sql.client.action.ActionCollection
  • net.sourceforge.squirrel_sql.client.AppTestUtil
  • net.sourceforge.squirrel_sql.client.gui.mainframe.MainFrameToolBar$MySessionListener
  • net.sourceforge.squirrel_sql.client.gui.session.SessionPanel
  • net.sourceforge.squirrel_sql.client.gui.session.SessionPanel$CatalogsComboListener
  • net.sourceforge.squirrel_sql.client.gui.WindowManager
  • net.sourceforge.squirrel_sql.client.gui.WindowManager$SessionListener
  • net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab
    • 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.