Package net.sourceforge.squirrel_sql.fw.dialects

Examples of net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect

574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
   
    private class DialectTypeListListener implements ItemListener {
       
        public void itemStateChanged(ItemEvent e) {
            String dbName = (String)dialectList.getSelectedItem();
            HibernateDialect dialect = DialectFactory.getDialect(dbName);
            if (!dialect.supportsColumnComment()) {
                commentTextArea.setEditable(false);
                //i18n[ColumnDetailsDialog.columnCommentLabel={0} does not
                //support column comments]
                String noColumnSupportMsg =
                    s_stringMgr.getString(
                            "ColumnDetailsDialog.columnCommentToolTip",
                            dbName);
                commentTextArea.setToolTipText(noColumnSupportMsg);
            } else {
                commentTextArea.setEditable(true);
                commentTextArea.setToolTipText(null);
            }
            if (_mode == MODIFY_MODE) {
                if (!dialect.supportsAlterColumnNull()) {
                    nullableCheckBox.setEnabled(false);
                    //i18n[ColumnDetailsDialog.columnNullLabel={0} does not
                    //support altering column nullability]
                    String noColumnSupportMsg =
                        s_stringMgr.getString("ColumnDetailsDialog.columnNullToolTip",
                                              dbName);
                    nullableCheckBox.setToolTipText(noColumnSupportMsg);
                } else {
                    nullableCheckBox.setEnabled(true);
                    nullableCheckBox.setToolTipText(null);
                }
                if (!dialect.supportsRenameColumn()) {
                    //i18n[ColumnDetailsDialog.columnNameTootTip={0} does not
                    //support altering column name]
                    String noColNameChange =
                        s_stringMgr.getString("ColumnDetailsDialog.columnNameTootTip",
                                              dbName);
                    columnNameTextField.setEditable(false);
                    columnNameTextField.setToolTipText(noColNameChange);
                } else {
                    columnNameTextField.setEditable(true);
                    columnNameTextField.setToolTipText(null);                   
                }
                if (!dialect.supportsAlterColumnType()) {
                    //i18n[ColumnDetailsDialog.columnTypeTootTip={0} does not
                    //support altering column type]    
                    String noColTypeChange =
                        s_stringMgr.getString("ColumnDetailsDialog.columnTypeTootTip",
                                              dbName);
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
            csprefs.setQualifyTableNames(prefs.isQualifyTableNames());
            csprefs.setUseDoubleQuotes(prefs.isUseDoubleQuotes());

            List<ITableInfo> tables = convertArrayToList(dbObjs);
           
            HibernateDialect dialect =
                DialectFactory.getDialect(DialectFactory.SOURCE_TYPE,
                                          _session.getApplication().getMainFrame(),
                                          md);
            List<String> sqls =
                dialect.getCreateTableSQL(tables, md, csprefs, isJdbcOdbc);
            String sep = _session.getQueryTokenizer().getSQLStatementSeparator();
           
            for (String sql : sqls) {
                result.append(sql);
                result.append("\n");
View Full Code Here
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
    int colJdbcType = colInfo.getDataType();
    if (colJdbcType == java.sql.Types.OTHER)
    {
      try
      {
        HibernateDialect dialect = DialectFactory.getDialect(session.getMetaData());
        String typeName = colInfo.getTypeName().toUpperCase();
        int parenIndex = typeName.indexOf("(");
        if (parenIndex != -1)
        {
          typeName = typeName.substring(0, parenIndex);
        }
        colJdbcType = dialect.getJavaTypeForNativeType(colInfo.getTypeName());
      } catch (Exception e)
      {
        log.error("replaceOtherDataType: unexpected exception - " + e.getMessage());
      }
    }
View Full Code Here
1538
1539
1540
1541
1542
1543
1544
1545
1546
1547
1548
1549
    {
      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
1971
1972
1973
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
1993
   */
  public static String getMaxColumnLengthSQL(ISession sourceSession, TableColumnInfo colInfo,
        String tableName, boolean tableNameIsQualified) throws UserCancelledOperationException
  {
    StringBuilder result = new StringBuilder();
    HibernateDialect dialect = DialectFactory.getDialect(
       DialectFactory.SOURCE_TYPE, sourceSession.getApplication().getMainFrame(),
       sourceSession.getMetaData());
    String lengthFunction = dialect.getLengthFunction(colInfo.getDataType());
    if (lengthFunction == null)
    {
      log.error("Length function is null for dialect=" + dialect.getClass().getName() + ". Using 'length'");
      lengthFunction = "length";
    }
    String maxFunction = dialect.getMaxFunction();
    if (maxFunction == null)
    {
      log.error("Max function is null for dialect=" + dialect.getClass().getName() + ". Using 'max'");
      maxFunction = "max";
    }
    result.append("select ");
    result.append(maxFunction);
    result.append("(");
View Full Code Here
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
        String typeName = dbObj.getDatabaseObjectType().getName();
       
        log.debug("PasteTableAction.checkSession: dbObj type="+typeName+
                  " name="+dbObj.getSimpleName());

        HibernateDialect d =
            DialectFactory.getDialect(DialectFactory.DEST_TYPE,
                                      session.getApplication().getMainFrame(),
                                      session.getMetaData());
        if (!d.canPasteTo(dbObj)) {
            //i18n[PasteTableAction.error.destdbobj=The destination database
            //doesn't support copying tables into '{0}' objects.\n Please
            //select a schema to paste into.]
            String errmsg =
                s_stringMgr.getString("PasteTableAction.error.destdbobj",
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
                }
            }
        }
        String result = null;
        JFrame mainFrame = destSession.getApplication().getMainFrame();
        HibernateDialect destDialect =
            DialectFactory.getDialect(DialectFactory.DEST_TYPE,
                                      mainFrame,
                                      destSession.getMetaData());

        if (s_log.isDebugEnabled()) {
            s_log.debug(
                    "ColTypeMapper.mapColType: using dialect type: "+
                    destDialect.getClass().getName()+" to find name for column "+
                    colInfo.getColumnName()+" in table "+destTableName+
                    " with type id="+colJdbcType+" ("+
                    JDBCTypeMapper.getJdbcTypeName(colJdbcType)+")");
        }
        if (destDialect != null) {
            HibernateDialect sourceDialect =
                DialectFactory.getDialect(DialectFactory.SOURCE_TYPE,
                                          mainFrame,
                                          sourceSession.getMetaData());
           
            int precision = sourceDialect.getPrecisionDigits(size, colJdbcType);
           
            if (precision > destDialect.getMaxPrecision(colJdbcType)) {
                precision = destDialect.getMaxPrecision(colJdbcType);
            }
            int scale = colInfo.getDecimalDigits();
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
244
245
246
   
    private static int getColumnLength(ISession sourceSession,
                                       TableColumnInfo colInfo)
        throws UserCancelledOperationException
    {
        HibernateDialect dialect =
            DialectFactory.getDialect(DialectFactory.SOURCE_TYPE,
                                      sourceSession.getApplication().getMainFrame(),
                                      sourceSession.getMetaData());
        int length = colInfo.getColumnSize();
        int type = colInfo.getDataType();
        length = dialect.getColumnLength(length, type);
        return length;
    }
View Full Code Here
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
   */
  public static String getMaxColumnLengthSQL(ISession sourceSession, TableColumnInfo colInfo,
    String tableName, boolean tableNameIsQualified) throws UserCancelledOperationException
  {
    StringBuilder result = new StringBuilder();
    HibernateDialect dialect =
      DialectFactory.getDialect(DialectFactory.SOURCE_TYPE, sourceSession.getApplication().getMainFrame(),
        sourceSession.getMetaData());
    String lengthFunction = dialect.getLengthFunction(colInfo.getDataType());
    if (lengthFunction == null)
    {
      log.error("Length function is null for dialect=" + dialect.getClass().getName() + ". Using 'length'");
      lengthFunction = "length";
    }
    String maxFunction = dialect.getMaxFunction();
    if (maxFunction == null)
    {
      log.error("Max function is null for dialect=" + dialect.getClass().getName() + ". Using 'max'");
      maxFunction = "max";
    }
    result.append("select ");
    result.append(maxFunction);
    result.append("(");
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
                    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");
                   
                    // TODO: How to let the user customize this??
                    CreateScriptPreferences prefs = new CreateScriptPreferences();
                   
                    ITableInfo[] tabs = new ITableInfo[] { (ITableInfo)getDatabaseObjectInfo() };
                    List<ITableInfo> tables = Arrays.asList(tabs);
                    // Handle table source
                    List<String> sqls = dialect.getCreateTableSQL(tables, md, prefs, false);
                    String sep = session.getQueryTokenizer().getSQLStatementSeparator();
                    for (String sql : sqls) {
                        buf.append(sql);
                        buf.append(sep);
                        buf.append("\n");
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect

  • net.sourceforge.squirrel_sql.client.gui.db.ColumnDetailDialog$DialectTypeListListener
  • net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab
  • net.sourceforge.squirrel_sql.plugins.dbcopy.actions.PasteTableAction
  • net.sourceforge.squirrel_sql.plugins.dbcopy.ColTypeMapper
  • net.sourceforge.squirrel_sql.plugins.dbcopy.util.DBUtil
  • net.sourceforge.squirrel_sql.plugins.dbdiff.util.DBUtil
  • net.sourceforge.squirrel_sql.plugins.oracle.tab.OracleSourceTab$OracleSourcePanel
  • net.sourceforge.squirrel_sql.plugins.refactoring.tab.SupportedRefactoringsTab
  • net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateDataScriptCommand
  • net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateTableScriptCommand
    • 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.