Package net.sourceforge.squirrel_sql.fw.sql

Examples of net.sourceforge.squirrel_sql.fw.sql.ISQLConnection$IPropertyNames

90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
  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);
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
  }

  private IndexInfo createIndexInfo() throws DataSetException
  {
    final ISession session = getSession();
    final ISQLConnection conn = session.getSQLConnection();

    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(
View Full Code Here
53
54
55
56
57
58
59
60
61
62
    final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    if (s_log.isDebugEnabled()) {
      s_log.debug("Preparing trigger SQL statement: "+SQL);
      s_log.debug("trigger name = "+doi.getSimpleName());
    }
    ISQLConnection conn = session.getSQLConnection();
    PreparedStatement pstmt = conn.prepareStatement(SQL);
    pstmt.setString(1, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
    public List<ObjectTreeNode> createChildren(ISession session,
                                               ObjectTreeNode parentNode)
        throws SQLException
    {
        final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
        final ISQLConnection conn = session.getSQLConnection();
        final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();

        PreparedStatement pstmt = null;
       

        try
        {
            pstmt = conn.prepareStatement(ALL_INDICES_SQL);
            final ResultSet rs = pstmt.executeQuery();
            while (rs.next())
            {
                IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, null,
                                            rs.getString(1),
View Full Code Here
50
51
52
53
54
55
56
57
58
59
  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, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
  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, doi.getSimpleName());
    return pstmt;
  }
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
     * Performs the table copy operation.
     */
    private void _execute() {
        start = System.currentTimeMillis();
        boolean encounteredException = false;
        ISQLConnection destConn = destSession.getSQLConnection();
        if (!analyzeTables()) {
            return;
        }
        setupAutoCommit(destConn);
        IDatabaseObjectInfo[] sourceObjs = prov.getSourceSelectedDatabaseObjects();
View Full Code Here
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
            return;
        }
        if (!PreferencesManager.getPreferences().isCopyData()) {
            return;
        }
        ISQLConnection sourceConn = prov.getCopySourceSession().getSQLConnection();
        ISQLConnection destConn = prov.getCopyDestSession().getSQLConnection();
        SQLDatabaseMetaData sourceMetaData = sourceConn.getSQLMetaData();
        SQLDatabaseMetaData destMetaData = destConn.getSQLMetaData();
        try {
            String destSchema =
                prov.getDestSelectedDatabaseObject().getSimpleName();           
            ITableInfo destTableInfo =
                DBUtil.getTableInfo(prov.getCopyDestSession(),
                                    destSchema,
                                    sourceTableInfo.getSimpleName());
           
            TableColumnInfo[] sourceInfos = sourceMetaData.getColumnInfo(sourceTableInfo);
            TableColumnInfo[] destInfos = destMetaData.getColumnInfo(destTableInfo);
           
            destInfos = sort(sourceInfos,
                             destInfos,
                             sourceTableInfo.getQualifiedName(),
                             destTableInfo.getQualifiedName());
           
            String sourceColList = DBUtil.getColumnList(sourceInfos);
            String destColList = DBUtil.getColumnList(destInfos);
           
            String selectSQL = DBUtil.getSelectQuery(prov,
                                                     sourceColList,
                                                     sourceTableInfo);
            String insertSQL = DBUtil.getInsertSQL(prov, destColList,
                                                   sourceTableInfo,
                                                   destInfos.length);
            insertStmt = destConn.prepareStatement(insertSQL);
           
            int count = 1;
            int commitCount = prefs.getCommitCount();
            int columnCount = destInfos.length;
            String[] bindVarVals = new String[columnCount];
View Full Code Here
761
762
763
764
765
766
767
768
769
770
771
    {
        if (!prefs.isCopyForeignKeys()
            || DialectFactory.isAxion(prov.getCopySourceSession().getMetaData())) {
            return;
        }
        ISQLConnection destConn = prov.getCopyDestSession().getSQLConnection();
        for (int i = 0; i < dbObjs.length; i++) {
            ITableInfo ti = (ITableInfo) dbObjs[i];
            Set<String> fkStmts =
                DBUtil.getForeignKeySQL(prov, ti, selectedTableInfos);
            Iterator<String> it = fkStmts.iterator();
View Full Code Here
786
787
788
789
790
791
792
793
794
795
796
        throws SQLException, UserCancelledOperationException, MappingException
    {
        if (cancelled) {
            return;
        }
        ISQLConnection destCon = prov.getCopyDestSession().getSQLConnection();
        String createTableSql = DBUtil.getCreateTableSql(prov, ti);
        DBUtil.executeUpdate(destCon, createTableSql, true);
       
        if (prefs.isCommitAfterTableDefs() && !currentAutoCommitValue) {
            commitConnection(destCon);
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.fw.sql.ISQLConnection$IPropertyNames

  • net.sourceforge.squirrel_sql.client.AppTestUtil
  • net.sourceforge.squirrel_sql.client.gui.session.CatalogsPanel
  • net.sourceforge.squirrel_sql.client.session.action.DumpSessionCommand
  • net.sourceforge.squirrel_sql.client.session.DataSetUpdateableTableModelImpl
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.IndexParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SequenceParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableTypeExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TriggerParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.UDTTypeExpander
    • 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.