if (colInfo.getSchemaName() != null) if (colInfo.getSchemaName() != null) pstmt.setString(2, colInfo.getSchemaName());
/** * @see net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand#generateSQLStatements() */ @Override protected String[] generateSQLStatements() throws UserCancelledOperationException { String[] result = new String[0]; if (_dialect.supportsAutoIncrement()) { DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(columnToModify.getCatalogName(), columnToModify.getSchemaName()); // TODO: Allow the user to specify the sequence name for dialects that don't natively support // auto-increment columns without using sequence/trigger combo. final StringBuilder sequenceName = new StringBuilder(); sequenceName.append(columnToModify.getTableName().toUpperCase()).append("_"); sequenceName.append(columnToModify.getColumnName().toUpperCase()).append("_SEQ"); result = _dialect.getAddAutoIncrementSQL(columnToModify, sequenceName.toString(), qualifier, _sqlPrefs); } else { _session.showMessage(s_stringMgr.getString("AddAutoIncrementCommand.unsupportedOperationMsg", _dialect.getDisplayName())); } return result; }
schemaTF.setPreferredSize(mediumField); schemaTF.setEditable(false); schemaTF.setText(dbInfo.getSchemaName()); pane.add(schemaTF, getFieldConstraints(c));
sourceSession, colInfo.getCatalogName(), colInfo.getSchemaName(), tableName, DialectFactory.SOURCE_TYPE);
public ExtendedColumnInfo(TableColumnInfo info, String simpleTableName) { _columnName = info.getColumnName(); _columnType = info.getTypeName(); _columnTypeID = info.getDataType(); _columnSize = info.getColumnSize(); _decimalDigits = info.getDecimalDigits(); _remarks = info.getRemarks(); if ("YES".equals(info.isNullable())) { _nullable = true; } else { _nullable = false; } _cat = info.getCatalogName(); _schem = info.getSchemaName(); _simpleTableName = simpleTableName; _qualifiedName = _cat + "." + _schem + "." + _simpleTableName + "." +_columnName; }
public ExtendedColumnInfo(TableColumnInfo info, String simpleTableName) { _columnName = info.getColumnName(); _columnType = info.getTypeName(); _columnTypeID = info.getDataType(); _columnSize = info.getColumnSize(); _decimalDigits = info.getDecimalDigits(); _remarks = info.getRemarks(); if ("YES".equals(info.isNullable())) { _nullable = true; } else { _nullable = false; } _cat = info.getCatalogName(); _schem = info.getSchemaName(); _simpleTableName = simpleTableName; _qualifiedName = _cat + "." + _schem + "." + _simpleTableName + "." +_columnName; }
/** * @see net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand#generateSQLStatements() */ @Override protected String[] generateSQLStatements() throws Exception { TableColumnInfo info = customDialog.getColumnInfo(); String[] result = null; DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(info.getCatalogName(), info.getSchemaName()); try { result = _dialect.getAddColumnSQL(info, qualifier, _sqlPrefs); } catch (HibernateException e1) { String dataType = customDialog.getSelectedTypeName(); JOptionPane.showMessageDialog(customDialog, s_stringMgr.getString("AbstractRefactoringCommand.unsupportedTypeMsg", _dialect.getDisplayName(), dataType), AbstractRefactoringCommand.i18n.UNSUPPORTED_TYPE_TITLE, JOptionPane.ERROR_MESSAGE); } catch (UnsupportedOperationException e2) { _session.showMessage(s_stringMgr.getString("AddColumnCommand.unsupportedOperationMsg", _dialect.getDisplayName())); } return result; }
s_log.debug("Schema: " + mc.getSchemaName()); mc.getSchemaName(), destinationTable, mc.getColumnName(),