Package net.sourceforge.squirrel_sql.fw.sql

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

103
104
105
106
107
108
109
110
111
112
113
                    buf.append(line1.trim() + " ");
                    buf.append(line2.trim() + " ");
                }
                String source = "";
                if (buf.length() == 0 && sourceType == TABLE_TYPE) {
                    ISQLDatabaseMetaData md = session.getMetaData();
                    // TODO: Need to define a better approach to getting dialects.
                    // That is, we don't really want to ever prompt the user in this
                    // case.  It's always Oracle.  Yet, we may have a new OracleDialect
                    // at some point.
                    HibernateDialect dialect = DialectFactory.getDialect("Oracle");
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
  private String getRegularTableSelectSql(ITableInfo ti)
  {
    StringBuilder tmp = new StringBuilder();
    tmp.append("select '");

    ISQLDatabaseMetaData md = getSession().getMetaData();
    try
    {
      HibernateDialect dialect = DialectFactory.getDialect(md);
      List<ITableInfo> tableList = asList(new ITableInfo[]
        { ti });
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
  protected String[] generateSQLStatements() throws UserCancelledOperationException, SQLException
  {
    ArrayList<String> results = new ArrayList<String>();


    ISQLDatabaseMetaData md = _session.getMetaData();

    String catalog = _info[0].getCatalogName();
    String schema = _info[0].getSchemaName();
    DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(catalog, schema);
    String destinationTable = _info[0].getSimpleName();
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
   */
  public void execute()
  {
    try
    {
      ISQLDatabaseMetaData md = _session.getMetaData();
      _dialect =
        DialectFactory.getDialect(DialectFactory.DEST_TYPE, _session.getApplication().getMainFrame(), md);
      if (isRefactoringSupportedForDialect(_dialect))
      {
        onExecute();
View Full Code Here
463
464
465
466
467
468
469
470
471
472
473
   *           the Timestamp to get the nanosecond value from
   * @return a string representing the nanosecond value.
   */
  private String getNanos(Timestamp ts) throws SQLException
  {
    ISQLDatabaseMetaData md = _session.getMetaData();
    HibernateDialect dialect = DialectFactory.getDialect(md);

    boolean dialectSupportsSubSecondTimestamps = getTimestampFlag();
    if (!dialectSupportsSubSecondTimestamps
        || dialect.getTimestampMaximumFractionalDigits() == 0) {
View Full Code Here
491
492
493
494
495
496
497
498
499
500
501
    * @return true if supported; false otherwise.
    * @throws SQLException
    */
   private boolean getTimestampFlag() throws SQLException {
     if (dialectSupportsSubSecondTimestamps == null) {
       ISQLDatabaseMetaData md = _session.getMetaData();
       HibernateDialect dialect = DialectFactory.getDialect(md);
       dialectSupportsSubSecondTimestamps = dialect.supportsSubSecondTimestamps();
     }
     return dialectSupportsSubSecondTimestamps;
   }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
  protected String[] generateSQLStatements() throws UserCancelledOperationException
  {
    ArrayList<String> results = new ArrayList<String>();
    ArrayList<String> updateResults = new ArrayList<String>();

    ISQLDatabaseMetaData md = _session.getMetaData();

    String joinString = customDialog.getJoinString();
    String column1 = customDialog.getFirstColumn();
    String column2 = customDialog.getSecondColumn();
    String catalog = _info[0].getCatalogName();
View Full Code Here
796
797
798
799
800
801
802
803
804
805
806
807
808
            commitConnection(destCon);
        }
       
        if (prefs.isCopyIndexDefs()) {
            Collection<String> indices = null;
            ISQLDatabaseMetaData sqlmd = sourceSession.getMetaData();
            if (prefs.isCopyPrimaryKeys()) {
                PrimaryKeyInfo[] pkList = sqlmd.getPrimaryKey(ti);
                List<PrimaryKeyInfo> pkList2 = Arrays.asList(pkList);
                indices = DialectUtils.createIndexes(ti, sqlmd, pkList2, new CreateScriptPreferences());
            } else {
                indices = DialectUtils.createIndexes(ti, sqlmd, null, new CreateScriptPreferences());
            }
View Full Code Here
TOP

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

  • net.sourceforge.squirrel_sql.client.AppTestUtil
  • net.sourceforge.squirrel_sql.client.plugin.AbstractSessionPluginTest
  • net.sourceforge.squirrel_sql.client.session.DataSetUpdateableTableModelImpl
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.ContentsTab
  • net.sourceforge.squirrel_sql.fw.dialects.DialectExternalTest
  • net.sourceforge.squirrel_sql.fw.dialects.DialectUtilsTest
  • net.sourceforge.squirrel_sql.fw.FwTestUtil
  • net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab
  • net.sourceforge.squirrel_sql.plugins.dbcopy.ColTypeMapperTest
  • net.sourceforge.squirrel_sql.plugins.dbcopy.CopyExecutor
    • 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.