/** Load from preferences file. */
private void loadPrefs() {
final FileWrapper oldPrefsFile =
fileWrapperFactory.create(_userSettingsFolder, OLD_USER_PREFS_FILE_NAME);
final FileWrapper newPrefsFile =
fileWrapperFactory.create(_userSettingsFolder, USER_PREFS_FILE_NAME);
final boolean oldExists = oldPrefsFile.exists();
final boolean newExists = newPrefsFile.exists();
try {
if (oldExists) {
loadOldPrefs(oldPrefsFile);
try {
_settingsCache.add(_lafPrefs);
} catch (DuplicateObjectException ex) {
s_log.error("LAFPreferences object already in cache", ex);
}
savePrefs(newPrefsFile);
if (!oldPrefsFile.delete()) {
s_log.error("Unable to delete old LAF preferences file");
}
} else if (newExists) {
loadNewPrefs(newPrefsFile);
}
} catch (IOException ex) {
s_log.error("Error occured in preferences file", ex);
} catch (XMLException ex) {
s_log.error("Error occured in preferences file", ex);
}
if (_lafPrefs == null) {
_lafPrefs = new LAFPreferences(IdentifierFactory.getInstance().createIdentifier());
_lafPrefs.setLookAndFeelClassName(MetalLookAndFeelController.METAL_LAF_CLASS_NAME);
try {
_settingsCache.add(_lafPrefs);
} catch (DuplicateObjectException ex) {
s_log.error("LAFPreferences object already in cache", ex);
}
}
}
class Session implements ISession {
private SessionSheet _sessionSheet;
/** The <TT>IIdentifier</TT> that uniquely identifies this object. */
private IIdentifier _id = IdentifierFactory.getInstance().createIdentifier();
/** Application API. */
private IApplication _app;
/** Connection to database. */
private SQLConnection _conn;
/** Driver used to connect to database. */
private ISQLDriver _driver;
/** Alias describing how to connect to database. */
private ISQLAlias _alias;
/** Properties for this session. */
private SessionProperties _props = new SessionProperties();
/**
* Objects stored in session. Each entry is a <TT>Map</TT> keyed by
* <TT>IPlugin.getInternalName()</TT>. Each <TT>Map</TT> contains the objects saved for the
* plugin.
*/
private Map _pluginObjects = new HashMap();
private IMessageHandler _msgHandler = NullMessageHandler.getInstance();
/**
* Create a new session.
*
* @param app Application API.
* @param driver JDBC driver for session.
* @param alias Defines URL to database.
* @param conn Connection to database.
* @throws IllegalArgumentException if any parameter is null.
*/
public Session(IApplication app, ISQLDriver driver, ISQLAlias alias, SQLConnection conn) {
super();
if (app == null) {
throw new IllegalArgumentException("null IApplication passed");
}
if (driver == null) {
throw new IllegalArgumentException("null ISQLDriver passed");
}
if (alias == null) {
throw new IllegalArgumentException("null ISQLAlias passed");
}
if (conn == null) {
throw new IllegalArgumentException("null SQLConnection passed");
}
_app = app;
_driver = driver;
_alias = alias;
_conn = conn;
_props.assignFrom(_app.getSquirrelPreferences().getSessionProperties());
}
public IIdentifier getIdentifier() {
return _id;
}
public IApplication getApplication() {
return _app;
}
/** @return <TT>SQLConnection</TT> for this session. */
public SQLConnection getSQLConnection() {
return _conn;
}
/** @return <TT>ISQLDriver</TT> for this session. */
public ISQLDriver getDriver() {
return _driver;
}
/** @return <TT>ISQLAlias</TT> for this session. */
public ISQLAlias getAlias() {
return _alias;
}
public SessionProperties getProperties() {
return _props;
}
/**
* Return an array of <TT>IDatabaseObjectInfo</TT> objects representing all the objects selected
* in the objects tree.
*
* @return array of <TT>IDatabaseObjectInfo</TT> objects.
*/
public IDatabaseObjectInfo[] getSelectedDatabaseObjects() {
return _sessionSheet.getObjectPanel().getSelectedDatabaseObjects();
}
public synchronized Object getPluginObject(IPlugin plugin, String key) {
if (plugin == null) {
throw new IllegalArgumentException("Null IPlugin passed");
}
if (key == null) {
throw new IllegalArgumentException("Null key passed");
}
Map map = (Map) _pluginObjects.get(plugin.getInternalName());
if (map == null) {
map = new HashMap();
_pluginObjects.put(plugin.getInternalName(), map);
}
return map.get(key);
}
public synchronized Object putPluginObject(IPlugin plugin, String key, Object value) {
if (plugin == null) {
throw new IllegalArgumentException("Null IPlugin passed");
}
if (key == null) {
throw new IllegalArgumentException("Null key passed");
}
Map map = (Map) _pluginObjects.get(plugin.getInternalName());
if (map == null) {
map = new HashMap();
_pluginObjects.put(plugin.getInternalName(), map);
}
return map.put(key, value);
}
public String getSQLScript() {
return _sessionSheet.getSQLScript();
}
public void setSQLScript(String sqlScript) {
_sessionSheet.setSQLScript(sqlScript);
}
public void closeSQLConnection() throws SQLException {
if (_conn != null) {
try {
_conn.close();
} finally {
_conn = null;
}
}
}
public IMessageHandler getMessageHandler() {
return _msgHandler;
}
public void setMessageHandler(IMessageHandler handler) {
_msgHandler = handler != null ? handler : NullMessageHandler.getInstance();
}
public void showMessage(Exception ex) {
_msgHandler.showMessage(ex);
}
public void showMessage(String msg) {
_msgHandler.showMessage(msg);
}
public void setSessionSheet(SessionSheet child) {
_sessionSheet = child;
}
public SessionSheet getSessionSheet() {
return _sessionSheet;
}
/**
* Select a tab in the main tabbed pane.
*
* @param tabIndex The tab to select. @see ISession.IMainTabIndexes
* @throws IllegalArgumentException Thrown if an invalid <TT>tabId</TT> passed.
*/
public void selectMainTab(int tabIndex) throws IllegalArgumentException {
_sessionSheet.selectMainTab(tabIndex);
}
/** Execute the current SQL. */
public void executeCurrentSQL() {
_sessionSheet.executeCurrentSQL();
}
/** Commit the current SQL transaction. */
public void commit() {
try {
getSQLConnection().commit();
getMessageHandler().showMessage("Commit completed normally."); // i18n
} catch (Exception ex) {
getMessageHandler().showMessage(ex);
}
}
/** Rollback the current SQL transaction. */
public void rollback() {
try {
getSQLConnection().rollback();
getMessageHandler().showMessage("Rollback completed normally."); // i18n
} catch (Exception ex) {
getMessageHandler().showMessage(ex);
}
}
/**
* Add a listener listening for SQL Execution.
*
* @param lis Listener
* @throws IllegalArgumentException If a null <TT>ISQLExecutionListener</TT> passed.
*/
public void addSQLExecutionListener(ISQLExecutionListener lis) throws IllegalArgumentException {
if (lis == null) {
throw new IllegalArgumentException("null ISQLExecutionListener passed");
}
_sessionSheet.getSQLPanel().addSQLExecutionListener(lis);
}
/**
* Remove an SQL execution listener.
*
* @param lis Listener
* @throws IllegalArgumentException If a null <TT>ISQLExecutionListener</TT> passed.
*/
public void removeSQLExecutionListener(ISQLExecutionListener lis)
throws IllegalArgumentException {
if (lis == null) {
throw new IllegalArgumentException("null ISQLExecutionListener passed");
}
_sessionSheet.getSQLPanel().removeSQLExecutionListener(lis);
}
}
