Java tutorial
package net.sourceforge.squirrel_sql.client; /* * TODO: finish i18n */ /* * Copyright (C) 2001-2006 Colin Bell * colbell@users.sourceforge.net * * Modifications Copyright (C) 2003-2004 Jason Height * * 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.beans.PropertyChangeEvent; import java.beans.PropertyChangeListener; import java.io.*; import java.sql.DriverManager; import java.util.*; import javax.swing.Action; import javax.swing.JComponent; import javax.swing.JMenu; import javax.swing.JOptionPane; import javax.swing.PopupFactory; import javax.swing.ToolTipManager; import javax.swing.UIManager; import javax.swing.plaf.metal.MetalLookAndFeel; import net.sourceforge.squirrel_sql.client.gui.recentfiles.RecentFilesManager; import org.apache.commons.lang.StringUtils; import net.sourceforge.squirrel_sql.client.action.ActionCollection; import net.sourceforge.squirrel_sql.client.gui.FileViewerFactory; import net.sourceforge.squirrel_sql.client.gui.SquirrelSplashScreen; import net.sourceforge.squirrel_sql.client.gui.WindowManager; import net.sourceforge.squirrel_sql.client.gui.desktopcontainer.DesktopStyle; import net.sourceforge.squirrel_sql.client.gui.builders.UIFactory; import net.sourceforge.squirrel_sql.client.gui.db.DataCache; import net.sourceforge.squirrel_sql.client.gui.laf.AllBluesBoldMetalTheme; import net.sourceforge.squirrel_sql.client.gui.mainframe.MainFrame; import net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToStartupAliasesCommand; import net.sourceforge.squirrel_sql.client.mainframe.action.ViewHelpCommand; import net.sourceforge.squirrel_sql.client.plugin.IPlugin; import net.sourceforge.squirrel_sql.client.plugin.IPluginManager; import net.sourceforge.squirrel_sql.client.plugin.PluginLoadInfo; import net.sourceforge.squirrel_sql.client.plugin.PluginManager; import net.sourceforge.squirrel_sql.client.preferences.PreferenceType; import net.sourceforge.squirrel_sql.client.preferences.SquirrelPreferences; import net.sourceforge.squirrel_sql.client.resources.SquirrelResources; import net.sourceforge.squirrel_sql.client.session.DefaultSQLEntryPanelFactory; import net.sourceforge.squirrel_sql.client.session.ISQLEntryPanelFactory; import net.sourceforge.squirrel_sql.client.session.SessionManager; import net.sourceforge.squirrel_sql.client.session.mainpanel.SQLHistory; import net.sourceforge.squirrel_sql.client.session.mainpanel.SQLHistoryItem; import net.sourceforge.squirrel_sql.client.session.properties.EditWhereCols; import net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCacheSerializer; import net.sourceforge.squirrel_sql.client.update.autocheck.UpdateCheckTimer; import net.sourceforge.squirrel_sql.client.update.autocheck.UpdateCheckTimerImpl; import net.sourceforge.squirrel_sql.client.update.gui.installer.PreLaunchHelper; import net.sourceforge.squirrel_sql.client.update.gui.installer.PreLaunchHelperFactory; import net.sourceforge.squirrel_sql.client.update.gui.installer.PreLaunchHelperFactoryImpl; import net.sourceforge.squirrel_sql.client.util.ApplicationFiles; import net.sourceforge.squirrel_sql.fw.datasetviewer.CellImportExportInfoSaver; import net.sourceforge.squirrel_sql.fw.datasetviewer.cellcomponent.DTProperties; import net.sourceforge.squirrel_sql.fw.gui.ErrorDialog; import net.sourceforge.squirrel_sql.fw.gui.action.wikiTable.IWikiTableConfigurationFactory; import net.sourceforge.squirrel_sql.fw.gui.action.wikiTable.WikiTableConfigurationFactory; import net.sourceforge.squirrel_sql.fw.gui.action.wikiTable.WikiTableConfigurationStorage; import net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager; import net.sourceforge.squirrel_sql.fw.util.BareBonesBrowserLaunch; import net.sourceforge.squirrel_sql.fw.util.BaseException; import net.sourceforge.squirrel_sql.fw.util.ClassLoaderListener; import net.sourceforge.squirrel_sql.fw.util.IMessageHandler; import net.sourceforge.squirrel_sql.fw.util.ProxyHandler; import net.sourceforge.squirrel_sql.fw.util.StringManager; import net.sourceforge.squirrel_sql.fw.util.StringManagerFactory; import net.sourceforge.squirrel_sql.fw.util.TaskThreadPool; import net.sourceforge.squirrel_sql.fw.util.log.ILogger; import net.sourceforge.squirrel_sql.fw.util.log.LoggerController; import net.sourceforge.squirrel_sql.fw.xml.XMLBeanReader; import net.sourceforge.squirrel_sql.fw.xml.XMLBeanWriter; /** * Defines the API to do callbacks on the application. * * @author <A HREF="mailto:colbell@users.sourceforge.net">Colin Bell</A> * @author Lynn Pye */ class Application implements IApplication { /** Logger for this class. */ private static ILogger s_log = LoggerController.createLogger(Application.class); /** Internationalized strings for this class. */ private static final StringManager s_stringMgr = StringManagerFactory.getStringManager(Application.class); private SquirrelPreferences _prefs; private DesktopStyle _desktopStyle; private SQLDriverManager _driverMgr; private DataCache _cache; private ActionCollection _actions; /** Applications main frame. */ // private MainFrame _mainFrame; /** Object to manage plugins. */ private IPluginManager _pluginManager; private final DummyAppPlugin _dummyPlugin = new DummyAppPlugin(); private SquirrelResources _resources; /** Thread pool for long running tasks. */ private final TaskThreadPool _threadPool = new TaskThreadPool(); /** This object manages the open sessions. */ private SessionManager _sessionManager; /** This object manages the windows for this application. */ private WindowManager _windowManager; private LoggerController _loggerFactory; /** Factory used to create SQL entry panels. */ private ISQLEntryPanelFactory _sqlEntryFactory = new DefaultSQLEntryPanelFactory(); /** Output stream for JDBC debug logging. */ private PrintStream _jdbcDebugOutputStream; /** Output writer for JDBC debug logging. */ private PrintWriter _jdbcDebugOutputWriter; /** Contains info about fonts for squirrel. */ private final FontInfoStore _fontInfoStore = new FontInfoStore(); /** Application level SQL History. */ private SQLHistory _sqlHistory; /** * Configuration factory for WIKI tables. */ private IWikiTableConfigurationFactory wikiTableConfigFactory = WikiTableConfigurationFactory.getInstance(); /** Current type of JDBC debug logging that we are doing. */ private int _jdbcDebugType = SquirrelPreferences.IJdbcDebugTypes.NONE; /** * contains info about files and directories used by the application. */ private ApplicationFiles _appFiles = null; private EditWhereCols editWhereCols = new EditWhereCols(); private List<ApplicationListener> _listeners = new ArrayList<ApplicationListener>(); private UpdateCheckTimer updateCheckTimer = null; private PreLaunchHelperFactory preLaunchHelperFactory = new PreLaunchHelperFactoryImpl(); private IShutdownTimer _shutdownTimer = new ShutdownTimer(); private MultipleWindowsHandler _multipleWindowsHandler = new MultipleWindowsHandler(this); private RecentFilesManager _recentFilesManager = new RecentFilesManager(); /** * Default ctor. */ Application() { super(); } /** * Application is starting up. */ public void startup() { final ApplicationArguments args = ApplicationArguments.getInstance(); // Setup the applications Look and Feel. setupLookAndFeel(args); editWhereCols.setApplication(this); // TODO: Make properties file Application.properties so we can use class // name to generate properties file name. _resources = new SquirrelResources(SquirrelResources.BUNDLE_BASE_NAME); _prefs = SquirrelPreferences.load(); _desktopStyle = new DesktopStyle(_prefs); Locale.setDefault(constructPreferredLocale(_prefs)); preferencesHaveChanged(null); _prefs.addPropertyChangeListener(new PropertyChangeListener() { public void propertyChange(PropertyChangeEvent evt) { preferencesHaveChanged(evt); } }); SquirrelSplashScreen splash = null; if (args.getShowSplashScreen()) { splash = new SquirrelSplashScreen(_prefs, 17); } executeStartupTasks(splash, args); } /** * Application is shutting down. */ public boolean shutdown(boolean updateLaunchScript) { long begin = System.currentTimeMillis(); s_log.info("Application.shutdown: BEGIN: " + Calendar.getInstance().getTime()); updateCheckTimer.stop(); s_log.info( "Application.shutdown: updateCheckTimer.stop() ELAPSED: " + (System.currentTimeMillis() - begin)); _saveApplicationState(begin); s_log.info("Application.shutdown: saveApplicationState() ELAPSED: " + (System.currentTimeMillis() - begin)); if (!closeAllSessions()) { return false; } _pluginManager.unloadPlugins(); s_log.info("Application.shutdown: _pluginManager.unloadPlugins() ELAPSED: " + (System.currentTimeMillis() - begin)); closeAllViewers(); s_log.info("Application.shutdown: closeAllViewers() ELAPSED: " + (System.currentTimeMillis() - begin)); closeOutputStreams(); s_log.info("Application.shutdown: closeOutputStreams() ELAPSED: " + (System.currentTimeMillis() - begin)); SchemaInfoCacheSerializer.waitTillStoringIsDone(); s_log.info("Application.shutdown: SchemaInfoCacheSerializer.waitTillStoringIsDone() ELAPSED: " + (System.currentTimeMillis() - begin)); if (updateLaunchScript) { updateLaunchScript(); s_log.info( "Application.shutdown: updateLaunchScript() ELAPSED: " + (System.currentTimeMillis() - begin)); } s_log.info("Application.shutdown END: " + Calendar.getInstance().getTime()); LoggerController.shutdown(); return true; } /** * Saves off preferences and all state present in the application. */ public void saveApplicationState() { _saveApplicationState(null); } private void _saveApplicationState(Long begin) { if (null == begin) { begin = System.currentTimeMillis(); } _prefs.setFirstRun(false); s_log.info("Application.shutdown->_saveApplicationState: _prefs.setFirstRun(false) ELAPSED: " + (System.currentTimeMillis() - begin)); for (ApplicationListener l : _listeners.toArray(new ApplicationListener[0])) { l.saveApplicationState(); } s_log.info("Application.shutdown->_saveApplicationState: _listeners ELAPSED: " + (System.currentTimeMillis() - begin)); saveDrivers(); s_log.info("Application.shutdown->_saveApplicationState: saveDrivers() ELAPSED: " + (System.currentTimeMillis() - begin)); saveAliases(); s_log.info("Application.shutdown->_saveApplicationState: saveAliases() ELAPSED: " + (System.currentTimeMillis() - begin)); _recentFilesManager.saveXmlBean(_appFiles.getRecentFilesXmlBeanFile()); s_log.info("Application.shutdown->_saveApplicationState: saveRecentFiles() ELAPSED: " + (System.currentTimeMillis() - begin)); // Save Application level SQL history. saveSQLHistory(); s_log.info("Application.shutdown->_saveApplicationState: saveSQLHistory() ELAPSED: " + (System.currentTimeMillis() - begin)); // Save options selected for Cell Import Export operations saveCellImportExportInfo(); s_log.info("Application.shutdown->_saveApplicationState: saveCellImportExportInfo() ELAPSED: " + (System.currentTimeMillis() - begin)); // Save options selected for Edit Where Columns saveEditWhereColsInfo(); s_log.info("Application.shutdown->_saveApplicationState: saveEditWhereColsInfo() ELAPSED: " + (System.currentTimeMillis() - begin)); // Save options selected for DataType-specific properties saveDataTypePreferences(); s_log.info("Application.shutdown->_saveApplicationState: saveDataTypePreferences() ELAPSED: " + (System.currentTimeMillis() - begin)); // Save user specific WIKI configurations saveUserSpecificWikiConfigurations(); s_log.info("Application.shutdown->_saveApplicationState: saveUserSpecificWikiConfigurations() ELAPSED: " + (System.currentTimeMillis() - begin)); _prefs.save(); } /** * Builds a Locale from the user's preferred locale preference. * * @param prefs * the user's preferences * @return a local object. If no preference is found then US English is the default. */ private Locale constructPreferredLocale(SquirrelPreferences prefs) { String langCountryPair = prefs.getPreferredLocale(); if (StringUtils.isEmpty(langCountryPair)) { langCountryPair = "en_US"; } String[] parts = langCountryPair.split("_"); if (parts.length == 2) { return new Locale(parts[0], parts[1]); } return new Locale(parts[0]); } /** * */ private void closeOutputStreams() { if (_jdbcDebugOutputStream != null) { _jdbcDebugOutputStream.close(); _jdbcDebugOutputStream = null; } if (_jdbcDebugOutputWriter != null) { _jdbcDebugOutputWriter.close(); _jdbcDebugOutputWriter = null; } } /** * Saves alias definitions that are in memory to the aliases file. */ private void saveAliases() { try { final File file = _appFiles.getDatabaseAliasesFile(); _cache.saveAliases(file); } catch (Throwable th) { String thMsg = th.getMessage(); if (thMsg == null) { thMsg = ""; } String msg = s_stringMgr.getString("Application.error.aliassave", th.getMessage()); showErrorDialog(msg, th); s_log.error(msg, th); } } /** * Saves the driver definitions that are in memory to the drivers file. */ private void saveDrivers() { try { final File file = _appFiles.getDatabaseDriversFile(); _cache.saveDrivers(file); } catch (Throwable th) { String msg = s_stringMgr.getString("Application.error.driversave", th.getMessage()); showErrorDialog(msg, th); s_log.error(msg, th); } } /** * */ private void closeAllViewers() { try { FileViewerFactory.getInstance().closeAllViewers(); } catch (Throwable t) { // i18n[Application.error.closeFileViewers=Unable to close all file viewers] s_log.error(s_stringMgr.getString("Application.error.closeFileViewers"), t); } } /** * Returns true is closing all sessions was successful. * * @return */ private boolean closeAllSessions() { boolean result = false; try { if (!_sessionManager.closeAllSessions()) { s_log.info( s_stringMgr.getString("Application.shutdownCancelled", Calendar.getInstance().getTime())); } else { result = true; } } catch (Throwable t) { String msg = s_stringMgr.getString("Application.error.closeAllSessions", t.getMessage()); s_log.error(msg, t); } return result; } /** * Ideally, it would be unnecessary to update the launch script here. Unfortunately, in squirrel-sql.sh * due to a bug in how the updater's CLASSPATH is being built, the update application uses the old * application and library jars instead of the ones in the downloads section. So, the new code that * fixes the launch scripts doesn't get executed until the second update. Once that code is out there, * ( that is, the 3.2 version has been released for a while, and we are pretty sure there are no older * 3.x installations that still need to be upgraded), then it would be safe to remove this code. */ private void updateLaunchScript() { try { PreLaunchHelper helper = preLaunchHelperFactory.createPreLaunchHelper(); helper.updateLaunchScript(); helper.copySplashImage(); } catch (Exception e) { s_log.info("Unexpected exception while attempting to update the launch script: " + e.getMessage()); } } public IPluginManager getPluginManager() { return _pluginManager; } /** * Return the manager responsible for windows. * * @return the manager responsible for windows. */ public WindowManager getWindowManager() { return _windowManager; } public ActionCollection getActionCollection() { return _actions; } public SQLDriverManager getSQLDriverManager() { return _driverMgr; } public DataCache getDataCache() { return _cache; } public IPlugin getDummyAppPlugin() { return _dummyPlugin; } public SquirrelResources getResources() { return _resources; } public IMessageHandler getMessageHandler() { return getMainFrame().getMessagePanel(); } public SquirrelPreferences getSquirrelPreferences() { return _prefs; } public DesktopStyle getDesktopStyle() { return _desktopStyle; } public MainFrame getMainFrame() { // return _mainFrame; return _windowManager.getMainFrame(); } /** * Retrieve the object that manages sessions. * * @return <TT>SessionManager</TT>. */ public SessionManager getSessionManager() { return _sessionManager; } /** * Display an error message dialog. * * @param msg * The error msg. */ public void showErrorDialog(String msg) { s_log.error(msg); new ErrorDialog(getMainFrame(), msg).setVisible(true); } /** * Display an error message dialog. * * @param th * The Throwable that caused the error */ public void showErrorDialog(Throwable th) { s_log.error(th); new ErrorDialog(getMainFrame(), th).setVisible(true); } /** * Display an error message dialog. * * @param msg * The error msg. * @param th * The Throwable that caused the error */ public void showErrorDialog(String msg, Throwable th) { s_log.error(msg, th); new ErrorDialog(getMainFrame(), msg, th).setVisible(true); } /** * Return the collection of <TT>FontInfo </TT> objects for this app. * * @return the collection of <TT>FontInfo </TT> objects for this app. */ public FontInfoStore getFontInfoStore() { return _fontInfoStore; } /** * Return the thread pool for this app. * * @return the thread pool for this app. */ public TaskThreadPool getThreadPool() { return _threadPool; } public LoggerController getLoggerFactory() { return _loggerFactory; } /** * Return the factory object used to create the SQL entry panel. * * @return the factory object used to create the SQL entry panel. */ public ISQLEntryPanelFactory getSQLEntryPanelFactory() { return _sqlEntryFactory; } /** * Set the factory object used to create the SQL entry panel. * * @param factory * the factory object used to create the SQL entry panel. */ public void setSQLEntryPanelFactory(ISQLEntryPanelFactory factory) { _sqlEntryFactory = factory != null ? factory : new DefaultSQLEntryPanelFactory(); } /** * Retrieve the application level SQL History object. * * @return the application level SQL History object. */ public SQLHistory getSQLHistory() { return _sqlHistory; } public synchronized void addToMenu(int menuId, JMenu menu) { final MainFrame mf = getMainFrame(); if (mf != null) { mf.addToMenu(menuId, menu); } else { throw new IllegalStateException(s_stringMgr.getString("Application.error.menuadding")); } } public synchronized void addToMenu(int menuId, Action action) { final MainFrame mf = getMainFrame(); if (mf != null) { mf.addToMenu(menuId, action); } else { throw new IllegalStateException(s_stringMgr.getString("Application.error.menuadding")); } } /** * Add component to the main frames status bar. * * @param comp * Component to add. */ public void addToStatusBar(JComponent comp) { final MainFrame mf = getMainFrame(); if (mf != null) { mf.addToStatusBar(comp); } else { throw new IllegalStateException(s_stringMgr.getString("Application.error.compadding")); } } /** * Remove component to the main frames status bar. * * @param comp * Component to remove. */ public void removeFromStatusBar(JComponent comp) { final MainFrame mf = getMainFrame(); if (mf != null) { mf.removeFromStatusBar(comp); } else { throw new IllegalStateException(s_stringMgr.getString("Application.error.compremoving")); } } /** * Launches the specified url in the system default web-browser * * @param url * the URL of the web page to display. */ public void openURL(String url) { BareBonesBrowserLaunch.openURL(url); } /** * Execute the taks required to start SQuirreL. Each of these is displayed as a message on the splash * screen (if one is being used) in order to let the user know what is happening. * * @param splash * The splash screen (can be null). * @param args * Application arguments. * @throws IllegalArgumentException * Thrown if <TT>ApplicationArguments<.TT> is null. */ private void executeStartupTasks(SquirrelSplashScreen splash, ApplicationArguments args) { if (args == null) { throw new IllegalArgumentException("ApplicationArguments == null"); } indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.createSessionManager")); // AliasMaintSheetFactory.initialize(this); // DriverMaintSheetFactory.initialize(this); _sessionManager = new SessionManager(this); indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadingprefs")); final boolean loadPlugins = args.getLoadPlugins(); if (loadPlugins) { indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadingplugins")); } else { indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.notloadingplugins")); } UIFactory.initialize(_prefs, this); _pluginManager = new PluginManager(this); if (args.getLoadPlugins()) { if (null != splash && _prefs.getShowPluginFilesInSplashScreen()) { ClassLoaderListener listener = splash.getClassLoaderListener(); _pluginManager.setClassLoaderListener(listener); } if (args.getPluginList() != null) { _pluginManager.loadPluginsFromList(args.getPluginList()); } else { _pluginManager.loadPlugins(); } } indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadingactions")); _actions = new ActionCollection(this); indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadinguseracc")); _actions.loadActionKeys(_prefs.getActionKeys()); indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.createjdbcmgr")); _driverMgr = new SQLDriverManager(); // TODO: pass in a message handler so user gets error msgs. indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadingjdbc")); _appFiles = new ApplicationFiles(); String errMsg = FileTransformer.transform(_appFiles); if (null != errMsg) { System.err.println(errMsg); JOptionPane.showMessageDialog(null, errMsg, "SQuirreL failed to start", JOptionPane.ERROR_MESSAGE); System.exit(-1); } _cache = new DataCache(_driverMgr, _appFiles.getDatabaseDriversFile(), _appFiles.getDatabaseAliasesFile(), _resources.getDefaultDriversUrl(), this); indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.createWindowManager")); _windowManager = new WindowManager(this, args.getUserInterfaceDebugEnabled()); // _mainFrame = new MainFrame(this); indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.uifactoryinit")); // AliasMaintSheetFactory.initialize(this); // DriverMaintSheetFactory.initialize(this); String initializingPlugins = s_stringMgr.getString("Application.splash.initializingplugins"); String notloadingplugins = s_stringMgr.getString("Application.splash.notloadingplugins"); String task = (loadPlugins ? initializingPlugins : notloadingplugins); indicateNewStartupTask(splash, task); if (loadPlugins) { _pluginManager.initializePlugins(); for (Iterator<PluginLoadInfo> it = _pluginManager.getPluginLoadInfoIterator(); it.hasNext();) { PluginLoadInfo pli = it.next(); long created = pli.getCreationTime(); long load = pli.getLoadTime(); long init = pli.getInitializeTime(); Object[] params = new Object[] { pli.getInternalName(), Long.valueOf(created), Long.valueOf(load), Long.valueOf(init), Long.valueOf(created + load + init) }; String pluginLoadMsg = s_stringMgr.getString("Application.splash.loadplugintime", params); s_log.info(pluginLoadMsg); } } // i18n[Application.splash.loadsqlhistory=Loading SQL history...] indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadsqlhistory")); loadSQLHistory(); // i18n[Application.splash.loadcellselections=Loading Cell Import/Export selections...] indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadcellselections")); loadCellImportExportInfo(); // i18n[Application.splash.loadeditselections=Loading Edit 'Where' Columns selections...] indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadeditselections")); loadEditWhereColsInfo(); // i18n[Application.splash.loaddatatypeprops=Loading Data Type Properties...] indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loaddatatypeprops")); loadDTProperties(); // i18n[Application.splash.loadsqlhistory=Loading user specific WIKI configurations...] indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.loadUserSpecificWikiConfiguration")); loadUserSpecificWikiTableConfigurations(); // i18n[Application.splash.showmainwindow=Showing main window...] indicateNewStartupTask(splash, s_stringMgr.getString("Application.splash.showmainwindow")); _windowManager.moveToFront(_windowManager.getMainFrame()); _threadPool.setParentForMessages(_windowManager.getMainFrame()); // _mainFrame.setVisible(true); // _mainFrame.toFront(); // Required on Linux new ConnectToStartupAliasesCommand(this).execute(); if (_prefs.isFirstRun()) { try { new ViewHelpCommand(this).execute(); } catch (BaseException ex) { // i18n[Application.error.showhelpwindow=Error showing help window] s_log.error(s_stringMgr.getString("Application.error.showhelpwindow"), ex); } } updateCheckTimer = new UpdateCheckTimerImpl(this); updateCheckTimer.start(); if (args.getShutdownTimerSeconds() != null) { _shutdownTimer.setShutdownSeconds(args.getShutdownTimerSeconds()); _shutdownTimer.setApplication(this); _shutdownTimer.start(); } _recentFilesManager.initXmlBean(_appFiles.getRecentFilesXmlBeanFile()); } /** * If we are running with a splash screen then indicate in the splash screen that a new task has commenced. * * @param splash * Splash screen. * @param taskDescription * Description of new task. */ private void indicateNewStartupTask(SquirrelSplashScreen splash, String taskDescription) { if (splash != null) { splash.indicateNewTask(taskDescription); } } private void preferencesHaveChanged(PropertyChangeEvent evt) { final String propName = evt != null ? evt.getPropertyName() : null; if (propName == null || propName.equals(SquirrelPreferences.IPropertyNames.SHOW_TOOLTIPS)) { ToolTipManager.sharedInstance().setEnabled(_prefs.getShowToolTips()); } if (propName == null || propName.equals(SquirrelPreferences.IPropertyNames.JDBC_DEBUG_TYPE)) { setupJDBCLogging(); } if (propName == null || propName.equals(SquirrelPreferences.IPropertyNames.LOGIN_TIMEOUT)) { DriverManager.setLoginTimeout(_prefs.getLoginTimeout()); } if (propName == null || propName == SquirrelPreferences.IPropertyNames.PROXY) { new ProxyHandler().apply(_prefs.getProxySettings()); } } /** * Load application level SQL History for the current user. */ @SuppressWarnings("unchecked") private void loadSQLHistory() { try { XMLBeanReader doc = new XMLBeanReader(); doc.load(new ApplicationFiles().getUserSQLHistoryFile()); Iterator it = doc.iterator(); if (it.hasNext()) { _sqlHistory = (SQLHistory) it.next(); } } catch (FileNotFoundException ignore) { // History file not found for user - first time user ran pgm. } catch (Exception ex) { // i18n[Application.error.loadsqlhistory=Unable to load SQL history from persistant storage.] s_log.error(s_stringMgr.getString("Application.error.loadsqlhistory"), ex); } finally { if (_sqlHistory == null) { _sqlHistory = new SQLHistory(); } } } /** * Load the configurations for WIKI tables. * @see WikiTableConfigurationStorage */ @SuppressWarnings("unchecked") private void loadUserSpecificWikiTableConfigurations() { try { WikiTableConfigurationStorage data; XMLBeanReader doc = new XMLBeanReader(); doc.load(new ApplicationFiles().getUserSpecificWikiConfigurationsFile()); Iterator it = doc.iterator(); if (it.hasNext()) { data = (WikiTableConfigurationStorage) it.next(); wikiTableConfigFactory.replaceUserSpecificConfigurations(data.configurationsAsList()); } } catch (FileNotFoundException ignore) { // History file not found for user - first time user ran pgm. } catch (Exception ex) { // i18n[Application.error.loadsqlhistory=Unable to load SQL history from persistant storage.] s_log.error(s_stringMgr.getString("Application.error.loadUserSpecificWikiConfiguration"), ex); } finally { if (_sqlHistory == null) { _sqlHistory = new SQLHistory(); } } } /** * Save application level SQL history for current user. */ private void saveSQLHistory() { // Get the history into an array. try { if (_prefs.getSessionProperties().getLimitSQLEntryHistorySize()) { SQLHistoryItem[] data = _sqlHistory.getData(); int maxSize = _prefs.getSessionProperties().getSQLEntryHistorySize(); if (data.length > maxSize) { SQLHistoryItem[] reducedData = new SQLHistoryItem[maxSize]; System.arraycopy(data, data.length - maxSize, reducedData, 0, maxSize); _sqlHistory.setData(reducedData); } } XMLBeanWriter wtr = new XMLBeanWriter(_sqlHistory); wtr.save(new ApplicationFiles().getUserSQLHistoryFile()); } catch (Exception ex) { // i18n[Application.error.savesqlhistory=Unable to write SQL queries to persistant storage.] s_log.error(s_stringMgr.getString("Application.error.savesqlhistory"), ex); } } /** * Save user specific configurations for WIKI tables */ private void saveUserSpecificWikiConfigurations() { // Get the history into an array. try { WikiTableConfigurationStorage data = new WikiTableConfigurationStorage( wikiTableConfigFactory.getUserSpecificConfigurations()); XMLBeanWriter wtr = new XMLBeanWriter(data); wtr.save(new ApplicationFiles().getUserSpecificWikiConfigurationsFile()); } catch (Exception ex) { s_log.error(s_stringMgr.getString("Application.error.saveUserSpecificWikiConfiguration"), ex); } } /** * Load the options previously selected by user for import/export of data in various Cells. */ @SuppressWarnings("unchecked") private void loadCellImportExportInfo() { CellImportExportInfoSaver saverInstance = null; try { XMLBeanReader doc = new XMLBeanReader(); doc.load(new ApplicationFiles().getCellImportExportSelectionsFile()); Iterator it = doc.iterator(); if (it.hasNext()) { saverInstance = (CellImportExportInfoSaver) it.next(); } } catch (FileNotFoundException ignore) { // Cell Import/Export file not found for user - first time user ran pgm. } catch (Exception ex) { // i18n[Application.error.loadcellselections=Unable to load Cell Import/Export selections from // persistant storage.] s_log.error(s_stringMgr.getString("Application.error.loadcellselections"), ex); } finally { // set the singleton instance of the Saver class to be the // instance just created by the XMLBeanReader CellImportExportInfoSaver.setInstance(saverInstance); } } /** * Save the options selected by user for Cell Import Export. */ private void saveCellImportExportInfo() { try { XMLBeanWriter wtr = new XMLBeanWriter(CellImportExportInfoSaver.getInstance()); wtr.save(new ApplicationFiles().getCellImportExportSelectionsFile()); } catch (Exception ex) { // i18n[Application.error.writecellselections=Unable to write Cell Import/Export options to // persistant storage.] s_log.error(s_stringMgr.getString("Application.error.writecellselections"), ex); } } /** * Load the options previously selected by user for specific cols to use in WHERE clause when editing * cells. */ @SuppressWarnings("all") private void loadEditWhereColsInfo() { try { XMLBeanReader doc = new XMLBeanReader(); doc.load(new ApplicationFiles().getEditWhereColsFile()); Iterator it = doc.iterator(); if (it.hasNext()) { editWhereCols = (EditWhereCols) it.next(); editWhereCols.setApplication(this); } } catch (FileNotFoundException ignore) { // Cell Import/Export file not found for user - first time user ran pgm. } catch (Exception ex) { // i18n[Application.error.loadcolsinfo=Unable to load Edit 'Where' Columns selections.] s_log.error(s_stringMgr.getString("Application.error.loadcolsinfo"), ex); } finally { // nothing needed here?? } } /** * Save the options selected by user for Cell Import Export. */ private void saveEditWhereColsInfo() { try { XMLBeanWriter wtr = new XMLBeanWriter(editWhereCols); wtr.save(new ApplicationFiles().getEditWhereColsFile()); } catch (Exception ex) { // i18n[Application.error.savecolsinfo=Unable to write Edit Where Cols options to persistant // storage.] s_log.error(s_stringMgr.getString("Application.error.savecolsinfo"), ex); } } /** * Load the options previously selected by user for specific cols to use in WHERE clause when editing * cells. */ @SuppressWarnings("all") private void loadDTProperties() { DTProperties saverInstance = null; try { XMLBeanReader doc = new XMLBeanReader(); doc.load(new ApplicationFiles().getDTPropertiesFile()); Iterator<Object> it = doc.iterator(); if (it.hasNext()) { saverInstance = (DTProperties) it.next(); DTProperties x = saverInstance; } } catch (FileNotFoundException ignore) { // Cell Import/Export file not found for user - first time user ran pgm. } catch (Exception ex) { // i18n[Application.error.loaddatatypeprops=Unable to load DataType Properties selections from // persistant storage.] s_log.error(s_stringMgr.getString("Application.error.loaddatatypeprops"), ex); } finally { // nothing needed here?? } } /** * Save the options selected by user for Cell Import Export. */ private void saveDataTypePreferences() { try { XMLBeanWriter wtr = new XMLBeanWriter(new DTProperties()); wtr.save(new ApplicationFiles().getDTPropertiesFile()); } catch (Exception ex) { // i18n[Application.error.savedatatypeprops=Unable to write DataType properties to persistant // storage.] s_log.error(s_stringMgr.getString("Application.error.savedatatypeprops"), ex); } } /** * Persists the specified category of preferences to file if the user has the * "always save preferences immediately" preference checked. * * @param preferenceType * the enumerated type that indicates what category of preferences to be persisted. */ public void savePreferences(PreferenceType preferenceType) { if (!_prefs.getSavePreferencesImmediately()) { return; } switch (preferenceType) { case ALIAS_DEFINITIONS: saveAliases(); break; case DRIVER_DEFINITIONS: saveDrivers(); break; case DATATYPE_PREFERENCES: saveDataTypePreferences(); break; case CELLIMPORTEXPORT_PREFERENCES: saveCellImportExportInfo(); break; case SQLHISTORY: saveSQLHistory(); break; case EDITWHERECOL_PREFERENCES: saveEditWhereColsInfo(); break; case WIKI_CONFIGURATION: saveUserSpecificWikiConfigurations(); break; default: s_log.error("Unknown preference type: " + preferenceType); } } public void addApplicationListener(ApplicationListener l) { _listeners.add(l); } public void removeApplicationListener(ApplicationListener l) { _listeners.remove(l); } /** * Setup applications Look and Feel. */ private void setupLookAndFeel(ApplicationArguments args) { /* * Don't prevent the user from overriding the laf is they choose to use * Swing's default laf prop */ String userSpecifiedOverride = System.getProperty("swing.defaultlaf"); if (userSpecifiedOverride != null && !"".equals(userSpecifiedOverride)) { return; } String lafClassName = args.useNativeLAF() ? UIManager.getSystemLookAndFeelClassName() : MetalLookAndFeel.class.getName(); if (!args.useDefaultMetalTheme()) { MetalLookAndFeel.setCurrentTheme(new AllBluesBoldMetalTheme()); } try { // The following is a work-around for the problem on Mac OS X where // the Apple LAF delegates to the Swing Popup factory but then // tries to set a 90% alpha on the underlying Cocoa window, which // will always be null if you're using JGoodies L&F // see http://www.caimito.net/pebble/2005/07/26/1122392314480.html#comment1127522262179 // This has no effect on Linux/Windows PopupFactory.setSharedInstance(new PopupFactory()); UIManager.setLookAndFeel(lafClassName); } catch (Exception ex) { // i18n[Application.error.setlaf=Error setting LAF] s_log.error(s_stringMgr.getString("Application.error.setlaf"), ex); } } @SuppressWarnings("deprecation") private void setupJDBCLogging() { // If logging has changed. if (_jdbcDebugType != _prefs.getJdbcDebugType()) { final ApplicationFiles appFiles = new ApplicationFiles(); final File outFile = appFiles.getJDBCDebugLogFile(); // Close any previous logging. DriverManager.setLogStream(null); if (_jdbcDebugOutputStream != null) { _jdbcDebugOutputStream.close(); _jdbcDebugOutputStream = null; } DriverManager.setLogWriter(null); if (_jdbcDebugOutputWriter != null) { _jdbcDebugOutputWriter.close(); _jdbcDebugOutputWriter = null; } if (_prefs.isJdbcDebugToStream()) { try { // i18n[Application.info.setjdbcdebuglog=Attempting to set JDBC debug log to output stream] s_log.debug(s_stringMgr.getString("Application.info.setjdbcdebuglog")); _jdbcDebugOutputStream = new PrintStream(new FileOutputStream(outFile)); DriverManager.setLogStream(_jdbcDebugOutputStream); // i18n[Application.info.setjdbcdebuglogsuccess=JDBC debug log set to output stream // successfully] s_log.debug(s_stringMgr.getString("Application.info.setjdbcdebuglogsuccess")); } catch (IOException ex) { final String msg = s_stringMgr.getString("Application.error.jdbcstream"); s_log.error(msg, ex); showErrorDialog(msg, ex); DriverManager.setLogStream(System.out); } } if (_prefs.isJdbcDebugToWriter()) { try { // i18n[Application.info.jdbcwriter=Attempting to set JDBC debug log to writer] s_log.debug(s_stringMgr.getString("Application.info.jdbcwriter")); _jdbcDebugOutputWriter = new PrintWriter(new FileWriter(outFile)); DriverManager.setLogWriter(_jdbcDebugOutputWriter); // i18n[Application.info.jdbcwritersuccess=JDBC debug log set to writer successfully] s_log.debug(s_stringMgr.getString("Application.info.jdbcwritersuccess")); } catch (IOException ex) { final String msg = s_stringMgr.getString("Application.error.jdbcwriter"); s_log.error(msg, ex); showErrorDialog(msg, ex); DriverManager.setLogWriter(new PrintWriter(System.out)); } } _jdbcDebugType = _prefs.getJdbcDebugType(); } } public void setUpdateCheckTimer(UpdateCheckTimer timer) { this.updateCheckTimer = timer; } public void setPreLaunchHelperFactory(PreLaunchHelperFactory preLaunchHelperFactory) { this.preLaunchHelperFactory = preLaunchHelperFactory; } /** * @param shutdownTimer the _shutdownTimer to set */ public void setShutdownTimer(IShutdownTimer shutdownTimer) { _shutdownTimer = shutdownTimer; } /** * @see net.sourceforge.squirrel_sql.client.IApplication#getWikiTableConfigFactory() */ @Override public IWikiTableConfigurationFactory getWikiTableConfigFactory() { return wikiTableConfigFactory; } public void setWikiTableConfigFactory(IWikiTableConfigurationFactory wikiTableConfigFactory) { this.wikiTableConfigFactory = wikiTableConfigFactory; } @Override public MultipleWindowsHandler getMultipleWindowsHandler() { return _multipleWindowsHandler; } @Override public RecentFilesManager getRecentFilesManager() { return _recentFilesManager; } }