package net.sourceforge.squirrel_sql.client.session.properties;
/*
* Copyright (C) 2001-2003 Colin Bell
* colbell@users.sourceforge.net
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
import java.awt.Font;
import java.beans.PropertyChangeListener;
import java.io.Serializable;
import javax.swing.JSplitPane;
import javax.swing.SwingConstants;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetViewerEditableTablePanel;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetViewerTablePanel;
import net.sourceforge.squirrel_sql.fw.datasetviewer.DataSetViewerTextPanel;
import net.sourceforge.squirrel_sql.fw.gui.FontInfo;
import net.sourceforge.squirrel_sql.fw.util.ISessionProperties;
import net.sourceforge.squirrel_sql.fw.util.PropertyChangeReporter;
/**
* This class represents the settings for a session.
*
* @author <A HREF="mailto:colbell@users.sourceforge.net">Colin Bell</A>
*/
public class SessionProperties implements Cloneable, Serializable, ISessionProperties
{
public interface IDataSetDestinations
{
String TEXT = DataSetViewerTextPanel.class.getName();
String READ_ONLY_TABLE = DataSetViewerTablePanel.class.getName();
String EDITABLE_TABLE = DataSetViewerEditableTablePanel.class.getName();
}
public interface IPropertyNames
{
String SQL_RESULT_TAB_LIMIT = "sqlResultTabLimit";
String ABORT_ON_ERROR = "abortOnError";
String SHOW_SQL_ERRORS_IN_TAB = "showSQLErrorsInTab";
String WRITE_SQL_ERRORS_TO_LOG = "writeSQLErrorsToLog";
String LOAD_COLUMNS_IN_BACKGROUND = "loadColumnsInBackground";
String AUTO_COMMIT = "autoCommit";
String CATALOG_FILTER_INCLUDE = "catalogFilterInclude";
String SCHEMA_FILTER_INCLUDE = "schemaFilterInclude";
String OBJECT_FILTER_INCLUDE = "objectFilterInclude";
String CATALOG_FILTER_EXCLUDE = "catalogFilterExclude";
String SCHEMA_FILTER_EXCLUDE = "schemaFilterExclude";
String OBJECT_FILTER_EXCLUDE = "objectFilterExclude";
String COMMIT_ON_CLOSING_CONNECTION = "commitOnClosingConnection";
String CONTENTS_LIMIT_ROWS = "contentsLimitRows";
String CONTENTS_NBR_ROWS_TO_SHOW = "contentsNbrOfRowsToShow";
String FONT_INFO = "fontInfo";
String LARGE_RESULT_SET_OBJECT_INFO = "largeResultSetObjectInfo";
String LIMIT_SQL_ENTRY_HISTORY_SIZE = "limitSqlEntryHistorySize";
String LOAD_SCHEMAS_CATALOGS = "loadCatalogsSchemas";
String MAIN_TAB_PLACEMENT = "mainTabPlacement";
String SQL_PANEL_ORIENTATION = "sqlPanelOrientation";
String META_DATA_OUTPUT_CLASS_NAME = "metaDataOutputClassName";
String OBJECT_TAB_PLACEMENT = "objectTabPlacement";
String SQL_ENTRY_HISTORY_SIZE = "sqlEntryHistorySize";
String SHOW_RESULTS_META_DATA = "showResultsMetaData";
String SHOW_ROW_COUNT = "showRowCount";
String SHOW_TOOL_BAR = "showToolBar";
String SQL_SHARE_HISTORY = "sqlShareHistory";
String SQL_EXECUTION_TAB_PLACEMENT = "sqlExecutionTabPlacement";
String SQL_RESULTS_TAB_PLACEMENT = "sqlResultsTabPlacement";
String SQL_LIMIT_ROWS = "sqlLimitRows";
String SQL_NBR_ROWS_TO_SHOW = "sqlNbrOfRowsToShow";
String SQL_READ_ON = "sqlReadOn";
String SQL_READ_ON_BLOCK_SIZE = "sqlReadOnBlockSize";
String SQL_RESULTS_OUTPUT_CLASS_NAME = "sqlResultsOutputClassName";
String SQL_START_OF_LINE_COMMENT = "sqlStartOfLineComment";
String SQL_STATEMENT_SEPARATOR_STRING = "sqlStatementSeparatorString";
String TABLE_CONTENTS_OUTPUT_CLASS_NAME = "tableContentsOutputClassName";
String KEEP_TABLE_LAYOUT_ON_RERUN = "keepTableLayoutOnRerun";
String LIMIT_SQL_RESULT_TABS = "limitSqlResultTabs";
String REMOVE_MULTI_LINE_COMMENT = "removeMultiLineComment";
String SQL_USE_FETCH_SIZE = "sqlUseFetchSize";
String SQL_FETCH_SIZE = "sqlFetchSize";
}
private static final FontInfo DEFAULT_FONT_INFO =
new FontInfo(new Font("Monospaced", 0, 12));
/** Object to handle property change events. */
private transient PropertyChangeReporter _propChgReporter;
private boolean _autoCommit = true;
private int _contentsNbrRowsToShow = 100;
private int _sqlNbrRowsToShow = 100;
private int _sqlReadOnBlockSize = 100;
/**
* If <CODE>true</CODE> then issue a commit when closing a connection
* else issue a rollback. This property is only valid if the
* connection is not in auto-commit mode.
*/
private boolean _commitOnClosingConnection = false;
private boolean _contentsLimitRows = true;
private boolean _sqlLimitRows = true;
private boolean _sqlReadOn = false;
/**
* <CODE>true</CODE> if schemas and catalogs should be loaded in the object
* tree.
*/
private boolean _loadSchemasCatalogs = true;
/** Limit schema objects to those in this comma-delimited list. */
private String _schemaFilterInclude = "";
/** Limit catalog objects to those in this comma-delimited list. */
private String _catalogFilterInclude = "";
/** Object Filter */
private String _objectFilterInclude = "";
/** Limit schema objects to those in this comma-delimited list. */
private String _schemaFilterExclude = "";
/** Limit catalog objects to those in this comma-delimited list. */
private String _catalogFilterExclude = "";
/** Object Filter */
private String _objectFilterExclude = "";
/** <TT>true</TT> if sql result meta data should be shown. */
private boolean _showResultsMetaData = true;
/** Name of class to use for metadata output. */
private String _metaDataOutputClassName = IDataSetDestinations.READ_ONLY_TABLE;
/** Name of class to use for SQL results output. */
// private String _sqlOutputMetaDataClassName = IDataSetDestinations.READ_ONLY_TABLE;
/** Name of class to use for table contsnts output. */
private String _tableContentsClassName = IDataSetDestinations.READ_ONLY_TABLE;
/**
* The display class for the SQL results may be either editable or read-only.
* The functions accessing this must use the appropriate getter to be sure
* of getting either the selection made by the user in the Session Properties
* or the read-only or the editable version.
*/
private String _sqlResultsOutputClassName = IDataSetDestinations.READ_ONLY_TABLE;
/**
* <TT>true</TT> if row count should be displayed for every table in object tree.
*/
private boolean _showRowCount = false;
/** <TT>true</TT> if toolbar should be shown. */
private boolean _showToolbar = true;
/** Used to separate SQL multiple statements. */
private String _sqlStmtSep = ";";
/** Used to indicate a "Start Of Line" comment in SQL. */
private String _solComment = "--";
private boolean _removeMultiLineComment = true;
/** Font information for the SQL entry area. */
private FontInfo _fi = (FontInfo)DEFAULT_FONT_INFO.clone();
/** Should the number of SQL statements to save in execution history be limited?. */
private boolean _limitSqlEntryHistorySize = true;
/**
* Does this session share its SQL History with other sessions?
*/
private boolean _sqlShareHistory = true;
/**
* Number of SQL statements to save in execution history. Only applicable
* if <TT>_limitSqlEntryHistorySize</TT> is true.
*/
private int _sqlEntryHistorySize = 100;
/** Orientation of the split pane dividing sql entry area from result area
* @see JSplitPane#VERTICAL_SPLIT
* @see JSplitPane#HORIZONTAL_SPLIT
* */
private int _sqlPanelOrientation = JSplitPane.VERTICAL_SPLIT;
/** Placement of main tabs. See javax.swing.SwingConstants for valid values. */
private int _mainTabPlacement = SwingConstants.TOP;
/**
* Placement of tabs displayed when an object selected in the object
* tree. See javax.swing.SwingConstants for valid values.
*/
private int _objectTabPlacement = SwingConstants.TOP;
/**
* Placement of tabs displayed for SQL execution.
* See javax.swing.SwingConstants for valid values.
*/
private int _sqlExecutionTabPlacement = SwingConstants.TOP;
/**
* Placement of tabs displayed for SQL execution results.
* See javax.swing.SwingConstants for valid values.
*/
private int _sqlResultsTabPlacement = SwingConstants.TOP;
/**
* If <TT>true</TT> then don't execute any further SQL if an error occurs in one.
*/
private boolean _abortOnError = true;
/**
* If <TT>true</TT> then show SQL errors in result tab.
*/
private boolean _showSQLErrorsInTab = true;
/**
* If <TT>true</TT> SQL Errors are written to Log.
*/
private boolean _writeSQLErrorsToLog;
/**
* @see net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadColumns()
*/
private boolean _loadColumnsInBackground;
/** Should the number of SQL result tabs be limited?. */
private boolean _limitSqlResultTabs = true;
private boolean _keepTableLayoutOnRerun;
/**
* The maximum number of open result tabs.
* <= 0 means unlimited.
*/
private int _sqlResultTabLimit = 15;
/**
* The nuber of rows, which the database driver should fetch at once.
*/
private int _sqlFetchSize=50;
/**
* Indicates that the we should use the setFetchSize() Method of an Statement.
*/
private boolean _sqlUseFetchSize;
/**
* Default ctor.
*/
public SessionProperties()
{
super();
}
/**
* Return a copy of this object.
*/
public Object clone()
{
try
{
SessionProperties props = (SessionProperties)super.clone();
props._propChgReporter = null;
if (_fi != null)
{
props.setFontInfo((FontInfo)_fi.clone());
}
return props;
}
catch (CloneNotSupportedException ex)
{
throw new InternalError(ex.getMessage()); // Impossible.
}
}
/**
* Normally we display data using the class selected by the user in the
* Session Preferences, but there are occasions in which the application
* needs to override the user selection and explicitly use either a read-only
* or an editable table. These functions provide access to those class names.
*/
public String getReadOnlyTableOutputClassName()
{
return IDataSetDestinations.READ_ONLY_TABLE;
}
public String getEditableTableOutputClassName()
{
return IDataSetDestinations.EDITABLE_TABLE;
}
/**
* Get the name of the read-only form of the user-selected preference,
* which may be TEXT or READ_ONLY_TABLE. The user may have selected
* EDITABLE_TABLE, but the caller wants to get the read-only version
* (because it does not know how to handle and changes the user makes,
* e.g. because the data represents a multi-table join).
*/
public String getReadOnlySQLResultsOutputClassName()
{
if (_sqlResultsOutputClassName.equals(IDataSetDestinations.EDITABLE_TABLE))
return IDataSetDestinations.READ_ONLY_TABLE;
return _sqlResultsOutputClassName;
}
public void addPropertyChangeListener(PropertyChangeListener listener)
{
getPropertyChangeReporter().addPropertyChangeListener(listener);
}
public void removePropertyChangeListener(PropertyChangeListener listener)
{
getPropertyChangeReporter().removePropertyChangeListener(listener);
}
public String getMetaDataOutputClassName()
{
return _metaDataOutputClassName;
}
public void setMetaDataOutputClassName(String value)
{
if (value == null)
{
value = "";
}
if (!_metaDataOutputClassName.equals(value))
{
final String oldValue = _metaDataOutputClassName;
_metaDataOutputClassName = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.META_DATA_OUTPUT_CLASS_NAME,
oldValue, _metaDataOutputClassName);
}
}
public String getTableContentsOutputClassName()
{
return _tableContentsClassName;
}
public void setTableContentsOutputClassName(String value)
{
if (value == null)
{
value = "";
}
if (!_tableContentsClassName.equals(value))
{
final String oldValue = _tableContentsClassName;
_tableContentsClassName= value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.TABLE_CONTENTS_OUTPUT_CLASS_NAME,
oldValue, _tableContentsClassName);
}
}
/**
* Get the type of output display selected by the user in the
* Session Properties, which may be text, read-only table, or editable table;
* the caller must be able to handle any of those (especially editable).
*/
public String getSQLResultsOutputClassName()
{
return _sqlResultsOutputClassName;
}
/**
* Set the type of output display to user selection, which may be
* text, read-only table, or editable table. This is called
* when the user makes a selection, and also when loading the
* preferences object from the saved data during Squirrel startup.
*/
public void setSQLResultsOutputClassName(String value)
{
if (value == null)
{
value = "";
}
if (!_sqlResultsOutputClassName.equals(value))
{
final String oldValue = _sqlResultsOutputClassName;
_sqlResultsOutputClassName = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_RESULTS_OUTPUT_CLASS_NAME,
oldValue, _sqlResultsOutputClassName);
}
}
public boolean getAutoCommit()
{
return _autoCommit;
}
public void setAutoCommit(boolean value)
{
if (_autoCommit != value)
{
_autoCommit = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.AUTO_COMMIT,
!_autoCommit, _autoCommit);
}
}
public boolean getAbortOnError()
{
return _abortOnError;
}
public void setAbortOnError(boolean value)
{
if (_abortOnError != value)
{
_abortOnError = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.ABORT_ON_ERROR,
!_abortOnError, _abortOnError);
}
}
public boolean getShowSQLErrorsInTab()
{
return _showSQLErrorsInTab; //To change body of created methods use File | Settings | File Templates.
}
public void setShowSQLErrorsInTab(boolean value)
{
if (_showSQLErrorsInTab != value)
{
_showSQLErrorsInTab = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SHOW_SQL_ERRORS_IN_TAB,
!_showSQLErrorsInTab, _showSQLErrorsInTab);
}
}
public boolean getWriteSQLErrorsToLog()
{
return _writeSQLErrorsToLog;
}
public void setWriteSQLErrorsToLog(boolean value)
{
if (_writeSQLErrorsToLog != value)
{
_writeSQLErrorsToLog = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.WRITE_SQL_ERRORS_TO_LOG,
!_writeSQLErrorsToLog, _writeSQLErrorsToLog);
}
}
public boolean getLoadColumnsInBackground()
{
return _loadColumnsInBackground;
}
public void setLoadColumnsInBackground(boolean value)
{
if (_loadColumnsInBackground != value)
{
_loadColumnsInBackground = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.LOAD_COLUMNS_IN_BACKGROUND,
!_loadColumnsInBackground, _loadColumnsInBackground);
}
}
public boolean getLimitSQLResultTabs()
{
return _limitSqlResultTabs;
}
public void setLimitSQLResultTabs(boolean data)
{
final boolean oldValue = _limitSqlResultTabs;
_limitSqlResultTabs = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.LIMIT_SQL_RESULT_TABS,
oldValue, _limitSqlResultTabs);
}
public int getSqlResultTabLimit()
{
return _sqlResultTabLimit;
}
public void setSqlResultTabLimit(int value)
{
if (_sqlResultTabLimit != value)
{
int oldValue = _sqlResultTabLimit;
_sqlResultTabLimit = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_RESULT_TAB_LIMIT,
oldValue, _sqlResultTabLimit);
}
}
public boolean getShowToolBar()
{
return _showToolbar;
}
public void setShowToolBar(boolean value)
{
if (_showToolbar != value)
{
_showToolbar = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SHOW_TOOL_BAR,
!_showToolbar, _showToolbar);
}
}
public int getContentsNbrRowsToShow()
{
return _contentsNbrRowsToShow;
}
public void setContentsNbrRowsToShow(int value)
{
if (_contentsNbrRowsToShow != value)
{
final int oldValue = _contentsNbrRowsToShow;
_contentsNbrRowsToShow = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.CONTENTS_NBR_ROWS_TO_SHOW,
oldValue, _contentsNbrRowsToShow);
}
}
public int getSQLNbrRowsToShow()
{
return _sqlNbrRowsToShow;
}
public void setSQLNbrRowsToShow(int value)
{
if (_sqlNbrRowsToShow != value)
{
final int oldValue = _sqlNbrRowsToShow;
_sqlNbrRowsToShow = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_NBR_ROWS_TO_SHOW,
oldValue, _sqlNbrRowsToShow);
}
}
public int getSQLReadOnBlockSize()
{
return _sqlReadOnBlockSize;
}
public void setSQLReadOnBlockSize(int value)
{
if (_sqlReadOnBlockSize != value)
{
final int oldValue = _sqlReadOnBlockSize;
_sqlReadOnBlockSize = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_READ_ON_BLOCK_SIZE,
oldValue, _sqlReadOnBlockSize);
}
}
public boolean getContentsLimitRows()
{
return _contentsLimitRows;
}
public void setContentsLimitRows(boolean value)
{
if (_contentsLimitRows != value)
{
final boolean oldValue = _contentsLimitRows;
_contentsLimitRows = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.CONTENTS_LIMIT_ROWS,
oldValue, _contentsLimitRows);
}
}
public boolean getSQLLimitRows()
{
return _sqlLimitRows;
}
public void setSQLLimitRows(boolean value)
{
if (_sqlLimitRows != value)
{
final boolean oldValue = _sqlLimitRows;
_sqlLimitRows = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_LIMIT_ROWS,
oldValue, _sqlLimitRows);
}
}
public boolean getSQLReadOn()
{
return _sqlReadOn;
}
public void setSQLReadOn(boolean value)
{
if (_sqlReadOn != value)
{
final boolean oldValue = _sqlReadOn;
_sqlReadOn = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_READ_ON,
oldValue, _sqlReadOn);
}
}
/**
* Sets the number of rows which should be fetched at once.
*/
public void setSQLFetchSize(int value)
{
if(value < 0){
throw new IllegalArgumentException("FetchSize must be >= 0. fetchSize=" +value);
}
if (_sqlFetchSize != value)
{
final int oldValue = _sqlFetchSize;
_sqlFetchSize = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_FETCH_SIZE,
oldValue, _sqlFetchSize);
}
}
/**
* Defines, if we should use {@link Statement#setFetchSize(int)}
*/
public void setSQLUseFetchSize(boolean value)
{
if (_sqlUseFetchSize != value)
{
final boolean oldValue = _sqlUseFetchSize;
_sqlUseFetchSize = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_USE_FETCH_SIZE,
oldValue, _sqlUseFetchSize);
}
}
/**
* Retrieve the string used to separate multiple SQL statements. Possible
* examples are ";" or "GO";
*
* @return String used to separate SQL statements.
*/
public String getSQLStatementSeparator()
{
return _sqlStmtSep;
}
/**
* Set the string used to separate multiple SQL statements. Possible
* examples are ";" or "GO";
*
* @param value Separator string.
*/
public void setSQLStatementSeparator(String value)
{
// It causes a lot of pain in serveral places to cope with nulls or
// emptys here.
if(null == value || 0 == value.trim().length())
{
value =";";
}
if (!_sqlStmtSep.equals(value))
{
final String oldValue = _sqlStmtSep;
_sqlStmtSep = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_STATEMENT_SEPARATOR_STRING,
oldValue, _sqlStmtSep);
}
}
public boolean getCommitOnClosingConnection()
{
return _commitOnClosingConnection;
}
public synchronized void setCommitOnClosingConnection(boolean data)
{
final boolean oldValue = _commitOnClosingConnection;
_commitOnClosingConnection = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.COMMIT_ON_CLOSING_CONNECTION,
oldValue, _commitOnClosingConnection);
}
/**
* Return <TT>true</TT> if row count should be displayed for every table in
* object tree.
*/
public boolean getShowRowCount()
{
return _showRowCount;
}
/**
* Specify whether row count should be displayed for every table in
* object tree.
*
* @param data <TT>true</TT> fi row count should be displayed
* else <TT>false</TT>.
*/
public synchronized void setShowRowCount(boolean data)
{
final boolean oldValue = _showRowCount;
_showRowCount = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SHOW_ROW_COUNT,
oldValue, _showRowCount);
}
/**
* Return the string used to represent a Start of Line Comment in SQL.
*/
public String getStartOfLineComment()
{
return _solComment;
}
/**
* Set the string used to represent a Start of Line Comment in SQL.
*/
public synchronized void setStartOfLineComment(String data)
{
final String oldValue = _solComment;
_solComment = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_START_OF_LINE_COMMENT,
oldValue, _solComment);
}
public boolean getRemoveMultiLineComment()
{
return _removeMultiLineComment;
}
public synchronized void setRemoveMultiLineComment(boolean data)
{
final boolean oldValue = _removeMultiLineComment;
_removeMultiLineComment = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.REMOVE_MULTI_LINE_COMMENT,
oldValue, _removeMultiLineComment);
}
public FontInfo getFontInfo()
{
return _fi;
}
public void setFontInfo(FontInfo data)
{
if (_fi == null || !_fi.equals(data))
{
final FontInfo oldValue = _fi;
_fi = data != null ? data : (FontInfo)DEFAULT_FONT_INFO.clone();
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.FONT_INFO, oldValue, _fi);
}
}
public boolean getLimitSQLEntryHistorySize()
{
return _limitSqlEntryHistorySize;
}
public void setLimitSQLEntryHistorySize(boolean data)
{
final boolean oldValue = _limitSqlEntryHistorySize;
_limitSqlEntryHistorySize = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.LIMIT_SQL_ENTRY_HISTORY_SIZE,
oldValue, _limitSqlEntryHistorySize);
}
/**
* Does this session share its SQL History with other sessions?
*
* @return <TT>true</TT> if this session shares its history.
*/
public boolean getSQLShareHistory()
{
return _sqlShareHistory;
}
/**
* Set whether this session shares its SQL History with other sessions.
*
* @param data <TT>true</TT> if this session shares its history.
*/
public void setSQLShareHistory(boolean data)
{
final boolean oldValue = _sqlShareHistory;
_sqlShareHistory = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.SQL_SHARE_HISTORY,
oldValue, _sqlShareHistory);
}
public int getSQLEntryHistorySize()
{
return _sqlEntryHistorySize;
}
public void setSQLEntryHistorySize(int data)
{
final int oldValue = _sqlEntryHistorySize;
_sqlEntryHistorySize = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_ENTRY_HISTORY_SIZE,
oldValue, _sqlEntryHistorySize);
}
public int getSqlPanelOrientation()
{
return _sqlPanelOrientation;
}
public void setSqlPanelOrientation(int value)
{
if (_sqlPanelOrientation != value)
{
final int oldValue = _sqlPanelOrientation;
_sqlPanelOrientation = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_PANEL_ORIENTATION,
oldValue, _sqlPanelOrientation);
}
}
public int getMainTabPlacement()
{
return _mainTabPlacement;
}
public void setMainTabPlacement(int value)
{
if (_mainTabPlacement != value)
{
final int oldValue = _mainTabPlacement;
_mainTabPlacement = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.MAIN_TAB_PLACEMENT,
oldValue, _mainTabPlacement);
}
}
public int getObjectTabPlacement()
{
return _objectTabPlacement;
}
public void setObjectTabPlacement(int value)
{
if (_objectTabPlacement != value)
{
final int oldValue = _objectTabPlacement;
_objectTabPlacement = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.OBJECT_TAB_PLACEMENT,
oldValue, _objectTabPlacement);
}
}
public int getSQLExecutionTabPlacement()
{
return _sqlExecutionTabPlacement;
}
public void setSQLExecutionTabPlacement(int value)
{
if (_sqlExecutionTabPlacement != value)
{
final int oldValue = _sqlExecutionTabPlacement;
_sqlExecutionTabPlacement = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_EXECUTION_TAB_PLACEMENT,
oldValue, _sqlExecutionTabPlacement);
}
}
public int getSQLResultsTabPlacement()
{
return _sqlResultsTabPlacement;
}
public void setSQLResultsTabPlacement(int value)
{
if (_sqlResultsTabPlacement != value)
{
// if(value == SwingConstants.BOTTOM)
// {
// // Some way this property slipt into older Property files but it was never
// // used earlier. We use this little (ugly) trick to keep users being confused by
// // a bottom tab placing. This was introduced for 1.2 beta 7.
// // TODO: Remove some time later
// if(Preferences.userRoot().getBoolean("Squirrel.TabPlacementCorrectionONFirstStartOf1_2_beta7", true))
// {
// value = SwingConstants.TOP;
// Preferences.userRoot().putBoolean("Squirrel.TabPlacementCorrectionONFirstStartOf1_2_beta7", false);
// }
// }
final int oldValue = _sqlResultsTabPlacement;
_sqlResultsTabPlacement = value;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SQL_RESULTS_TAB_PLACEMENT,
oldValue, _sqlResultsTabPlacement);
}
}
/**
* Return comma-separated catalog of schema prefixes to display in the
* object tree.
*/
public String getCatalogFilterInclude()
{
return _catalogFilterInclude;
}
/**
* Return comma-separated list of schema prefixes to display in the object
* tree.
*/
public String getSchemaFilterInclude()
{
return _schemaFilterInclude;
}
public String getObjectFilterInclude()
{
return _objectFilterInclude;
}
/**
* Set the comma-separated list of catalog prefixes to display in the object tree.
*/
public synchronized void setCatalogFilterInclude(String data)
{
final String oldValue = _catalogFilterInclude;
_catalogFilterInclude = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.CATALOG_FILTER_INCLUDE,
oldValue, _catalogFilterInclude);
}
/**
* Set the comma-separated list of schema prefixes to display in the object tree.
*/
public synchronized void setSchemaFilterInclude(String data)
{
final String oldValue = _schemaFilterInclude;
_schemaFilterInclude = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SCHEMA_FILTER_INCLUDE,
oldValue,
_schemaFilterInclude);
}
public synchronized void setObjectFilterInclude(String data)
{
final String oldValue = _objectFilterInclude;
_objectFilterInclude = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.OBJECT_FILTER_INCLUDE, oldValue, _objectFilterInclude);
}
/**
* Return comma-separated catalog of schema prefixes to display in the
* object tree.
*/
public String getCatalogFilterExclude()
{
return _catalogFilterExclude;
}
/**
* Return comma-separated list of schema prefixes to display in the object
* tree.
*/
public String getSchemaFilterExclude()
{
return _schemaFilterExclude;
}
public String getObjectFilterExclude()
{
return _objectFilterExclude;
}
public boolean getKeepTableLayoutOnRerun()
{
return _keepTableLayoutOnRerun;
}
public synchronized void setKeepTableLayoutOnRerun(boolean data)
{
final boolean oldValue = _keepTableLayoutOnRerun;
_keepTableLayoutOnRerun = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.KEEP_TABLE_LAYOUT_ON_RERUN,
oldValue, _keepTableLayoutOnRerun);
}
/**
* Set the comma-separated list of catalog prefixes to display in the object tree.
*/
public synchronized void setCatalogFilterExclude(String data)
{
final String oldValue = _catalogFilterExclude;
_catalogFilterExclude = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.CATALOG_FILTER_EXCLUDE,
oldValue, _catalogFilterExclude);
}
/**
* Set the comma-separated list of schema prefixes to display in the object tree.
*/
public synchronized void setSchemaFilterExclude(String data)
{
final String oldValue = _schemaFilterExclude;
_schemaFilterExclude = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SCHEMA_FILTER_EXCLUDE,
oldValue,
_schemaFilterExclude);
}
public synchronized void setObjectFilterExclude(String data)
{
final String oldValue = _objectFilterExclude;
_objectFilterExclude = data;
getPropertyChangeReporter().firePropertyChange(IPropertyNames.OBJECT_FILTER_EXCLUDE, oldValue, _objectFilterExclude);
}
/**
* Return <CODE>true</CODE> if schemas and catalogs should be loaded into
* the object tree.
*/
public boolean getLoadSchemasCatalogs()
{
return _loadSchemasCatalogs;
}
/**
* Set <CODE>true</CODE> if schemas and catalogs should be loaded into the
* object tree.
*/
public synchronized void setLoadSchemasCatalogs(boolean data)
{
final boolean oldValue = _loadSchemasCatalogs;
_loadSchemasCatalogs = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.LOAD_SCHEMAS_CATALOGS, oldValue, _loadSchemasCatalogs);
}
/**
* Set <CODE>true</CODE> if sql results meta data should be loaded.
*/
public synchronized void setShowResultsMetaData(boolean data)
{
final boolean oldValue = _showResultsMetaData;
_showResultsMetaData = data;
getPropertyChangeReporter().firePropertyChange(
IPropertyNames.SHOW_RESULTS_META_DATA,
oldValue, _showResultsMetaData);
}
/**
* Return <CODE>true</CODE> if sql results meta data should be loaded.
*/
public boolean getShowResultsMetaData()
{
return _showResultsMetaData;
}
private synchronized PropertyChangeReporter getPropertyChangeReporter()
{
if (_propChgReporter == null)
{
_propChgReporter = new PropertyChangeReporter(this);
}
return _propChgReporter;
}
public int getSQLFetchSize()
{
return _sqlFetchSize;
}
public boolean getSQLUseFetchSize()
{
return _sqlUseFetchSize;
}
}